Viewing 15 posts - 2,386 through 2,400 (of 2,756 total)
My thanks to Gail!
With her clarifying a few things for me (such as SQLs usage of multiple transaction log files) I was able to run a compression, shrink, clustered index...
June 24, 2013 at 5:40 am
Likely if you don't think you're using it, you're probably not (Filestream that is), but easy enough to check:
exec sp_configure 'filestream access level'
If the config value is 0, then Filestream...
June 21, 2013 at 6:28 am
OK, I don't know if this might help, but I found a similar issue elsewhere:
Yes, it's from 1999 and concerns Sybase, but it sure sounds like a similar...
June 20, 2013 at 1:25 pm
Excellent, thank you!
(So my bucket analogy was close, except the buckets are also on an escalator getting emptied out eventually and recycled to the bottom... 😉 )
Once more, thanks!
Jason
June 18, 2013 at 6:42 am
OK, I might have a solution to this, if what I've heard is correct:
Lets say I have a DB with two log files, lets call them log A and B,...
June 18, 2013 at 6:13 am
OK, thanks.
Sounds like I won't be compressing this index / table any time soon then, as using the current size of the index as a guideline I don't believe we've...
June 18, 2013 at 6:03 am
The Dixie Flatline (6/14/2013)
Hats for bats....Keep bats warm.
Get many hits.
Gracias
Up yer butt Jobu!
😀
June 14, 2013 at 10:39 am
wolfkillj (6/14/2013)
You got close, Rod, and we'll give you a pass since you're not American.
Here's the lineup:
1st base: Who
2nd base: What
3rd base: I Don't Know
Left field: Why
Center field: Because
Pitcher:...
June 14, 2013 at 8:06 am
Please 1gnore my pr3vious p0st
im not Sur3 wh4t came over mee
June 14, 2013 at 5:22 am
Brandie Tarvin (6/14/2013)
L' Eomot Inversé (6/13/2013)
Brandie Tarvin (6/13/2013)
+1000 to anyone who gets this reference.The Curator's bills are sent to Amelia Williams.
Does the Curator have a magic cat?
Weeeellll, it's more like...
June 14, 2013 at 5:21 am
Stefan Krzywicki (6/13/2013)
Grant Fritchey (6/13/2013)
Stefan Krzywicki (6/13/2013)
Grant Fritchey (6/13/2013)
Stefan Krzywicki (6/13/2013)
The Dixie Flatline (6/13/2013)
Sean Lange (6/13/2013)
Steve Jones - SSC Editor (6/13/2013)
The Dixie Flatline (6/13/2013)
Brandie Tarvin (6/13/2013)
The Dixie Flatline (6/13/2013)
June 13, 2013 at 11:50 am
Steve Thompson-454462 (6/13/2013)
Brandie Tarvin (6/13/2013)
jasona.work (6/13/2013)
One of those little "bored programmer" things...
June 13, 2013 at 8:25 am
Why can I picture something like that actually being buried in the depths of the SQL / SSIS code?
One of those little "bored programmer" things that's hidden in a comment...
June 13, 2013 at 6:24 am
Viewing 15 posts - 2,386 through 2,400 (of 2,756 total)