Viewing 15 posts - 1,381 through 1,395 (of 7,498 total)
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
Did you install SSMSToolspak [/url]? ( which is very good , but has this behavior by default, but you can change it)
April 18, 2012 at 2:45 am
HW is supposed to be ok, how about the batteries ? ( I/O caching on/off will be noticeable )
Did you try a scenario "disable index + load + enable index...
April 10, 2012 at 5:30 am
Can you post your sqlserver instance version information ( @@version ) so we are sure we're posting for the correct one ? ( rtm sp1/sp2 R2 R2sp1 )
April 10, 2012 at 4:01 am
Viewing 15 posts - 1,381 through 1,395 (of 7,498 total)