Viewing 15 posts - 36,151 through 36,165 (of 49,552 total)
Technically no, but understand what the two do.
Reorg shuffles the pages at the leaf level of an index back into order. It doesn't touch the non-leaf levels and it doesn't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 25, 2009 at 3:00 am
ravikanth. (10/24/2009)
3)DBCC FREEPROCCACHE to clear out old query plans.
Completely unnecessary. Plans are memory-only and don't survive a restart of the instance or a detach of the database. There's no way...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 25, 2009 at 2:59 am
mahesh.vsp (10/24/2009)
What is the use of the belowChange the database's page verify to Checksum
SQL 2000 only had the option to use torn page verification. Checksum, new in 2005, picks up...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2009 at 2:01 pm
Couple more things
After upgrading to SQL 2005/2008, do the following:
Change the database's page verify to Checksum
Run a checkDB with the Data Purity option
rebuild all indexes
update all column statistics with fullscan.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2009 at 1:27 pm
homebrew01 (10/24/2009)
However, if there were specific permissions on the table, they do not get recreated. How can I script them out ?
Not sure if there's a way from the GUI,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2009 at 11:39 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic808276-148-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2009 at 11:35 am
You can drop them any time. If you have auto_create_statistics set to true (database-level option) then if they are needed, they'll be recreated. That said, on larger tables creating stats...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2009 at 2:47 am
Then you need to look at the sys.dm_db_index_usage_stats DMV, look for indexes that aren't used, and start going through the queries on your system and see what indexes they use....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2009 at 2:41 am
repent_kog_is_near (10/23/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 4:33 pm
shane2174 (10/23/2009)
error:
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute
(referenced_major_id=498569310,referenced_minor_id=1) of row (class=0,object_id=235304048,column_id=0,referenced_major_id=498569310,referenced_minor_id=1)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 2:59 pm
repent_kog_is_near (10/23/2009)
Without using DBCC SHRINKFILE, how/when will the TLog size become lesser.?
Never.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 2:45 pm
CirquedeSQLeil (10/23/2009)
repent_kog_is_near (10/23/2009)
Is the Density column in SHOW_STATISTICS stored in any DMV, so I can see the values for all the index in one shot.
You can try the table valued...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 2:44 pm
No. The statistics-related info is only available via DBCC Show_Statistics. You can see the number of stats in the system (and whether they are recomputed) from sys.stats, but not the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 2:41 pm
Auto_Create_statistics allows stats to be created
sp_updatestats updates statistics
They do not do the same thing!
Overhead may be low or may not. You'll have to check. Otherwise you could use the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 7:15 am
Dave Ballantyne (10/23/2009)
Or get a statement trace of the same batch executing. Should give you a better idea of which statements to look for....
I can't get anything else, statement...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 7:13 am
Viewing 15 posts - 36,151 through 36,165 (of 49,552 total)