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,2794,2804,2814,2824,283»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Wednesday, February 5, 2014 10:52 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 35,769, Visits: 32,437
WayneS (2/4/2014)
[quote][b]... and fits in great with a presentation that I've just started doing. Thanks!

Awesome. I look forward to your articles. What's the subject (obviously it has something to do with GUIDs)?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1538297
Posted Wednesday, February 5, 2014 12:32 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:05 PM
Points: 13,327, Visits: 12,820
WayneS (2/5/2014)
Sean Lange (2/4/2014)
What a crazy day! Lots of snow falling around Kansas City. Pretty much the whole city is shut down today and quite probably tomorrow. The snow got started in earnest around 10am and is supposed to snow continuously for around 24 hours. I live out of the West side of KC and the last check of the weather folks had us right in the bulls-eye; expecting 10-12" snow.


Sean,
Snowed in? At least that ought to give you time to work on the UniqueIdentifier articles!


I wish I could have put some cycles into that yesterday. Snowed in also meant that both of the boys were home so daddy spent most of the day playing referee.


_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1538330
Posted Wednesday, February 5, 2014 12:37 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
Sean Lange (2/5/2014)
WayneS (2/5/2014)
Sean Lange (2/4/2014)
What a crazy day! Lots of snow falling around Kansas City. Pretty much the whole city is shut down today and quite probably tomorrow. The snow got started in earnest around 10am and is supposed to snow continuously for around 24 hours. I live out of the West side of KC and the last check of the weather folks had us right in the bulls-eye; expecting 10-12" snow.


Sean,
Snowed in? At least that ought to give you time to work on the UniqueIdentifier articles!


I wish I could have put some cycles into that yesterday. Snowed in also meant that both of the boys were home so daddy spent most of the day playing referee.


Referee days are the most fun




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1538333
Posted Wednesday, February 5, 2014 12:51 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:05 PM
Points: 13,327, Visits: 12,820
SQLRNNR (2/5/2014)
Sean Lange (2/5/2014)
WayneS (2/5/2014)
Sean Lange (2/4/2014)
What a crazy day! Lots of snow falling around Kansas City. Pretty much the whole city is shut down today and quite probably tomorrow. The snow got started in earnest around 10am and is supposed to snow continuously for around 24 hours. I live out of the West side of KC and the last check of the weather folks had us right in the bulls-eye; expecting 10-12" snow.


Sean,
Snowed in? At least that ought to give you time to work on the UniqueIdentifier articles!


I wish I could have put some cycles into that yesterday. Snowed in also meant that both of the boys were home so daddy spent most of the day playing referee.


Referee days are the most fun


Those are the days we will forget when our children grow up.


_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1538342
Posted Wednesday, February 5, 2014 2:10 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
Sean Lange (2/5/2014)
SQLRNNR (2/5/2014)
Sean Lange (2/5/2014)
WayneS (2/5/2014)
Sean Lange (2/4/2014)
What a crazy day! Lots of snow falling around Kansas City. Pretty much the whole city is shut down today and quite probably tomorrow. The snow got started in earnest around 10am and is supposed to snow continuously for around 24 hours. I live out of the West side of KC and the last check of the weather folks had us right in the bulls-eye; expecting 10-12" snow.


Sean,
Snowed in? At least that ought to give you time to work on the UniqueIdentifier articles!


I wish I could have put some cycles into that yesterday. Snowed in also meant that both of the boys were home so daddy spent most of the day playing referee.


Referee days are the most fun


Those are the days we will forget when our children grow up.

And they grow up so fast...
Post #1538374
Posted Wednesday, February 5, 2014 3:06 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
Revenant (2/5/2014)
Sean Lange (2/5/2014)
SQLRNNR (2/5/2014)
Sean Lange (2/5/2014)
WayneS (2/5/2014)
Sean Lange (2/4/2014)
What a crazy day! Lots of snow falling around Kansas City. Pretty much the whole city is shut down today and quite probably tomorrow. The snow got started in earnest around 10am and is supposed to snow continuously for around 24 hours. I live out of the West side of KC and the last check of the weather folks had us right in the bulls-eye; expecting 10-12" snow.


Sean,
Snowed in? At least that ought to give you time to work on the UniqueIdentifier articles!


I wish I could have put some cycles into that yesterday. Snowed in also meant that both of the boys were home so daddy spent most of the day playing referee.


Referee days are the most fun


Those are the days we will forget when our children grow up.

And they grow up so fast...


Yup
http://bit.ly/1c4Qjnt




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1538389
Posted Wednesday, February 5, 2014 5:04 PM


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 @ 9:53 PM
Points: 3,438, Visits: 5,390
Jeff Moden (2/5/2014)
ChrisM@Work (2/4/2014)
He's calling summer on one sighting of a swallow.


He should come to Michigan. It was snowing to beat the band a couple of days ago and I had a Robin stop by the heated bird bath. Robins are normally the first sign of spring in Michigan. I guess that one didn't read BOL.


A heated bird bath? Guess you'll be featured prominently in the next edition of Lifestyles of the Rich and Famous!



My mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.


Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1538414
Posted Wednesday, February 5, 2014 5:09 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
dwain.c (2/5/2014)
Jeff Moden (2/5/2014)
ChrisM@Work (2/4/2014)
He's calling summer on one sighting of a swallow.


He should come to Michigan. It was snowing to beat the band a couple of days ago and I had a Robin stop by the heated bird bath. Robins are normally the first sign of spring in Michigan. I guess that one didn't read BOL.


A heated bird bath? Guess you'll be featured prominently in the next edition of Lifestyles of the Rich and Famous!


The Rich and Famous Santa Claus




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1538417
Posted Wednesday, February 5, 2014 8:57 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:27 AM
Points: 35,769, Visits: 32,437
SQLRNNR (2/5/2014)
dwain.c (2/5/2014)
Jeff Moden (2/5/2014)
ChrisM@Work (2/4/2014)
He's calling summer on one sighting of a swallow.


He should come to Michigan. It was snowing to beat the band a couple of days ago and I had a Robin stop by the heated bird bath. Robins are normally the first sign of spring in Michigan. I guess that one didn't read BOL.


A heated bird bath? Guess you'll be featured prominently in the next edition of Lifestyles of the Rich and Famous!


The Rich and Famous Santa Claus


BWAA-HAAA!!!! Too funny! Nah... it does't cost that much. Debbie has one of those ceeeement birdbaths and I bought one of those small electric heaters that farmers put in cow watering troughs to keep the water from freezing in the winter. They keep the water at about 40oF. It's real overkill for a bird bath (designed for 100 gallon cow troughs) but it works and it doesn't cost much to run. It has a thermostat built into it. It's designed to be fully submersible.

Hmmm... maybe I should buy a cow trough and 4 of those heaters to make a poor man's hot tub. With as fat as I've gotten, there wouldn't be much water left in a 100 gallon trough so they wouldn't have to work very hard.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1538454
Posted Wednesday, February 5, 2014 10:19 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
Jeff Moden (2/5/2014)
SQLRNNR (2/5/2014)
dwain.c (2/5/2014)
Jeff Moden (2/5/2014)
ChrisM@Work (2/4/2014)
He's calling summer on one sighting of a swallow.


He should come to Michigan. It was snowing to beat the band a couple of days ago and I had a Robin stop by the heated bird bath. Robins are normally the first sign of spring in Michigan. I guess that one didn't read BOL.


A heated bird bath? Guess you'll be featured prominently in the next edition of Lifestyles of the Rich and Famous!


The Rich and Famous Santa Claus


BWAA-HAAA!!!! Too funny! Nah... it does't cost that much. Debbie has one of those ceeeement birdbaths and I bought one of those small electric heaters that farmers put in cow watering troughs to keep the water from freezing in the winter. They keep the water at about 40oF. It's real overkill for a bird bath (designed for 100 gallon cow troughs) but it works and it doesn't cost much to run. It has a thermostat built into it. It's designed to be fully submersible.

Hmmm... maybe I should buy a cow trough and 4 of those heaters to make a poor man's hot tub. With as fat as I've gotten, there wouldn't be much water left in a 100 gallon trough so they wouldn't have to work very hard.


Hmmm hot tub. Hillbilly style.

Now what about the bubbles? Alka seltzer?




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1538466
« Prev Topic | Next Topic »

Add to briefcase «««4,2794,2804,2814,2824,283»»»

Permissions Expand / Collapse