Viewing 15 posts - 36,166 through 36,180 (of 49,562 total)
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
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...
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....
October 24, 2009 at 2:41 am
repent_kog_is_near (10/23/2009)
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)...
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.
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...
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...
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...
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...
October 23, 2009 at 7:13 am
fred2002 (10/23/2009)
we have restricted the log file autogrowth to control it.Therefore we have resized the max log size
So to prevent an error that's cause when the log file is too...
October 23, 2009 at 7:09 am
There's an article on the basics of indexing that will be published on Monday. It has a section on seeks and scans and is written for a novice/beginner. Might be...
October 23, 2009 at 7:05 am
Turns out there are around 1500 batches in that plan. 🙁 No wonder SSMS isn't happy. I think I'm just going to end up reading the plan in raw XML...
October 23, 2009 at 6:47 am
alex_ortega (10/23/2009)
But I'd like to know if using INNER JOIN has less IO cost on DB than using a regular T1.PK1 = T2.FK2 ??
Nope. Optimiser will generate identical execution plans....
October 23, 2009 at 6:43 am
Forget the loop, that update's wrong.
Unless there's only one for in Table2, there is no way that SQL can tell which row in table2 it should use to update which...
October 23, 2009 at 6:15 am
Viewing 15 posts - 36,166 through 36,180 (of 49,562 total)