Viewing 15 posts - 37,501 through 37,515 (of 39,758 total)
No more overhead than using the connections in DTS. Some people prefer to code them in ActiveX rather than the connection. They may get more flexibility. These are resources on...
July 2, 2002 at 10:31 am
check the inserted and deleted tables
OR
change the app to perform the logging in a transaction with the update.
Steve Jones
July 2, 2002 at 10:26 am
I tend to format CASE using indents (tabs) for the different lines.
SELECT
case
when x = 1
...
July 2, 2002 at 10:19 am
Don't really see anything in Technet or BOL related to this.
How much memory on the server? Does available memory decrease? Does SQL memory increase?
Run profiler and verify if anything else...
July 2, 2002 at 10:13 am
You'd have to write some type of loop or some complicated SQL to get this. Not sure how to remove the pub_id from the duplicate lines.
Steve Jones
July 2, 2002 at 10:08 am
EM will drop and create the table for you. Check the script if you want to learn how this works.
Steve Jones
July 2, 2002 at 10:02 am
Do you want these in separate columns? IF so, this doesn't make sense unless it is the distinct (size, color, width)
select distinct productsize, productcolor, productwidth
will give you this. If you...
July 2, 2002 at 9:58 am
I believe the only way to remove SP1 is a reinstall (detach dbs, uninstall, reinstall, attach). Not sure about SP2.
Steve Jones
July 2, 2002 at 9:52 am
AFAIK, you cannot backup to a remote tape. Can you backup to a drive on the tape server and then use the Backup utility to get these files?
Steve Jones
July 2, 2002 at 9:48 am
I'd guess network issue. Could be versioning.
Is there a reason you don't use DTS?
Steve Jones
July 2, 2002 at 9:43 am
What is SQL 97? SQL Server 7.0?
From BOL:Number of pages used for miscellaneous server purposes (including procedure cache).
This is the def for the stolen pages. If you have only 2...
July 2, 2002 at 9:41 am
This causes the maintenance plans to fail and is a known issue. Follow Andy's advice.
Steve Jones
July 2, 2002 at 9:35 am
Tend to agree with Andy. Large queries are problematic in that you cannot limit the CPU devoted to the process and this can "lock" the box. It will come back...
July 2, 2002 at 9:32 am
You'd have to use xp_cmdshell and call isql/osql to pipe to a text file, use DTS, or bcp.
Steve Jones
July 2, 2002 at 9:28 am
Viewing 15 posts - 37,501 through 37,515 (of 39,758 total)