June 2, 2014 at 12:47 pm
Sean Lange (6/2/2014)
Lynn Pettis (6/2/2014)
Between NOLOCK and no gaps in invoice numbers how much more fun can we have??No kidding. Seems to be blockhead Monday. 😀
You saying we should be querying SSC with the (NOBLOCKHEAD) hint?
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
June 2, 2014 at 12:49 pm
SQLRNNR (6/2/2014)
Sean Lange (6/2/2014)
Lynn Pettis (6/2/2014)
Between NOLOCK and no gaps in invoice numbers how much more fun can we have??No kidding. Seems to be blockhead Monday. 😀
You saying we should be querying SSC with the (NOBLOCKHEAD) hint?
I like the new hint, but does it still work if DBCC Timewarp is running concurrently?
June 2, 2014 at 12:55 pm
Ed Wagner (6/2/2014)
SQLRNNR (6/2/2014)
Sean Lange (6/2/2014)
Lynn Pettis (6/2/2014)
Between NOLOCK and no gaps in invoice numbers how much more fun can we have??No kidding. Seems to be blockhead Monday. 😀
You saying we should be querying SSC with the (NOBLOCKHEAD) hint?
I like the new hint, but does it still work if DBCC Timewarp is running concurrently?
Intended results could occur if you do that.
Some of these results might include the Blockhead never being born.
As usual, your mileage may vary.
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
June 2, 2014 at 12:56 pm
SQLRNNR (6/2/2014)
Sean Lange (6/2/2014)
Lynn Pettis (6/2/2014)
Between NOLOCK and no gaps in invoice numbers how much more fun can we have??No kidding. Seems to be blockhead Monday. 😀
You saying we should be querying SSC with the (NOBLOCKHEAD) hint?
Select *
from TodaysSSCUsers with (NOBLOCKHEAD)
(0 row(s) affected)
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 2, 2014 at 1:51 pm
Sean Lange (6/2/2014)
Luis Cazares (6/2/2014)
SQLRNNR (6/2/2014)
Sean Lange (6/2/2014)
Did the "Recent Posts" link get moved? I don't see it any more all of a sudden.Looks like it got removed. That was a useful tool.
I can see it on the same place as always.
It is back now. Must have been deploying some changes this morning. 😉
Thank heavens. I'm not in the mood to hand search every forum on this site 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 2, 2014 at 1:55 pm
SQLRNNR (6/2/2014)
Ed Wagner (6/2/2014)
SQLRNNR (6/2/2014)
Sean Lange (6/2/2014)
Lynn Pettis (6/2/2014)
Between NOLOCK and no gaps in invoice numbers how much more fun can we have??No kidding. Seems to be blockhead Monday. 😀
You saying we should be querying SSC with the (NOBLOCKHEAD) hint?
I like the new hint, but does it still work if DBCC Timewarp is running concurrently?
Intended results could occur if you do that.
Some of these results might include the Blockhead never being born.
As usual, your mileage may vary.
Jason, you went right where I was thinking. If DBCC Timewarp were run at 3:00 but was told it should run at 2:00, if the NOBLOCKHEAD hint were run at 2:30 and finished in 3 seconds, there could be trouble. Worse yet, if DBCC Timewarp were run at a time before the NOBLOCKHEAD hint was even created, it could escalate into a full-blown situation.
June 2, 2014 at 2:21 pm
Could I get your opinions on this issue?
http://www.sqlservercentral.com/Forums/Topic1576705-391-1.aspx
June 2, 2014 at 2:23 pm
Lynn Pettis (6/2/2014)
Between NOLOCK and no gaps in invoice numbers how much more fun can we have??
Replacing EXISTS with (something) because Some Person said it's slow.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 2, 2014 at 3:03 pm
GilaMonster (6/2/2014)
Lynn Pettis (6/2/2014)
Between NOLOCK and no gaps in invoice numbers how much more fun can we have??Replacing EXISTS with (something) because Some Person said it's slow.
As Stevie Wonder once said: "Superstition ain't the way."
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 2, 2014 at 3:11 pm
SQLRNNR (5/30/2014)
Steve Jones - SSC Editor (5/30/2014)
SQLRNNR (5/30/2014)
Steve Jones - SSC Editor (5/30/2014)
Everyone enjoy summer. Last chance to ping me for things before I'm gone for 6 weeks.7 hours and counting....
Admin login for ssc?:-D:-D:-D:-D
user: masteroftheuniverse@sqlservercentral.com
pwd: 0x03fd4a7fee42439BBFEOrSomethingEquallyH@rdT0G3ess
ROFL
So, Steve's gone. Begin the injection tests!
So, I've been... busy. 🙂 Hi guys, what's new?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 2, 2014 at 3:15 pm
Evil Kraig F (6/2/2014)
SQLRNNR (5/30/2014)
Steve Jones - SSC Editor (5/30/2014)
SQLRNNR (5/30/2014)
Steve Jones - SSC Editor (5/30/2014)
Everyone enjoy summer. Last chance to ping me for things before I'm gone for 6 weeks.7 hours and counting....
Admin login for ssc?:-D:-D:-D:-D
user: masteroftheuniverse@sqlservercentral.com
pwd: 0x03fd4a7fee42439BBFEOrSomethingEquallyH@rdT0G3ess
ROFL
So, Steve's gone. Begin the injection tests!
So, I've been... busy. 🙂 Hi guys, what's new?
Hey, Kraig is back - for 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
June 3, 2014 at 1:04 am
Evil Kraig F (6/2/2014)
So, I've been... busy. 🙂 Hi guys, what's new?
I met Grant in real life. I still have nightmares.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 3, 2014 at 3:25 am
Koen Verbeeck (6/3/2014)
Evil Kraig F (6/2/2014)
So, I've been... busy. 🙂 Hi guys, what's new?I met Grant in real life. I still have nightmares.
I'd heard he's a bit scary. What else did you expect? 😉
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 3, 2014 at 6:41 am
Evil Kraig F (6/3/2014)
Koen Verbeeck (6/3/2014)
Evil Kraig F (6/2/2014)
So, I've been... busy. 🙂 Hi guys, what's new?I met Grant in real life. I still have nightmares.
I'd heard he's a bit scary. What else did you expect? 😉
He expected him to be faster. 😀
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
June 3, 2014 at 1:02 pm
You know, I'd not really thought about this until now, but...
How do people find all these "undocumented" options for various SQL commands?
dbcc autopilot???
create index... WITH STATISTICS_ONLY = ???
What do these people have, an inside source at MS or something? A decompiler so they can pull apart the SQL Server executables and DLLs?
Just curious...
Wait, why am I hearing helicopters all of a sudden?
And why are the helicopters I see all black, with no log*(yhijh)&(*Y)(*Ypinlk
/SESSION TERMINATED AT SOURCE
Viewing 15 posts - 44,071 through 44,085 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply