Forum Replies Created
Viewing 15 posts - 35,746 through 35,760 (of 39,720 total)
-
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...
-
RE: Move DTS Packages to a Remote Server
Save them as a "Structured Storage file", which will be a .dts file on your local drive. Zip them, email them, whatever. On the remote machine, right click the "Data...
-
RE: Partial Restoration (Table)
Not sure I have a good answer, but here are a few thoughts.
There is no current way to load a single table. It was a great feature in 6.5, mainly...
-
RE: MSDE backup goal: minimal space/time
Not sure you can attach a filegroup. You can do a restore, so perhaps that is an option.
I believe snapshot replication can use ftp, but I'm not sure. Might do...
-
RE: Auditing DTS Packages
Very nice and an interesting idea for auditing packages. One question: Any issues with a trigger in msdb for patches/service packs? Not sure I like the idea of changing the...
-
RE: MSDE backup goal: minimal space/time
If the restores only need to be periodic and not up to the minute, then I'd use the "Simple" recovery model for each db. This will handle the logs for...
-
RE: MS SQL SERVER 2K - A noobs question
Do you mean a back TO another server? So your data is in two places?
You can use transactional replication. But the 2nd server is read only for the most part....
Viewing 15 posts - 35,746 through 35,760 (of 39,720 total)