Viewing 15 posts - 41,881 through 41,895 (of 49,562 total)
winston Smith (1/8/2009)
January 8, 2009 at 11:30 am
Why are you storing and modifying large pieces of xml in a database? Why are these claims not in their own table?
January 8, 2009 at 11:22 am
When's the last log backup from before the full? Full backups don't truncate the log, so you have to look at the activity from the last tran log.
Full recovery? Bulk...
January 8, 2009 at 11:15 am
pcreddy9 (1/7/2009)
ok
Please don't edit your questions away. It just makes it confusing for everyone who reads it afterwards.
It's also polite to let us know if the solutions worked or not.
January 8, 2009 at 11:06 am
crfenix (1/8/2009)
January 8, 2009 at 10:48 am
winston Smith (1/8/2009)
I was told, in an sql course that when indexing for AND queries, always try to use an index on the most selective column.
I hate it...
January 8, 2009 at 10:12 am
There is no config switch that treats a real table as if it were a temp. If you're doing a select into a permanent table, it's a permanent table.
Are there...
January 8, 2009 at 10:04 am
sampathsoft (1/8/2009)
There are no any sql mechanism for it.
Excuse me?
SQL absolutely has the ability to lock rows been modified. It's an essential part of a relational database, isolation, the requirement...
January 8, 2009 at 9:41 am
T D McCallie (1/7/2009)
This bug ( http://support.microsoft.com/kb/947204/ ) is resolved in SQL/Server 2005 CU6 ( http://support.microsoft.com/kb/946608/ ).
That's internal objects (worktables, table spools, index spools, etc), not temp tables
January 8, 2009 at 4:56 am
Jack Corbett (1/7/2009)
GilaMonster (1/7/2009)
January 8, 2009 at 4:54 am
sampathsoft (1/8/2009)
January 8, 2009 at 4:53 am
Can you please post exactly what you get by running the following:
DBCC CHECKDB('msdb') WITH NO_INFOMSGS, ALL_ERRORMSGS
January 8, 2009 at 4:50 am
winston Smith (1/8/2009)
the actual clustered index/heap never needs to be accessed. am i correct in this idea?
Correct, all the info is in the index.
if this is the only index on...
January 8, 2009 at 4:36 am
What does the error log say? It should have some info about the shutdown, and it will have a lot of info about why the service won't start up.
January 7, 2009 at 11:34 pm
Turn traceflag 1222 on (DBCC TRACEON (1222,-1))
Any deadlocks that occur will have the deadlock graph written to the error log. The deadlock graph will have enough information to locate...
January 7, 2009 at 11:33 pm
Viewing 15 posts - 41,881 through 41,895 (of 49,562 total)