Viewing 15 posts - 3,406 through 3,420 (of 19,560 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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2014 at 9:10 am
Jack Corbett (3/7/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 10, 2014 at 7:27 am
Woohoo, it depends.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 9, 2014 at 11:58 pm
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2014 at 9:38 am
Good to hear it is resolved.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2014 at 9:31 am
Oregon
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2014 at 8:57 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;
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 7, 2014 at 7:22 am
Viewing 15 posts - 3,406 through 3,420 (of 19,560 total)