Viewing 15 posts - 37,336 through 37,350 (of 49,566 total)
Have you read these blog posts?
http://tomlarock.com/2009/07/sql-server-consolidation/
http://tomlarock.com/2009/07/sql-server-consolidation-part-deux/
http://tomlarock.com/2009/07/sql-server-consolidation-part-trois/
July 31, 2009 at 1:16 pm
bmannar (7/31/2009)
if we run the entire script (mentioned in my previous post) it fixed it sometimes...We fix most of our common dbcc issues by running (checkpoint..... )
In that case you...
July 31, 2009 at 11:40 am
He already ran CheckDB, See the 4th post in this thread for the results.
July 31, 2009 at 10:53 am
The only free training events down where I live are usergroup meetings and Microsoft's DevDays and TechDays (which happen once a year). I make a point of going to those...
July 31, 2009 at 9:15 am
What's the query that you're running? If you run the query with the actual exec plan option on, do you see the execution plan?
July 31, 2009 at 8:55 am
Please post execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
The first two things I'd do here would be to replace the table variables with temp tables and to get rid of that while...
July 31, 2009 at 8:55 am
Rajesh kasturi (7/31/2009)
I apologies for putting MCITP, I removed it.
Nothing wrong with having the cert listed in your Sig if you've earned it. I used to have all mine listed....
July 31, 2009 at 8:48 am
I'll second the recommendation of the SQL Server Bible by Paul Nielson. Very good book.
July 31, 2009 at 3:28 am
Ian Scarlett (7/31/2009)
Am I the only one that seems to have these problems?
Nope. Go back many pages in this thread and you'll find my tales of woe of dealing with...
July 31, 2009 at 3:06 am
Why? Why 2000 and not 2005?
There are a lot of good books for SQL 2000 that will give you tonnes of info.
July 31, 2009 at 2:41 am
There's no easy way. You can query the plan cache (sys.dm_exec_cached_plans, sys.dm_exec_query_stats, sys.dm_exec_sql_text), but that'll only tell you if the procedure's in cache. There are a number of reasons why...
July 31, 2009 at 1:18 am
meandnayan (7/30/2009)
I know that the code without IF statements would be better enough than a code with IF statements.
Maybe
But, just a matter of curiosity, will the IF statements perform really...
July 31, 2009 at 1:11 am
I am so happy to be consulting these days. The only time I work a 50 or more hour week is when I've misjudged the workload, so I only have...
July 30, 2009 at 3:39 pm
It means pretty much what it says, SQL's detecting IO requests that take more than 15 seconds to complete. That is, the time between SQL issuing an IO request to...
July 30, 2009 at 3:30 pm
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 30, 2009 at 3:28 pm
Viewing 15 posts - 37,336 through 37,350 (of 49,566 total)