Viewing 15 posts - 1,066 through 1,080 (of 18,926 total)
I got to remember that one!
http://www.sqlservercentral.com/Forums/Topic1206736-391-1.aspx
GilaMonster (11/16/2011)
ashuthinks (11/16/2011)
i.m just using this stored procedure for reporting purpose..please let me know my usage is at right or not?
Since when does reporting run...
November 16, 2011 at 8:03 am
SQLRNNR (11/16/2011)
jcrawf02 (11/16/2011)
Ninja's_RGR'us (11/16/2011)
Koen Verbeeck (11/16/2011)
Ninja's_RGR'us (11/16/2011)
Koen Verbeeck (11/15/2011)
Ninja's_RGR'us (11/15/2011)
jcrawf02 (11/15/2011)
Hey, I like the condensed version of The Thread...
Same here.
No offense if I forgot anything else. I didn't reread...
November 16, 2011 at 8:02 am
There's no deadlocks on selects.
Reports should have to delete anything in permanant tables.
Why do you need to delete the base tables' data for that report?
November 16, 2011 at 8:01 am
SQLRNNR (11/16/2011)
Ninja's_RGR'us (11/16/2011)
crookj (11/16/2011)
SQLRNNR (11/16/2011)
slipslip sliding away...
snow... as in first snow of the year tomorrow.
Don't hold your breath
Dude, I live way up there in the north 😀
November 16, 2011 at 8:00 am
Get the log size, do the math, then run the command =>
DECLARE @a INT
SET @a =10000000
DBCC SHRINKFILE(2, @a)
November 16, 2011 at 7:59 am
ashuthinks (11/16/2011)
i.m just using this stored procedure for reporting purpose..please let me know my usage is at right or not?
Why do you NEED to use this?
It's NOT a...
November 16, 2011 at 7:56 am
crookj (11/16/2011)
SQLRNNR (11/16/2011)
slipslip sliding away...
snow... as in first snow of the year tomorrow.
November 16, 2011 at 7:54 am
Ah! nice catch Gail.
Please don't cross post. It just wastes everyone's time and our answer won't change from one thread to another.
November 16, 2011 at 7:53 am
Only if you don't mind deleting the wrong data, or getting your connection killed (normal behavior with nolock).
http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
November 16, 2011 at 7:51 am
jcrawf02 (11/16/2011)
Ninja's_RGR'us (11/16/2011)
jcrawf02 (11/16/2011)
L' Eomot Inversé (11/15/2011)
"yell":
/*
AAAA AAAA AAAA AAAA RRRRR GGGG HH HH ######
AA...
November 16, 2011 at 7:49 am
jcrawf02 (11/16/2011)
Ninja's_RGR'us (11/16/2011)
Koen Verbeeck (11/16/2011)
Ninja's_RGR'us (11/16/2011)
Koen Verbeeck (11/15/2011)
Ninja's_RGR'us (11/15/2011)
jcrawf02 (11/15/2011)
Hey, I like the condensed version of The Thread...
Same here.
No offense if I forgot anything else. I didn't reread the...
November 16, 2011 at 7:48 am
Right now the only thing that makes any sort of sense in my mind is readuncommited isolation level to explain this. Since it seems it's not corruption.
Hopefully Gail has...
November 16, 2011 at 7:46 am
jcrawf02 (11/16/2011)
L' Eomot Inversé (11/15/2011)
"yell":
/*
AAAA AAAA AAAA AAAA RRRRR GGGG HH HH ######
AA AA...
November 16, 2011 at 7:45 am
Yes.
Now you need to define what months means in this case.
Change the where to a select to see exactly what it does and adjust accordingly.
November 16, 2011 at 7:39 am
DELETE FROM dbo.tbl
WHERE dt >= DATEADD(M, -2, GETDATE())
November 16, 2011 at 7:25 am
Viewing 15 posts - 1,066 through 1,080 (of 18,926 total)