Forum Replies Created
Viewing 15 posts - 35,791 through 35,805 (of 39,771 total)
-
RE: Update Table in diff DB, same server
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/
-
RE: Query Analyzer Tricks
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...
-
RE: DBA Functions
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...
-
RE: Tables used
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/
-
RE: Datetime: Need to store dates as old as 01/01/01
Use character fields
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Mapping Database File Objects and Fragmentation
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...
-
RE: Maximum length of a T-SQL Statement
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...
-
RE: How to open text file in Stored Procedure [SQL v7]
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/
-
RE: Transaction Log backup times increasing
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/
-
RE: Update Table in diff DB, same server
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...
-
RE: Point in Time restore
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/
-
RE: Reaching the Outer Limits
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...
-
RE: Same stored procedures on multiple databses
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...
-
RE: When Do You Pull Your Hair Out?
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/
-
RE: Update Table in diff DB, same server
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...
Viewing 15 posts - 35,791 through 35,805 (of 39,771 total)