Viewing 15 posts - 11,581 through 11,595 (of 19,560 total)
Thanks for the 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
November 29, 2010 at 10:12 am
salt
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
November 29, 2010 at 8:27 am
GilaMonster (11/29/2010)
The project from hell (the one that I spent evenings, nights and weekends on to try and meet impossible deadlines) has had the go-live date pushed out...
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
November 29, 2010 at 8:12 am
da-zero (11/26/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
November 26, 2010 at 11:52 am
Thanks for the 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
November 26, 2010 at 8:51 am
Nakul Vachhrajani (11/26/2010)
From books online:
However, the text will be available to privileged users that can either...
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
November 26, 2010 at 8:51 am
Knowing the salary range ahead of time is helpful. I hate talking money during the interview though - no matter the perceived performance. The problem with talking money...
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
November 25, 2010 at 10:52 pm
prasadau2006 (11/25/2010)
i understand the first solution but how would i include it in the stored proc for example lets take below stored proc as the example
Case When isnumeric(PreOrderNum)=1
Then...
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
November 25, 2010 at 2:28 pm
LutzM (11/25/2010)
Jeff Moden (11/24/2010)
It's a little out of character for me but I know you'll recognize the rhetoric. I just couldn't resist... it was too perfect. Enjoy... 😛http://www.sqlservercentral.com/Forums/Topic1025567-392-1.aspx#bm1026289
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
November 25, 2010 at 12:20 pm
Some people will also create a new proc to perform the insert I just described. Then instead of an insert, you exec the proc with the required parameters (beginning...
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
November 25, 2010 at 12:19 pm
Either at the beginning or end of the proc add an insert statement.
Insert the name of the proc, datetime that it was used, and the spid that called 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
November 25, 2010 at 12:17 pm
D.Oc (11/25/2010)
Happy Thanksgiving!
Except to the turkeys, hams and yams. Should be all happy for me though:w00t:
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
November 25, 2010 at 11:45 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
November 25, 2010 at 11:33 am
As Tommy said, it looks to be the left join causing you the problem.
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
November 25, 2010 at 10:04 am
Ninja's_RGR'us (11/25/2010)
How the heck did so many people could possibly imagine that Misspelling is an issue in a SPOKEN podcast :w00t:.
Intriguing isn't 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
November 25, 2010 at 10:02 am
Viewing 15 posts - 11,581 through 11,595 (of 19,560 total)