Viewing 15 posts - 17,341 through 17,355 (of 19,560 total)
Thanks Ron for posting that info.
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
February 14, 2010 at 8:31 pm
Lutz, It would definitely be better to let SQL determine what data got cached. That was one of the points made in the article I referenced. Another point...
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
February 14, 2010 at 8:28 pm
I think you might find this thread to be an interesting read.
It is suggested to use Global temp tables there. However, temp tables are not stored entirely in memory.
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
February 14, 2010 at 3:57 pm
I have seen examples of people doing it. They build a pretty good case for it and without performance problems.
I don't do it that way myself.
The answer 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
February 14, 2010 at 3:51 pm
d'oh
I missed this question due to going with documentation stating that 0 is the value that should be set.
Most people have missed it so far - and that is kind...
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
February 14, 2010 at 3:41 pm
Jeff - nice followup
sandhyarao49 - 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
February 14, 2010 at 3:32 pm
GilaMonster (2/14/2010)
CirquedeSQLeil (2/13/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
February 14, 2010 at 1:44 am
Goal review time
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
February 14, 2010 at 12:31 am
Please read the article by Gail Shaw in my signature block.
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
February 14, 2010 at 12:25 am
Article from Microsoft
http://msdn.microsoft.com/en-us/library/ms190954.aspx
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
February 14, 2010 at 12:20 am
You may need to check your collation settings. Not the same issue - but similar and with their solution
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
February 14, 2010 at 12:18 am
Please provide sample data.
Also needed is an example showing what your desired result should look like.
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
February 13, 2010 at 11:27 pm
http://msdn.microsoft.com/en-us/library/ms187928.aspx
You can do it - but data can be truncated, only partially displayed, or an error returned because the result is too short to display. Use the link provided...
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
February 13, 2010 at 11:26 pm
Alvin Ramard (2/13/2010)
CirquedeSQLeil (2/13/2010)
Alvin Ramard (2/13/2010)
Paul White (2/13/2010)
Alvin Ramard (2/13/2010)
"Legacy apps, what does the backend really look like?" :w00t:ALVIN!!!!
What?
I bet you could find a youtube video of one 😀
CirquedeSQLeil...
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
February 13, 2010 at 8:16 pm
For tempdb structure, check Kimberly Tripps article in my sig below. She has a few articles that are helpful in that area.
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
February 13, 2010 at 8:15 pm
Viewing 15 posts - 17,341 through 17,355 (of 19,560 total)