Viewing 15 posts - 15,706 through 15,720 (of 19,560 total)
As Gail and Paul said, it depends.
And, you are welcome.
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 31, 2010 at 10:40 am
Chris Morris-439714 (3/31/2010)
CirquedeSQLeil (3/31/2010)
Chris Morris-439714 (3/31/2010)
Paul White NZ (3/31/2010)
HR read your posts???
SSC HR...
Oh. They monitor these threads?
You work for SSC (redgate)?
It was probably a report, Jasey-wasey. I work for...
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 31, 2010 at 9:44 am
Sergeant Schultz - I know nothing.
ROFLOL
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 31, 2010 at 9:35 am
I advise against trying to do the detach and reattach without a log file. I have seen far too many issues arise from this method (i.e. database will not...
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 31, 2010 at 9:34 am
Paul White NZ (3/31/2010)
Chris Morris-439714 (3/31/2010)
Paul White NZ (3/31/2010)
HR read your posts???SSC HR...
Really? Wow! I feel decidedly left out now 🙁
You must have used some really, er, enthusiastic...
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 31, 2010 at 9:30 am
Chris Morris-439714 (3/31/2010)
Paul White NZ (3/31/2010)
HR read your posts???
SSC HR...
Oh. They monitor these threads?
You work for SSC (redgate)?
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 31, 2010 at 9:27 am
You're welcome.
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 31, 2010 at 9:26 am
GSquared (3/31/2010)
GilaMonster (3/30/2010)
CirquedeSQLeil (3/30/2010)
Those don't grate on me nearly as much as changing my name.i.e.
Thanks Jase
You're complaining?
You know how many ways there are to misspell either a 4-letter name...
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 31, 2010 at 9:25 am
george sibbald (3/31/2010)
GSquared (3/31/2010)
GilaMonster (3/30/2010)
CirquedeSQLeil (3/30/2010)
Those don't grate on me nearly as much as changing my name.i.e.
Thanks Jase
You're complaining?
You know how many ways there are to misspell either a...
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 31, 2010 at 9:23 am
keepintouch2b (3/30/2010)
Based on what I read, Table variables and CTE are using memory (RAM).
If a store proc uses either one of them, then developer...
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 30, 2010 at 10:58 pm
Matt Miller (#4) (3/30/2010)
Lynn Pettis (3/30/2010)
Okay, it's getting mighty deep in here. Time to get the hippo to clear out the tent! 😛
Jeff's "fastest way to clear a...
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 30, 2010 at 10:53 pm
Another thing on if the tempdb is growing unexpectedly and is growing rapidly. I outlined some methods to find the root cause of those growths. You will need...
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 30, 2010 at 10:53 pm
Lynn Pettis (3/30/2010)
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 30, 2010 at 10:26 pm
Fal (3/30/2010)
However, my 2...
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 30, 2010 at 10:01 pm
Nice question
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 30, 2010 at 9:58 pm
Viewing 15 posts - 15,706 through 15,720 (of 19,560 total)