May 6, 2014 at 6:38 pm
hisakimatama (5/6/2014)
SQLRNNR (5/6/2014)
hisakimatama (5/1/2014)
Whew, busy times at work lately. I've been out of The Thread for a good bit :-).Anyone else from The Thread planning to attend this week's SQL Saturday in Atlanta? I noticed that Grant and Jason are both presenting a session there; I'll definitely be attending both! It's the first time I'll be at a programming-based activity, so I'm giddy about loading up with plenty of knowledge 😀
Better late than never - but hope you enjoyed the event.
Hope you enjoyed my session as well. Not sure if we had a chance to meet. Plenty of people stopping me.
Oh, I quite enjoyed your session also :-D. Very informative, and Wayne's car hunt in the middle of it was thoroughly amusing. I would've stopped by afterwards for a chat, but my brain was pretty much mush at that point; I'd hardly slept the night before (very noisy hotel neighbors, argh!), and I lucked out on forming a coherent sentence when I talked to Grant. I figured I shouldn't risk making myself appear to be a complete buffoon, since I'm already partially one :-P.
Well, as a buffoon you would have been in good company with other buffoons such as myself.
Glad you enjoyed the session. It'd be nice to put a face with your name tho ;-).
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
May 7, 2014 at 4:06 am
I was tempted to suggest that only IBG and Jeff's queries can run that fast. Also, that queries running that fast can overheat the processor and should be slowed down with a WHILE loop or triangular join :hehe:
I don't know the answer to her/his question but suspect something silly (s)he's doing. The OP's posting history suggests a haphazard way of working which can be difficult for responders to correctly interpret. Any takers? You'll need Crystal Ball v12.0 for Windows.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
May 7, 2014 at 6:40 am
ChrisM@Work (5/7/2014)
DBCC TIMEWARP?I was tempted to suggest that only IBG and Jeff's queries can run that fast. Also, that queries running that fast can overheat the processor and should be slowed down with a WHILE loop or triangular join :hehe:
I don't know the answer to her/his question but suspect something silly (s)he's doing. The OP's posting history suggests a haphazard way of working which can be difficult for responders to correctly interpret. Any takers? You'll need Crystal Ball v12.0 for Windows.
Well Grant made that look easy, he must get Crystal Ball v12.0 through RedGate or something.
Since when did "-ve" become a thing? "+" and "-" already mean "positive" and "negative", "-ve" = "negative-ive". Ran into that in my last class at school in the prof's slides, spent 20 minutes trying to figure out what I was missing, which variable he was naming "ve", before realizing the exceedingly ridiculous solution.
---------------------------------------------------------
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."
May 7, 2014 at 6:44 am
ChrisM@Work (5/7/2014)
The OP's posting history suggests a haphazard way of working which can be difficult for responders to correctly interpret.
I think this is a very nice way to put it. I'm going to have to remember this one.
May 7, 2014 at 6:48 am
jcrawf02 (5/7/2014)
ChrisM@Work (5/7/2014)
DBCC TIMEWARP?I was tempted to suggest that only IBG and Jeff's queries can run that fast. Also, that queries running that fast can overheat the processor and should be slowed down with a WHILE loop or triangular join :hehe:
I don't know the answer to her/his question but suspect something silly (s)he's doing. The OP's posting history suggests a haphazard way of working which can be difficult for responders to correctly interpret. Any takers? You'll need Crystal Ball v12.0 for Windows.
Well Grant made that look easy, he must get Crystal Ball v12.0 through RedGate or something.
Since when did "-ve" become a thing? "+" and "-" already mean "positive" and "negative", "-ve" = "negative-ive". Ran into that in my last class at school in the prof's slides, spent 20 minutes trying to figure out what I was missing, which variable he was naming "ve", before realizing the exceedingly ridiculous solution.
I get it. But that notation is just silly and redundant.
And I think the correct translation is negativeve.
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
May 7, 2014 at 6:56 am
jcrawf02 (5/7/2014)
ChrisM@Work (5/7/2014)
DBCC TIMEWARP?I was tempted to suggest that only IBG and Jeff's queries can run that fast. Also, that queries running that fast can overheat the processor and should be slowed down with a WHILE loop or triangular join :hehe:
I don't know the answer to her/his question but suspect something silly (s)he's doing. The OP's posting history suggests a haphazard way of working which can be difficult for responders to correctly interpret. Any takers? You'll need Crystal Ball v12.0 for Windows.
Well Grant made that look easy, he must get Crystal Ball v12.0 through RedGate or something.
Since when did "-ve" become a thing? "+" and "-" already mean "positive" and "negative", "-ve" = "negative-ive". Ran into that in my last class at school in the prof's slides, spent 20 minutes trying to figure out what I was missing, which variable he was naming "ve", before realizing the exceedingly ridiculous solution.
That's SQL Crystal Ball Pro v12.1. Have to keep up with the versions and the Pro version comes with a command line.
So -ve means negative? In what programming language? That's not one I've run into before and it's certainly WAY less than clear.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 7, 2014 at 7:00 am
Ed Wagner (5/7/2014)
ChrisM@Work (5/7/2014)
The OP's posting history suggests a haphazard way of working which can be difficult for responders to correctly interpret.I think this is a very nice way to put it. I'm going to have to remember this one.
It took a few attempts Ed. Version 1 would have had HR wandering over to my desk with a box 😉
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
May 7, 2014 at 7:16 am
SQLRNNR (5/6/2014)
hisakimatama (5/6/2014)
SQLRNNR (5/6/2014)
hisakimatama (5/1/2014)
Whew, busy times at work lately. I've been out of The Thread for a good bit :-).Anyone else from The Thread planning to attend this week's SQL Saturday in Atlanta? I noticed that Grant and Jason are both presenting a session there; I'll definitely be attending both! It's the first time I'll be at a programming-based activity, so I'm giddy about loading up with plenty of knowledge 😀
Better late than never - but hope you enjoyed the event.
Hope you enjoyed my session as well. Not sure if we had a chance to meet. Plenty of people stopping me.
Oh, I quite enjoyed your session also :-D. Very informative, and Wayne's car hunt in the middle of it was thoroughly amusing. I would've stopped by afterwards for a chat, but my brain was pretty much mush at that point; I'd hardly slept the night before (very noisy hotel neighbors, argh!), and I lucked out on forming a coherent sentence when I talked to Grant. I figured I shouldn't risk making myself appear to be a complete buffoon, since I'm already partially one :-P.
Well, as a buffoon you would have been in good company with other buffoons such as myself.
Glad you enjoyed the session. It'd be nice to put a face with your name tho ;-).
Certainly so! I suppose this means I'll just have to attend the next event you'll be presenting at :-D. If I can, anyhow... I've been dying to go to a SQL Saturday, PASS event, or usergroup meeting for the longest time, but none of them are ever around where I live and work. Atlanta was pretty close, but still about 120 miles away. Still, if I can manage the time, I'll be attending a lot more sessions!
- 😀
May 7, 2014 at 7:47 am
ChrisM@Work (5/7/2014)
Ed Wagner (5/7/2014)
ChrisM@Work (5/7/2014)
The OP's posting history suggests a haphazard way of working which can be difficult for responders to correctly interpret.I think this is a very nice way to put it. I'm going to have to remember this one.
It took a few attempts Ed. Version 1 would have had HR wandering over to my desk with a box 😉
I know what you mean because I have the same problem.
May 7, 2014 at 10:23 am
hisakimatama (5/7/2014)
SQLRNNR (5/6/2014)
hisakimatama (5/6/2014)
SQLRNNR (5/6/2014)
hisakimatama (5/1/2014)
Whew, busy times at work lately. I've been out of The Thread for a good bit :-).Anyone else from The Thread planning to attend this week's SQL Saturday in Atlanta? I noticed that Grant and Jason are both presenting a session there; I'll definitely be attending both! It's the first time I'll be at a programming-based activity, so I'm giddy about loading up with plenty of knowledge 😀
Better late than never - but hope you enjoyed the event.
Hope you enjoyed my session as well. Not sure if we had a chance to meet. Plenty of people stopping me.
Oh, I quite enjoyed your session also :-D. Very informative, and Wayne's car hunt in the middle of it was thoroughly amusing. I would've stopped by afterwards for a chat, but my brain was pretty much mush at that point; I'd hardly slept the night before (very noisy hotel neighbors, argh!), and I lucked out on forming a coherent sentence when I talked to Grant. I figured I shouldn't risk making myself appear to be a complete buffoon, since I'm already partially one :-P.
Well, as a buffoon you would have been in good company with other buffoons such as myself.
Glad you enjoyed the session. It'd be nice to put a face with your name tho ;-).
Certainly so! I suppose this means I'll just have to attend the next event you'll be presenting at :-D. If I can, anyhow... I've been dying to go to a SQL Saturday, PASS event, or usergroup meeting for the longest time, but none of them are ever around where I live and work. Atlanta was pretty close, but still about 120 miles away. Still, if I can manage the time, I'll be attending a lot more sessions!
Glad that you found my car hunt so amusing. Did you attend my session?
120 miles from ATL - north or south? There's a SQLSat coming to Raleigh in Sept, how close is that to you? (I plan on going there)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
May 7, 2014 at 11:15 am
WayneS (5/7/2014)
hisakimatama (5/7/2014)
SQLRNNR (5/6/2014)
hisakimatama (5/6/2014)
SQLRNNR (5/6/2014)
hisakimatama (5/1/2014)
Whew, busy times at work lately. I've been out of The Thread for a good bit :-).Anyone else from The Thread planning to attend this week's SQL Saturday in Atlanta? I noticed that Grant and Jason are both presenting a session there; I'll definitely be attending both! It's the first time I'll be at a programming-based activity, so I'm giddy about loading up with plenty of knowledge 😀
Better late than never - but hope you enjoyed the event.
Hope you enjoyed my session as well. Not sure if we had a chance to meet. Plenty of people stopping me.
Oh, I quite enjoyed your session also :-D. Very informative, and Wayne's car hunt in the middle of it was thoroughly amusing. I would've stopped by afterwards for a chat, but my brain was pretty much mush at that point; I'd hardly slept the night before (very noisy hotel neighbors, argh!), and I lucked out on forming a coherent sentence when I talked to Grant. I figured I shouldn't risk making myself appear to be a complete buffoon, since I'm already partially one :-P.
Well, as a buffoon you would have been in good company with other buffoons such as myself.
Glad you enjoyed the session. It'd be nice to put a face with your name tho ;-).
Certainly so! I suppose this means I'll just have to attend the next event you'll be presenting at :-D. If I can, anyhow... I've been dying to go to a SQL Saturday, PASS event, or usergroup meeting for the longest time, but none of them are ever around where I live and work. Atlanta was pretty close, but still about 120 miles away. Still, if I can manage the time, I'll be attending a lot more sessions!
Glad that you found my car hunt so amusing. Did you attend my session?
120 miles from ATL - north or south? There's a SQLSat coming to Raleigh in Sept, how close is that to you? (I plan on going there)
Unfortunately, Wayne, I didn't make it to your session :(. I really wanted to, but when I woke up that morning at 7 (which amounted to... 2 hours of sleep at that point, in intermittent bits?), I just knew I was going to be a worthless blob if I attended anything. Slept two more hours, woke up in some state of functionality, and tottered off to the college.
I'm north of ATL, in Chattanooga, Tennessee. Raleigh... I think that might be doable? I'll have to take a look at the distance and the timing. It could work! If so, I'll definitely make it a point to attend 😀
EDIT: Eep. Raleigh's about 460 miles from me, an 8-hour drive :(. Well! I'll just have to see if there's an affordable flight I could book. Maybe. Plenty of planning time, at least!
- 😀
May 7, 2014 at 11:55 am
Grant Fritchey (5/7/2014)
jcrawf02 (5/7/2014)
ChrisM@Work (5/7/2014)
DBCC TIMEWARP?I was tempted to suggest that only IBG and Jeff's queries can run that fast. Also, that queries running that fast can overheat the processor and should be slowed down with a WHILE loop or triangular join :hehe:
I don't know the answer to her/his question but suspect something silly (s)he's doing. The OP's posting history suggests a haphazard way of working which can be difficult for responders to correctly interpret. Any takers? You'll need Crystal Ball v12.0 for Windows.
Well Grant made that look easy, he must get Crystal Ball v12.0 through RedGate or something.
Since when did "-ve" become a thing? "+" and "-" already mean "positive" and "negative", "-ve" = "negative-ive". Ran into that in my last class at school in the prof's slides, spent 20 minutes trying to figure out what I was missing, which variable he was naming "ve", before realizing the exceedingly ridiculous solution.
That's SQL Crystal Ball Pro v12.1. Have to keep up with the versions and the Pro version comes with a command line.
I see you're going to present at the SQL Saturday in a couple weeks here in Detroit. I fully expect you to bring that SQL Crystal Ball with you. 😉
May 7, 2014 at 12:09 pm
Grant Fritchey (5/7/2014)
jcrawf02 (5/7/2014)
ChrisM@Work (5/7/2014)
DBCC TIMEWARP?I was tempted to suggest that only IBG and Jeff's queries can run that fast. Also, that queries running that fast can overheat the processor and should be slowed down with a WHILE loop or triangular join :hehe:
I don't know the answer to her/his question but suspect something silly (s)he's doing. The OP's posting history suggests a haphazard way of working which can be difficult for responders to correctly interpret. Any takers? You'll need Crystal Ball v12.0 for Windows.
Well Grant made that look easy, he must get Crystal Ball v12.0 through RedGate or something.
Since when did "-ve" become a thing? "+" and "-" already mean "positive" and "negative", "-ve" = "negative-ive". Ran into that in my last class at school in the prof's slides, spent 20 minutes trying to figure out what I was missing, which variable he was naming "ve", before realizing the exceedingly ridiculous solution.
That's SQL Crystal Ball Pro v12.1. Have to keep up with the versions and the Pro version comes with a command line.
And you've been denying for months that you stole^H^H^H^H^H borrowed my crystal ball. 🙁
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
May 7, 2014 at 12:18 pm
GilaMonster (5/7/2014)
That's SQL Crystal Ball Pro v12.1. Have to keep up with the versions and the Pro version comes with a command line.
And you've been denying for months that you stole^H^H^H^H^H borrowed my crystal ball. 🙁
Hold up. I didn't say I had it. I just fixed the nomenclature. I still don't know where your crystal ball might be (because it's not on my desk next to the TARDIS, no m'am).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 7, 2014 at 1:07 pm
I have a rubber ball I can bring to Bits. Harder to see through, but much more durable.
And fun 😛
Viewing 15 posts - 43,861 through 43,875 (of 66,688 total)
You must be logged in to reply to this topic. Login to reply