Viewing 15 posts - 18,211 through 18,225 (of 19,560 total)
WayneS (1/12/2010)
Is there any particular reason for going this method - specially since there is a way further on down that is faster,...
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
January 12, 2010 at 10:11 am
Steve Jones - Editor (1/12/2010)
Listened to Buster Olney this morning, interesting take. He says writers should not vote. They are there to follow the news, not be 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
January 12, 2010 at 10:06 am
leftfield_ecb (1/12/2010)
As far as steroids (and this might be debated) I've always felt you...
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
January 12, 2010 at 10:04 am
You're welcome. It stumped me for a little while - whilst recreating and trying to fix the issue.
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
January 12, 2010 at 10:00 am
Burrito
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
January 12, 2010 at 9:58 am
Thanks for another question bitbucket. Had to use the noggin on this one a bit.
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
January 12, 2010 at 12:09 am
Thanks for the article. I hadn't considered using the Broker for this before - I will be giving this a try.
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
January 12, 2010 at 12:07 am
The cause is due to the '[' and ']' . The brackets will either need to be escaped or you will need to change them. I was able...
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
January 11, 2010 at 11:46 pm
Dreaded double-post
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
January 11, 2010 at 11:17 pm
What database is the function in? Does the SQL Job have access to it? Is it called from the job itself or from the proc?
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
January 11, 2010 at 11:06 pm
Henrico Bekker (1/11/2010)
Except for Gail's workshops every now and then, are there any other and more regular events in South...
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
January 11, 2010 at 10:59 pm
Thank you. You posted a question and still worked on solving it. Thanks for posting back the solution you found.
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
January 11, 2010 at 10:55 pm
Steve Jones - Editor (1/11/2010)
Go with the one you feel comfortable with. You'll deliver it better, and I bet you get more questions on it.
Heh, that is the way 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
January 11, 2010 at 10:54 pm
Lowell's solution should work nicely for you.
One question - will the order of the records always be the same (agegroups will not get out of order)?
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
January 11, 2010 at 10:46 pm
Deadlocks was the primary goal.
The Backup plan was to discuss an inventory solution. More lessons on getting to know your data better. I feel more comfortable...
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
January 11, 2010 at 10:37 pm
Viewing 15 posts - 18,211 through 18,225 (of 19,560 total)