“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.
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
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
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,
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
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