Viewing 15 posts - 37,321 through 37,335 (of 49,552 total)
It's complaining about the two-part naming in the order by, but you should just remove the order by and the Top 100 % completely. Order by is not honoured in...
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
July 31, 2009 at 2:14 pm
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/
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
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...
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
July 31, 2009 at 11:40 am
He already ran CheckDB, See the 4th post in this thread for the results.
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
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...
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
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?
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
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...
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
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....
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
July 31, 2009 at 8:48 am
I'll second the recommendation of the SQL Server Bible by Paul Nielson. Very good book.
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
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...
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
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.
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
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...
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
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...
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
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...
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
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...
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
July 30, 2009 at 3:30 pm
Viewing 15 posts - 37,321 through 37,335 (of 49,552 total)