Viewing 15 posts - 45,136 through 45,150 (of 49,552 total)
andrew gothard (8/11/2008)
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
August 11, 2008 at 2:42 pm
I don't, but if you google you should be able to find some blog posts about it.
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
August 11, 2008 at 2:01 pm
Can you post the query please?
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
August 11, 2008 at 1:46 pm
Arun (8/11/2008)
Wouldnt it be nice if we have a debugger in Management Studio to debug SQL Commands Just like we debug .NET Programs.
Your wish has already been answered. There's a...
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
August 11, 2008 at 1:45 pm
If TempDB is full, then there isn't going to be any free space for shrink to release to the OS. You need to find out what's using the tempDB space...
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
August 11, 2008 at 1:04 pm
Can you post the table and index definitions for the tables involved in the query please?
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
August 11, 2008 at 12:59 pm
However, I have noticed that some of the indexes that showed as having fragmentation are not always "defragged" after reorganizing the index. The vendor DBA told me this is because...
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
August 11, 2008 at 12:59 pm
Wesley Brown (8/11/2008)
Gail,You made the statement as if it couldn't be done, and that isn't true.
I never said it could not be done. I said you're asking for an unresponsive...
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
August 11, 2008 at 12:45 pm
andrew gothard (8/11/2008)
Ever thought of expanding that slightly and submitting as an article on here?
Who's that aimed at?
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
August 11, 2008 at 12:12 pm
Wesley Brown (8/11/2008)
You can run /3GB if you have less than 16GB of ram installed on the server.
Sure you can. Doesn't make it a recommended good practice.
If 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
August 11, 2008 at 12:12 pm
I did a nice long calculation after someone asked me a very similar question in my TechEd session. Turned out, with a 100000 rows table, changing a nonclustered index key...
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
August 11, 2008 at 10:22 am
One question, was this database upgraded to SQL 2005 from SQL 2000 or from SQL 7?
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
August 11, 2008 at 10:14 am
Methinks badly behaving application.
It won't be the first time I've seen an application that went and fiddled with the system tables on SQL 2000.
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
August 11, 2008 at 10:06 am
Steve Jones - Editor (8/11/2008)
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
August 11, 2008 at 10:03 am
sunshine (8/11/2008)
Had to end up restoring 🙁
That's the best, preferred and recommended way to fix corruption.
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
August 11, 2008 at 9:53 am
Viewing 15 posts - 45,136 through 45,150 (of 49,552 total)