“I am using SQL Server 2005. When I was doing modification to my database, I found that some of the data has already been modified.
Category: SQL 2005
Microsoft Support policy for SQL Server in Windows 8 and Windows 2012
Now that Windows 8 (which btw ROCKS!) and Windows 2012 is out, Microsoft has released a KB highlighting the support for SQL Server in respect
How to find out what is causing page splits?
Client was noticing high number of Page Splits/sec in relation to Batch Request/sec; however could not figure out why. They were not have performance issue but
Unable to Delete Records in using API Cursors
I am not very familer with the internals of API Cursors; so this was an annoying problem to solve. I was working with web guy,
SQL Server Integration Services Issue (Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum))
TITLE: Microsoft SQL Server Management Studio —————————— Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 —————————— ADDITIONAL INFORMATION: The SQL server
Adding new disk resource to cluster
My current configuration includes two node cluster with active-passive configuration. I had requested the Storage team to add a new LUN to the Cluster so
SQL Canada (SQLCAN) 