Viewing 15 posts - 42,931 through 42,945 (of 49,552 total)
No version of SQL 2008 will run on Windows 2000. Below are the supported OS's for 2008 Express
Windows XP SP2 Home, Professional, Tablet, Media Center
Windows Server 2003 Small Business Server...
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
November 26, 2008 at 11:17 am
Bottom line, a good index is one that queries use.
Take a look at the queries that run against that table. Look at what's in the where clause, what the join...
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
November 26, 2008 at 11:05 am
Could you please explain a bit more what you're trying to do? I don't understand the question.
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
November 26, 2008 at 11:04 am
(Repeating post from http://www.sqlservercentral.com/Forums/FindPost609293.aspx)
Run all queries that affect that table with the execution plan option enabled. See which indexes they are using. Remove any that aren't used by any query....
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
November 26, 2008 at 10:37 am
Thread continues here: http://www.sqlservercentral.com/Forums/Topic609292-5-1.aspx
In the interests of keeping things together, no more replies to this thread 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
November 26, 2008 at 10:36 am
I'm not familiar with SQL 7. In SQL 2000's query analyser there was a button on the toolbar. If it's not ther, try SET SHOWPLAN_ALL ON, though that's a lot...
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
November 26, 2008 at 10:32 am
Run all queries that affect that table with the execution plan option enabled. See which indexes they are using. Remove any that aren't used by any query. make sure 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
November 26, 2008 at 10:16 am
Jeff Moden (11/26/2008)
Heh... check out ths clown...http://www.sqlservercentral.com/Forums/Topic607292-1424-2.aspx#608466
I'm not touching that with a 10 foot barge pole.
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
November 26, 2008 at 10:08 am
Just heard back and that does look like a driver issue. The Broadcom is known to give issues, no ideas about the others. MS won't write articles about other people's...
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
November 26, 2008 at 10:02 am
Optimise the queries so that the run as fast as possible and can use the indexes that you create.
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
November 26, 2008 at 9:59 am
Prior to SQL 2005, the only way is to drop the index.
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
November 26, 2008 at 9:57 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic608988-359-1.aspx
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
November 26, 2008 at 9:56 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic608988-359-1.aspx
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
November 26, 2008 at 9:56 am
<Sigh>
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
November 26, 2008 at 9:54 am
You can generate a trace script from profiler. All you'll need to do with the script is set an end time and a file name. Script to a fast drive...
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
November 26, 2008 at 9:52 am
Viewing 15 posts - 42,931 through 42,945 (of 49,552 total)