|
|
-
Chintak Chhapia Liked 6 Months ago through Blogs
Recently we have found that our index defragmentationjob is failing on a production server, due to REORGANIZE failure of one of our index. SQL Server was unable to REORGANIZE this index because mistakenly we have an index with the ALLOW_PAGE_LOCKS opt...
|
-
Chintak Chhapia refreshed 6 Months ago through Blogs
Recently we have found that our index defragmentationjob is failing on a production server, due to REORGANIZE failure of one of our index. SQL Server was unable to REORGANIZE this index because mistakenly we have an index with the ALLOW_PAGE_LOCKS opt...
|
-
Chintak Chhapia Liked 6 Months ago through Blogs
Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padd...
|
|
|
|
|
-
Chintak Chhapia Commented 6 Months ago through Blogs
You can use the build number 9.00.4035.00 and look for the service pack version. Don't know who is maintaining this site, but found this really useful and also updated regularly
http://sqlserverbuilds.blogspot.in/...
|
-
Chintak Chhapia Commented 6 Months ago through Blogs
@Aasim:- Last line (after ON) returned from @@version is OS information not the SQL server information. @@Version just returns the correct build number....
|
-
Chintak Chhapia incorrect 6 Months ago through Blogs
Recently, due to SQL Server Log message The time stamp counter of CPU on scheduler id 13 is not synchronized with other CPUs. we have decided to resolve it by installing Service Pack 3 for SQL Server 2005. To confirm, that target server has version prio...
|
|
|
|
|