Viewing 15 posts - 35,791 through 35,805 (of 39,771 total)
Not sure about that. In a limited test, it appears I get the same execution plan either way.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 16, 2003 at 10:01 am
Apologies on v7. Not sure how many of them work, but QA was a 1.0 product in 7 and substantially enhanced in 2000.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
October 16, 2003 at 9:44 am
Daily - Backups!! Make sure these work
Weekly - Run dbccs, maint plan helps here. Patches, etc. We have a weekly window available for maint. Don't always take it, but dbccs...
October 16, 2003 at 9:41 am
The only way to really do this is either run Profiler or use Entegra from Lumigent.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 16, 2003 at 9:34 am
Use character fields
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 16, 2003 at 9:33 am
Ditto the comment that I'm not sure this really matters to me, but it is interesting to see how SQL deal with space.
I'd be curious to see this graphically, but...
October 16, 2003 at 9:29 am
Not sure, but we've got Microstrategy running here and I have traced some SQL that is larger than anything I'd every write. We're talking 4+ printed pages of SQL in...
October 15, 2003 at 4:23 pm
bulk insert
Or use DTS
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 15, 2003 at 10:47 am
Strange. Haven't seen anything like this, but suspect you may need to call PSS on this one.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 15, 2003 at 10:43 am
what about two statements? One where the WHERE clause has
AND Cust.SendNews = 'Y'
AND ACL.SendNews = 'N'
and the other with the reverse? With an index on Sendnews, this may be faster.
Steve...
October 15, 2003 at 10:41 am
I believe that is correct.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 15, 2003 at 10:38 am
Perhaps. I like identities, but last year some of the Data Warehouse guys from MS said the GUID is faster. Identity tops out around 4000/sec?, I think.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
October 15, 2003 at 10:37 am
That's the method I'd use, but I have a batch file that connects to the appropriate dbs and I pass in the name of the scipt.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL...
October 15, 2003 at 10:14 am
Thanks, glad there are a few people who can appreciate my pain.![]()
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 15, 2003 at 10:08 am
Other than hardware, you might try running it in batches, so get a count and run 100 at a time or something. Sometimes that helps speed things up. Are there...
October 14, 2003 at 10:54 am
Viewing 15 posts - 35,791 through 35,805 (of 39,771 total)