Viewing 15 posts - 1,381 through 1,395 (of 7,502 total)
to lower the impact of your trigger, involve the trigger objects inserted/deleted.
In your case, this may be one of your queries ...
UPDATE B2
SET ...
April 26, 2012 at 12:21 am
can you work our an alternative ?
e.g; bcp out the wanted query to a file and send that file attached to a dbmail ?
April 25, 2012 at 4:00 am
JokerUK (4/25/2012)
Sorry - I did say in my first post about the partition - just reading about the sliding window now
Indeed. ( no offense intended here, nor in -any-...
April 25, 2012 at 2:35 am
Grant Fritchey (4/24/2012)
Wait, partitioned?Why not use the moving partition approach then? You don't delete anything. That's exactly what partitions are all about.
How come our bell didn't ring seeing the Table...
April 24, 2012 at 8:13 am
With sql2000 you'll have to use
use yourdb
EXEC dbo.sp_revokedbaccess N'username'
April 24, 2012 at 1:32 am
just my 2ct.
If your single transaction delete takes to long, a loop delete may be appropriate for your case.
declare @tranrows int
declare @rwcount int
set @tranrows = 50000
while 0=0
begin
...
April 23, 2012 at 10:34 am
onix-81 (4/19/2012)
hi, i'm new in this forum but i have a question, where i can find the sp_who2 script for sybase V15.5? thanks a lot.
For Sybase I wouldn't know. This...
April 20, 2012 at 1:07 am
keep in mind to also check your inserted set for duplicates.
April 18, 2012 at 7:09 am
How about replacing your IF (SELECT ISNULL(i.PRCode,'') FROM inserted AS i) = ''
with
IF exists ( SELECT * FROM inserted AS i where ISNULL(i.PRCode,'') = '' )
...
April 18, 2012 at 5:33 am
GilaMonster (4/18/2012)
ALZDBA (4/18/2012)
April 18, 2012 at 4:04 am
GilaMonster (4/18/2012)
ALZDBA (4/18/2012)
April 18, 2012 at 3:57 am
C3PO's twin (4/17/2012)
... I was wondering if people do a regular reboot of SQL as a general maintenace task.
No. It is concerned a bad practice because after startup of the...
April 18, 2012 at 3:13 am
and if it is being hosted on a virtual machine .... ask your VM/Hyper-V sysadmins to take a snapshot before you start your upgarde ! ( easy revert )
April 18, 2012 at 3:06 am
apparently someone applied DataTuningAdvisor indexes, which is BAD if applied blindly. _dta_index_TMPPACKAGEOPTION_Opti
IMO, because your query selects directly on the PK column, which is defined as clustering ix ( sql server...
April 18, 2012 at 3:03 am
Viewing 15 posts - 1,381 through 1,395 (of 7,502 total)