Viewing 15 posts - 35,821 through 35,835 (of 39,804 total)
Thanks
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 17, 2003 at 9:46 am
There isn't a way to do this after the fact. There is no "audit" of tables used or altered, only those that are created.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
October 17, 2003 at 9:45 am
This doesn't really make sense. Are there answers stored somewhere? What's with all the "testxxx" rows?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 17, 2003 at 9:44 am
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
Viewing 15 posts - 35,821 through 35,835 (of 39,804 total)