Viewing 15 posts - 3,406 through 3,420 (of 19,564 total)
When adding a post (and inside the editor), there is a button that says "Edit Attachments" near the bottom. You will probably need to scroll down to see it.
March 10, 2014 at 9:40 am
Do you mean within the forum post or within SQL server or within an SSRS report or something else?
March 10, 2014 at 9:36 am
GilaMonster (3/10/2014)
Jack Corbett (3/10/2014)
No just 90 minutes total, and that's probably actually longer than it'll actual take most days.
That's about what my commute is now, though it's closer...
March 10, 2014 at 9:24 am
Jack Corbett (3/10/2014)
To answer Jason's question. I'm in the process of accepting the first one because the 2nd one hasn't gotten back to me yet and I...
March 10, 2014 at 9:10 am
Jack Corbett (3/7/2014)
March 10, 2014 at 8:45 am
odeddror (3/10/2014)
In addition to that they called themselves Senior or consultant or even managerHow come you call yourself a senior developer and you don't basic staff
100% agree
Thanks,
Oded Dror
Welcome to the...
March 10, 2014 at 8:44 am
Ed Wagner (3/10/2014)
EricEyster (3/7/2014)
Revenant (3/7/2014)
EL Jerry (3/7/2014)
crookj (3/7/2014)
SQLRNNR (3/7/2014)
OregonTrail
Blazer
Basketball
Football
Da Bears
Shuffle
March 10, 2014 at 7:27 am
SQL Guy 1 (3/7/2014)
Question: if my database files sit all on one drive, will my query benefit from parallelism (even if query cost > threshold)?
Yes you could benefit from...
March 7, 2014 at 9:42 am
use dbcc inputbuffer(spid) using the spid of the session that is causing the blocking. That will help you find what query is being run that is causing the blocking....
March 7, 2014 at 9:38 am
Most likely the alter database is waiting infinitely to complete and thus holding up your checkdb.
You should try the alter database as follows
alter database blah
set single_user WITH ROLLBACK IMMEDIATE;
March 7, 2014 at 8:52 am
Sean Lange (3/7/2014)
SQLRNNR (3/6/2014)
I don't like the constant placement of a ; right before a CTE. It's wrong. A CTE does not require a ; in order to...
March 7, 2014 at 7:23 am
Grant Fritchey (3/7/2014)
It's not a wait I would look to eliminate, but one that I would mitigate depending on the circumstances.
I agree. +100
March 7, 2014 at 7:22 am
Viewing 15 posts - 3,406 through 3,420 (of 19,564 total)