Viewing 15 posts - 7,471 through 7,485 (of 19,560 total)
Perfect topic for the day. I had similar feelings as I was writing and scheduling my blog [/url]that went out today.
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
December 20, 2011 at 11:33 am
Returning an unexpected result is a query that fails. It may not generate an error, but the query still fails.
As I said in my previous post, the query as...
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
December 20, 2011 at 11:30 am
1.5 years later and it is strikingly accurate. I should print this and hang it all over the place.
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
December 20, 2011 at 11:25 am
SQLRNNR (12/20/2011)
Steve Jones - SSC Editor (12/20/2011)
If you haven't tried it, google "let it snow" and check out the Easter eggI like that.
Even better if it would snow outside now....
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
December 20, 2011 at 10:30 am
Steve Jones - SSC Editor (12/20/2011)
If you haven't tried it, google "let it snow" and check out the Easter egg
I like that.
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
December 20, 2011 at 10:29 am
Dev (12/20/2011)
Note to self: Read your post 3 times if Gus (qualified LOL & ROFL :smooooth:) is in the loop.
That still won't cover all of the bases. ...
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
December 20, 2011 at 10:24 am
Can you show us the one that is failing? This query works fine for me.
Until then, I can speculate that there is rounding involved in the query that is...
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
December 20, 2011 at 10:18 am
GSquared (12/20/2011)
Dev (12/20/2011)
GSquared (12/20/2011)
Dev (12/20/2011)
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
December 20, 2011 at 9:55 am
Some of the builtin procs do use multiple queries and also utilize cursors to generate the result.
In the case of spaceused, I prefer to use this query.
http://jasonbrimhall.info/2011/11/17/table-space-revised-again/
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
December 20, 2011 at 9:25 am
Brandie Tarvin (12/20/2011)
Dev (12/20/2011)
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
December 20, 2011 at 9:17 am
Have a look at this connect item.
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
December 20, 2011 at 9:08 am
tinalouise90 (12/20/2011)
hi i need shopexams.com study guides for 1z0-023 exam preparation can someone share with me these?.thanks in advance
NO NO NO NO NO
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
December 20, 2011 at 9:02 am
SQLKnowItAll (12/20/2011)
The developer edition costs $50.
Cheaper on ebay 🙂
Yeah - you still have to be careful there. Not sure what the resell laws on that software are. 😉
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
December 20, 2011 at 9:00 am
R.P.Rozema (12/20/2011)
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
December 20, 2011 at 8:58 am
GilaMonster (12/20/2011)
Hmm, this looks familiar. 😉
Seemed familiar from a tweet conversation involving you.:cool:
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
December 20, 2011 at 8:57 am
Viewing 15 posts - 7,471 through 7,485 (of 19,560 total)