Viewing 15 posts - 32,566 through 32,580 (of 49,552 total)
Scott-144766 (6/8/2010)
In some parts of the world it's even becoming a greater problem than historically, because of strains of drug-resistant forms that are starting to appear.
And when you combine TB...
June 8, 2010 at 8:04 am
Don Stevic (6/8/2010)
I am not sure why this is, but I haven't found a way around it as yet.
I can think of one reason. Security. Think what the...
June 8, 2010 at 7:38 am
Scott-144766 (6/7/2010)
Sadly, tuberculosis isn't a thing of the past like smallpox. It infects a third of the world's population and kills over a million people a year.
In some parts of...
June 8, 2010 at 7:30 am
Abrar Ahmad_ (6/8/2010)
Please, let try to be focus on generic questions stated in start of thread, so we can all benefit from it.
The answer to your generic question is 'it...
June 8, 2010 at 7:28 am
You can use the STATS_DATE() function to see when stats were last updated. It won't tell you if they need updating, just when they were updated.
June 8, 2010 at 6:30 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/Topic933903-391-1.aspx
June 8, 2010 at 6:07 am
Please post your new question in a new thread.
June 8, 2010 at 1:27 am
Generally rollback operations take as long to complete as the operation did until that opoint, or longer. If the delete was running (not blocked) for 2 days in a single...
June 8, 2010 at 1:15 am
Please post new questions in a new thread. Include the complete output of the following.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
June 8, 2010 at 1:07 am
sanjays-735734 (6/7/2010)
I would like to add something in Your "simple example"...
IF EXISTS(SELECT 1 FROM ... WHERE...)
Instead of this Use following...
IF EXISTS(SELECT TOP(1) 1...
June 7, 2010 at 9:15 am
Don't use Profiler, too much impact. Server-side trace is much better for long-term tracing.
June 7, 2010 at 8:20 am
Some DML operations can cause fragmentation. Deletes will never, updates and inserts may, depending what they do.
Some DML operations can make statistics outdated, depending what they do.
It's trivially possible to...
June 7, 2010 at 6:05 am
Please post execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 7, 2010 at 5:32 am
Viewing 15 posts - 32,566 through 32,580 (of 49,552 total)