Viewing 15 posts - 42,946 through 42,960 (of 49,571 total)
Garadin (11/26/2008)
November 26, 2008 at 12:27 pm
kotlas7 (11/26/2008)
But One thing still confusing me..In BOL, they mentioned tail backup is introduced in SQL Server 2005. But it also working in sql server 2000.
No, they don't...
November 26, 2008 at 12:17 pm
What does the query for the report look like? Can you do the calculation there?
November 26, 2008 at 12:07 pm
Ok, I've never actually tried running both. Isn't needed. If what you want is to take a log backup and switch the DB into recovery to prevent more changes before...
November 26, 2008 at 12:05 pm
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...
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...
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.
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....
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.
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...
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...
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.
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...
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.
November 26, 2008 at 9:59 am
Prior to SQL 2005, the only way is to drop the index.
November 26, 2008 at 9:57 am
Viewing 15 posts - 42,946 through 42,960 (of 49,571 total)