Sign in
MSDN Blogs
Microsoft Blog Images
More ...
Microsoft SQL Server Tips & Tricks
Tips and Tricks for the SQL Server Enthusiast
RSS for posts
Database Engine
blogs
Analysis services
blogs
Reporting services
blogs
Integration services
blogs
Data access tech blogs
Database Engine videos
Analysis services videos
Reporting services videos
Integration services videos
Data access tech Videos
Common Tasks
Blog Home
Email Blog Author
About
RSS for comments
RSS for posts
Atom
Search
Tags
analysis services
Backup
Cluster
DBVideo
Encryption
Installation
OLAP
Performance
query plan
replication
Security
Setup
SQL
sql 2000
sql 2005
SQL 2008
SQL query plan
SQL Server
SQL Server 2000
SQL Server 2005
sql Server 2008
SQL Server 2008 R2
Transactional Replication
update statistics
Upgrade
Archives
Archives
May 2013
(1)
April 2013
(2)
March 2013
(1)
December 2012
(2)
June 2012
(7)
May 2012
(1)
April 2012
(3)
March 2012
(5)
February 2012
(4)
January 2012
(3)
December 2011
(4)
November 2011
(3)
October 2011
(4)
September 2011
(1)
August 2011
(5)
July 2011
(3)
June 2011
(6)
May 2011
(10)
April 2011
(1)
March 2011
(1)
February 2011
(6)
January 2011
(3)
December 2010
(4)
November 2010
(2)
October 2010
(4)
September 2010
(9)
August 2010
(4)
June 2010
(4)
May 2010
(15)
April 2010
(18)
March 2010
(18)
February 2010
(7)
December 2009
(8)
November 2009
(7)
October 2009
(10)
September 2009
(6)
August 2009
(13)
July 2009
(5)
June 2009
(15)
May 2009
(5)
April 2009
(15)
March 2009
(15)
February 2009
(8)
January 2009
(9)
December 2008
(5)
November 2008
(2)
October 2008
(10)
September 2008
(5)
August 2008
(2)
July 2008
(7)
June 2008
(4)
May 2008
(1)
April 2008
(1)
MSDN Blogs
>
Microsoft SQL Server Tips & Tricks
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft SQL Server Tips & Tricks
INF: You may not be able to change the Design of a Table (Insert or Delete a Column) using GUI.
Posted
over 1 year ago
by
Balmukund
1
Comments
We recently worked on an issue where modifying a Table from the GUI was not allowed even though the account had read – write permissions. So, we are sharing our findings below: Let’s say you have a SQL account ‘ Account_1’ with following Database...
Microsoft SQL Server Tips & Tricks
Policy Based Management
Posted
over 1 year ago
by
Harsh Chawla
2
Comments
Check our video blog, and get answers to your queries related to "Policy Based Management" in SQL server. This feature is helpful to ensure compliance at SQL server end. This blog will cover: What is Policy Based Management? What is facets? How we can...
Microsoft SQL Server Tips & Tricks
Hey Mr. SSMS! Why I am unable to open .sql files using by double click
Posted
over 1 year ago
by
Balmukund
8
Comments
For SQL Server 2008/2008 R2 installed on Win 7/Windows Server 2008, if we attempt to open .sql files with SSMS closed, the file does not open up in Management studio. The SSMS windows will just open (as below) but the file will not be displayed. If the...
Microsoft SQL Server Tips & Tricks
NORECOMPUTE : Can lead to SQL server performance degradation!!
Posted
over 1 year ago
by
Harsh Chawla
0
Comments
ANALYSIS :- In this case when we captured PSSDiag and noticed huge recompiles due to AutoStat updates, here’s a snippet of what we noticed in SQL Server 2005 Vs SQL Server 2008 on the same machine. SQL 2008 ========= EventID Occurrences Description...
Microsoft SQL Server Tips & Tricks
Procedure Cache-Part II
Posted
over 2 years ago
by
Harsh Chawla
1
Comments
Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing your application and SQL server performance. Procedure Cache , main goal is to cache the query plans and allow its reuse and thus minimize the compile...
Microsoft SQL Server Tips & Tricks
Procedure cache - Part I
Posted
over 2 years ago
by
Harsh Chawla
0
Comments
Refer to our video blog , to know the important role that "Procedure Cache" can play in increasing your application and SQL server performance. Procedure Cache , main goal is to cache the query plans and allow its reuse and thus minimize the compile...
Microsoft SQL Server Tips & Tricks
Troubleshooting Kerberos Delegation Using DelegConfig
Posted
over 2 years ago
by
Harsh Chawla
0
Comments
Gain an expertise in solving the "Kerberos Delegation" issues using one of the useful troubleshooting tool for Kerberos i.e. DelegConfig. Refer to our video blog, that will provide you a step by step guidelines as to how to use this tool in resolving...
Microsoft SQL Server Tips & Tricks
What's execution log in Reporting services?
Posted
over 2 years ago
by
Harsh Chawla
0
Comments
Check out our video blog to gain in depth knowledge about importance of "Execution Log" in reporting services. In this blog you will get to know more about the following :- What is execution log? Where to check for execution log? Information...
Microsoft SQL Server Tips & Tricks
Transparent Data Encryption (TDE)
Posted
over 2 years ago
by
Harsh Chawla
0
Comments
Leverage our video blog to empower your knowledge on TDE. Highlights of this video blog :- 1. Introduction to TDE 2. How to implement TDE. 3. Advantages of TDE 4. Changing DEK 5. Removing Encrypted database 6. Migrating the encrypted database ...
Microsoft SQL Server Tips & Tricks
Demystifying SQL server memory concepts video
Posted
over 2 years ago
by
Harsh Chawla
2
Comments
Leverage our video blog to empower your knowledge on "SQL Memory".This video will help you to gain in depth expertise to following topics :- 1. More about Process Address Space 2. SQL Server 32 bit Memory Architecture 3. AWE 4. Managing SQL Server...
Microsoft SQL Server Tips & Tricks
SQL server service pack installation may fail if your instance name is a Windows reserved word
Posted
over 2 years ago
by
Harsh Chawla
4
Comments
Okay, so I woke up one morning and decided that this was a good day to patch my SQL Server 2008 R2 instance (named LPT2) to Service Pack 1. So I just downloaded the service pack from the Microsoft Website, ran it, went through the screens and clicked...
Microsoft SQL Server Tips & Tricks
Multiserver administration
Posted
over 2 years ago
by
Harsh Chawla
0
Comments
In this video presentation you will learn in depth about Multiserver administration For better quality/download please check the link: - http://channel9.msdn.com/posts/Multi-server-Administration Presented by: Phani Raj,SE,Microsoft GTSC ...
Microsoft SQL Server Tips & Tricks
Your SQL Server Setup may hang forever when it’s almost at the 99 %!
Posted
over 2 years ago
by
Balmukund
0
Comments
Consider this scenario, I rebooted several times, disabling my favourite antivirus and still unable to get a clue from all the logs possible. I start looking at my favourite blogs and here I am. Check out if your symptoms match the following. “ I am installing...
Microsoft SQL Server Tips & Tricks
SQL Server could not create a subscription for Subscriber 'Servername\InstanceName'.The value for the @sync_method parameter is not valid
Posted
over 2 years ago
by
Balmukund
0
Comments
Recently we worked on a support case where creation of a Subscription was failing with the following error:- TITLE: New Subscription Wizard ------------------------------ SQL Server could not create a subscription for Subscriber 'Servername\InstanceName...
Microsoft SQL Server Tips & Tricks
DDL Triggers
Posted
over 2 years ago
by
Harsh Chawla
0
Comments
Hello Everyone, In this presentation, you will learn about what are DDL triggers and how they could help you in day to day DBA activities. Presented by: Niraj Mehta
Microsoft SQL Server Tips & Tricks
The mystery of incorrect filegroup size
Posted
over 2 years ago
by
Harsh Chawla
1
Comments
Recently, there was a question that why the SQL Server DMVs were reflecting incorrect information with respect to the size of the indexes, files and filegroups. The following data supported the question: SELECT TOP 50 OBJECT_NAME(p.object_id) AS table_name...
Microsoft SQL Server Tips & Tricks
Creating stoplist on database of compatibility 80/90 in SQL server 2008
Posted
over 2 years ago
by
Harsh Chawla
0
Comments
Introduction : In this blog we will see how to add a stopword in a stoplist and also look at one of the common scenario which DBA face when they upgrade from SQL 2000\2005 to 2008 keeping compatibility level 80. So to introduce the topic lets know few...
Microsoft SQL Server Tips & Tricks
Another reason of Index logical fragmentation!
Posted
over 2 years ago
by
Harsh Chawla
0
Comments
Problem Description: Indexes gets fragmented soon after rebuilding index Detailed description You have a table with index created on it. Logical Fragmentation for the index comes to 99 %. You did re-indexing of the index with Rebuild option...
Microsoft SQL Server Tips & Tricks
Implementing SSL encryption for SQL Server in a DNS forwarding environment
Posted
over 2 years ago
by
Harsh Chawla
2
Comments
Let’s say you have an environment which implements DNS forwarding. In such a setup, the client uses a different name (or FQDN) while connecting to SQL Server than the actual SQL Server name (or FQDN). The connection request is forwarded to actual SQL...
Microsoft SQL Server Tips & Tricks
SQL Server Deadlocks Due to Character Data Type Conversion When Using SQL Server JDBC drivers
Posted
over 2 years ago
by
Harsh Chawla
3
Comments
Recently, I worked on a case with one of my clients wherein SQL Server was encountering several deadlocks when they were running Stress Tests from application. They had tried several techniques to resolve this issue including forcing an index on the query...
Microsoft SQL Server Tips & Tricks
Moving data from the mdf file to the ndf file(s)
Posted
over 2 years ago
by
Harsh Chawla
1
Comments
SCENARIO: 1)You have an MDF file from a database which has grown up to a size that has almost exhausted the disk space. 2)You now want to keep the MDF from growing further. 3)You also want to transfer the data from the MDF file to the NDF file...
Microsoft SQL Server Tips & Tricks
How to Convert UTC Time to Local Time in SQL
Posted
over 2 years ago
by
Harsh Chawla
1
Comments
There currently isn’t a way in T-SQL to convert UTC Time to Local time; however this seems to be a common issue people are facing. Here is how we could resolve this by writing a simple C# code and deploying it to SQL. This can easily be achieved...
Microsoft SQL Server Tips & Tricks
What's Performance Dashboard and how it can help in troublehsooting SQL issues.
Posted
over 2 years ago
by
Harsh Chawla
0
Comments
In this presentation you learn about: 1. How to install performance dashboard 2. How to use performance dashboard 3. Demos of performance dashboard usage in bad performance scenarios For better quality please check the link:- http://channel9...
Microsoft SQL Server Tips & Tricks
What are SQL server audits - a new feature in SQL server 2008
Posted
over 2 years ago
by
Harsh Chawla
2
Comments
In this presentation, you will learn about the complete description of the SQL audits , their benefits along with brief demos. For watching the video in better quality please check the link: - http://channel9.msdn.com/posts/What-are-SQL-server-audits...
Microsoft SQL Server Tips & Tricks
What are plan guides and how it could help in managing performance of the queries
Posted
over 2 years ago
by
Harsh Chawla
1
Comments
In this presentation, you will learn about what are the plan guides and how they could help the DBAs to manage the performance of the queries when change in the application is not feasible To see the video in better quality please click on the link...
Page 2 of 13 (314 items)
1
2
3
4
5
»