Viewing 15 posts - 41,386 through 41,400 (of 49,571 total)
ScottPletcher (1/27/2009)
It looks to me like SQL is using the non-clus index on the lookup table.
If you look at the exec plan, you'll notice it's a table scan on the...
January 27, 2009 at 4:39 pm
Just a note for the future. Please post SQL 2000-related questions in the SQL 2000 forums
January 27, 2009 at 4:37 pm
kevinsql7 (1/27/2009)
When you back up a sql server database and then restore it, is the restored database more efficient (as far as querying)?
No.
Does a simple backup (without any options...
January 27, 2009 at 1:20 pm
James Zhang (1/27/2009)
January 27, 2009 at 1:16 pm
Steve Jones - Editor (1/27/2009)
I believe it is. There's a company that lets you donate for purchases. I'll get the URL and put it up here
So you're buying from 2...
January 27, 2009 at 12:48 pm
noeld (1/27/2009)
So you advice still holds, do it at "off-peak" hours.
Absolutely. A former colleague of mine recently took down a business-critical system by deciding to create an index during peak...
January 27, 2009 at 12:46 pm
Steve Jones - Editor (1/27/2009)
We'll also give away 100 or...
January 27, 2009 at 10:46 am
Something like that.
One folder per database, and both database and log backups get time stamps. So, for 2 databases, I'd have something like this:
DB1\DB1_Full_20090101.bak
DB1\DB1_200901010800.trn
DB1\DB1_200901010815.trn
DB1\DB1_200901010830.trn
DB1\DB1_200901010845.trn
DB1\DB1_200901010900.trn
DB1\DB1_200901010915.trn
DB1\DB1_200901010930.trn
DB2\DB2_Full_20080101.bak
DB2\DB2_200901010800.trn
DB2\DB2_200901010815.trn
DB2\DB2_200901010830.trn
DB2\DB2_200901010845.trn
DB2\DB2_200901010900.trn
DB2\DB2_200901010915.trn
DB2\DB2_200901010930.trn
Now the maintenance plan can do that...
January 27, 2009 at 10:34 am
noeld (1/27/2009)
It is not the same to try on a desktop without user interaction than on an actively used server 😉
True, but I'd hope most servers are more powerful than...
January 27, 2009 at 10:30 am
Steve Jones - Editor (1/27/2009)
I don't mind cut and paste, but if you have me create a table(s), include a drop table(s) at the bottom.
That's why I use tempDB for...
January 27, 2009 at 10:20 am
clperez271172 (1/27/2009)
January 27, 2009 at 10:14 am
John Reid (1/27/2009)
January 27, 2009 at 9:59 am
Bob Hovious (1/27/2009)
January 27, 2009 at 9:50 am
Lee Hart (1/27/2009)
The way things are generally done here at my work, is the backup file is just manually deleted and a backup is re-run. No biggy...I guess.
No biggie?
By...
January 27, 2009 at 9:48 am
Steve Jones - Editor (1/27/2009)
I thought you could configure flat file logs, but I'm not sure how "queryable" they would be with OPENQUERY.
I'm pretty sure that logs can be configured,...
January 27, 2009 at 9:47 am
Viewing 15 posts - 41,386 through 41,400 (of 49,571 total)