Viewing 15 posts - 1 through 15 (of 19 total)
Thanks - that's the only thing I can think of as well.
Cheers
November 20, 2007 at 1:34 am
Thanks Steve. An open transaction / connection is the only thing I can think of but I was worried in case I was missing something else - the delay...
November 20, 2007 at 1:30 am
We have a similar problem with large log files that are being shipped - we are contemplating compressing the files using xp_makeCAB and xp_unpackCAB. Does anyone know about these SPs...
April 18, 2007 at 3:33 am
Thanks for all the advice - MUCH appreciated!
Cheers
November 9, 2006 at 1:47 am
The DTSRUN is not encrypted, it's the rest of it that is - that's the bit I'm trying to unravel. The original authors just right-clicked and scheduled - so it's...
March 20, 2006 at 7:36 am
Forgot about this classic!!
"C:\, C:\Dos\Run, C:\Windows\Crawl"
March 6, 2006 at 5:24 am
There was once a young man who, in his youth, professed a desire
to become a "great" writer. When asked to define "great", this is...
March 6, 2006 at 5:21 am
Hi,
Had two different occurances at two different companies. Both SQL 2000 one was with McAfee and other with Symantec.
Cheers
February 28, 2006 at 7:17 am
As far as I can tell it's not the full scan that does the damage to performance - it's the realtime scan! We found a major performance problem with a...
February 28, 2006 at 12:54 am
Idera's SQLdm is one of the best - I've known it since it was SQL Probe (and a lot cheaper!! ). It has...
January 5, 2006 at 1:08 am
Hi,
You don't insert into the column at all if it is set as IDENTITY or AUTONUMBER so your statement would look like this:
INSERT INTO AttorneyMaster(AttorneyTypeId,AttorneyFName,AttorneyMName,......)
values (AttorneyTypeId,AttorneyFName,AttorneyMName,.....);
Cheers
December 29, 2005 at 5:30 am
If you want a summary per ACCT_NO you could do something like this:
SELECT ACCT_NO as ACCOUNT_NUMBER,
TRADE1 = SUM(CASE
WHEN LDGR_NO = 800100 THEN LDGR_BAL_AM
ELSE 0
END),
TRADE2 = SUM(CASE...
December 29, 2005 at 1:29 am
Hi,
Try the following using a derived table to get a skill count for the problem in question and matching it against the employee with the required number of skills per...
December 28, 2005 at 1:39 am
You don't say if this has suddenly happened or if it has been that way since you installed SQL, also the version you are running would be a help.
We used...
December 28, 2005 at 12:47 am
Sorry about that, you need to put the statements in with the EXEC - I was having the same problem - I was concentrating on the syntax!!!
December 23, 2005 at 2:38 am
Viewing 15 posts - 1 through 15 (of 19 total)