Viewing 15 posts - 166 through 180 (of 1,412 total)
Either that, or simply use one of the 3rd party tools mentioned above. Then you will not need to audit constantly and decrease performance. But you cannot do it with...
October 15, 2005 at 3:14 am
Extent numbers always refer to the first page (of 8) in the extent. So an extent number % 8 always equals 0.
October 14, 2005 at 7:45 am
With it being a beta (even if an RC) I would probably reinstall and see if that helps.
October 14, 2005 at 6:38 am
And another alternative is of course DBCC EXTENTINFO ('DBNAME')
October 14, 2005 at 6:36 am
How about:
DBCC PAGE (dbid, 1, 408680, printopt)
DBCC PAGE (dbid, 1, 408681, printopt)
DBCC PAGE (dbid, 1, 408682, printopt)
DBCC PAGE (dbid, 1, 408683, printopt)
DBCC PAGE (dbid, 1, 408684, printopt)
DBCC PAGE (dbid, 1,...
October 14, 2005 at 6:33 am
I found this KB support article that might have a solution. Although this discusses upgrading 2000 to 2005 the solution might still be applicable for your problem.
October 14, 2005 at 2:06 am
Like I said, it is not possible to change the page size, and thereby row size, in SQL Server. Why do you want to do this? There is probably a...
October 14, 2005 at 1:59 am
What do you mean exactly? If you are referring to the maximum size possible, that is not something you can change. Page size in SQL Server is fixed, and a...
October 14, 2005 at 1:20 am
But this query would not be able to use an index seek to find results. A where clause must be in a SARG format, that is column operator constant. The...
October 14, 2005 at 1:17 am
Also, if you are going to install VS2005 Beta2 and SQL Server 2005 April CTP, then uninstall everything SQL, VS and .NET related from the control panel -> Add/Remove Programs....
October 14, 2005 at 1:07 am
What security settings did you update in the OS? Did you change any policies concerning the account SQL Server runs as? Which account is it running as?
October 14, 2005 at 1:04 am
Uhm, the columns of the clustered index are always part of all non-clustered indexes. A covering index is a non-clustered index that includes all the columns (with the help of...
October 14, 2005 at 12:56 am
Well there is no supported way of doing this. The log file format is proprietary to Microsoft and it is not documented. There is an undocumented command to output some...
October 13, 2005 at 2:50 am
You should take a look at 3rd party tools such as Log PI or Lumigent Log Explorer.
October 13, 2005 at 1:42 am
Viewing 15 posts - 166 through 180 (of 1,412 total)