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
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)
September, 2010
MSDN Blogs
>
Microsoft SQL Server Tips & Tricks
>
September, 2010
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft SQL Server Tips & Tricks
Scan Count meaning in SET STATISTICS IO output: Part 2
Posted
over 3 years ago
by
AmruthaVarshiniJ
5
Comments
In my last blog post , I had explained what Scan Count means and how it is calculated for a query executed on a table. I had illustrated a few examples based on seeks/scans done on Clustered Indexes of a table. This time I shall expand this to clustered...
Microsoft SQL Server Tips & Tricks
Sometimes Replication Monitor shows number of Undistributed Transactions as a very high number, but replication itself works properly.
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
An overview of the inner working of a replication monitor We might see large number of Pending transactions on one of the Publisher in P2P replication. But when we check the Replication Monitor for second server (Subscriber) it might show a small...
Microsoft SQL Server Tips & Tricks
Upgrade to SQL 2008 from 2005 (cluster) fails with The cluster group 'SQL GROUP' could not be moved from node 'NODENAME1' to node 'null' , 0x8007139F
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
Problem We try to upgrade to SQL 2008 from SQL 2005 in a cluster setup and it fails on the Active node with the following error: From the Summary.txt There was an error during the SQL Server upgrade operation. Setup failed to move the failover...
Microsoft SQL Server Tips & Tricks
Upgrade from SQL Server 2008 to SQL Server 2008 R2 might fail with the error “Wait on the Database Engine Recovery Handle Failed”
Posted
over 3 years ago
by
AmruthaVarshiniJ
2
Comments
PROBLEM DESCRIPTION ================ · During upgrade from SQL Server 2008 to SQL Server 2008 R2 we might encounter an error as shown below Wait on the Database Engine Recovery Handle Failed. Check the SQL Server error log for potential...
Microsoft SQL Server Tips & Tricks
We would like your feedback !
Posted
over 3 years ago
by
AmruthaVarshiniJ
5
Comments
Microsoft SQL Server Tips & Tricks
SCAN COUNT meaning in SET STATISTICS IO output
Posted
over 3 years ago
by
AmruthaVarshiniJ
7
Comments
What does the Scan Count output in the SET STATISTICS IO output actually mean? I have seen multiple posts on the web regarding confusions and theories around this. As per Books Online , Scan Count is: Number of index or table scans performed. ...
Microsoft SQL Server Tips & Tricks
Troubleshooting Error 511 using XEvents
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
Now that we have XEvents in SQL Server 2008 and above, some of the issues that required us to capture SQL Server dumps or Profiler traces while reproducing an issue are passé. Move over DumpTrigger and Profiler, XEvents is here to replace you!...
Microsoft SQL Server Tips & Tricks
OPEN SYMMETRIC KEY command prevents query plan caching
Posted
over 3 years ago
by
AmruthaVarshiniJ
1
Comments
This was quite an interesting issue. We started troubleshooting a SQL Server blocking problem due to COMPILE lock blocking. The KB Article: Description of SQL Server blocking caused by compile locks explains why COMPILE lock blocking is encountered on...
Microsoft SQL Server Tips & Tricks
HOW TO IDENTIFY COMPRESSED TABLES BEFORE RESTORING/MIGRATING DATABASE to any edition other than Enterprise Edition of SQL Server 2008
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
PROBLEM DESCRIPTION =================== While trying to migrate the database from sql2008 enterprise to standard you get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed...
Page 1 of 1 (9 items)