Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,3854,3864,3874,3884,389»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Tuesday, May 6, 2014 6:38 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 10:02 PM
Points: 21,342, Visits: 15,017
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 . 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 .


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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1568250
Posted Wednesday, May 7, 2014 4:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:21 AM
Points: 7,133, Visits: 13,520
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

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.


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

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
Exploring Recursive CTEs by Example Dwain Camps
Post #1568353
Posted Wednesday, May 7, 2014 6:40 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:17 PM
Points: 2,661, Visits: 19,196
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

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
How to post performance problems
Tally Table:What it is and how it replaces a loop

"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."
Post #1568422
Posted Wednesday, May 7, 2014 6:44 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 3,991, Visits: 3,011
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.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1568428
Posted Wednesday, May 7, 2014 6:48 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 10:02 PM
Points: 21,342, Visits: 15,017
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

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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1568430
Posted Wednesday, May 7, 2014 6:56 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:01 PM
Points: 15,558, Visits: 27,932
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

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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1568437
Posted Wednesday, May 7, 2014 7:00 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:21 AM
Points: 7,133, Visits: 13,520
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


“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

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
Exploring Recursive CTEs by Example Dwain Camps
Post #1568440
Posted Wednesday, May 7, 2014 7:16 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 3:11 PM
Points: 577, Visits: 6,299
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 . 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 .


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 . 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!


----------------------------------
My journal of things I'm learning about SQL
Post #1568450
Posted Wednesday, May 7, 2014 7:46 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 3,991, Visits: 3,011
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.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1568477
Posted Wednesday, May 7, 2014 10:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:16 AM
Points: 6,582, Visits: 8,862
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 . 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 .


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 . 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
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1568584
« Prev Topic | Next Topic »

Add to briefcase «««4,3854,3864,3874,3884,389»»»

Permissions Expand / Collapse