Are the posted questions getting worse?
-
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. 😀
--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.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
WayneS (2/3/2014)
Jeff Moden (2/3/2014)
Personally and just as a non-confontational point of view, I think GUIDs as a clustered index is a really bad thing to do especially since the advent of SEQUENCE. One other problem that I have with them is that people think they're still "Globally Unique" and they haven't been since MS changed them from Type 1 GUIDs (machine sensitive) to Type 4 GUIDs (not much more than a really big random number). While the chances of duplicating a GUID between even several machines is astonomical, it is a possibility that can happen and a lot of people don't bother with unique constraints on supposed key columns (a basic fault in design knowledge, as well).Are GUIDs always bad, IMHO? Not on your life but I treat them much like Cursors and While loops. They have their uses but I generally avoid them.
On that same subject, I'll add to the list of favorite Kimberly Tripp links already posted above.
http://technet.microsoft.com/en-US/sqlserver/gg508879.aspx
To be sure, a good deal of the problem I have with GUIDs is that I'd rather read/troubleshoot a (say) 12 digit number than a 36 character hex representation. 😛
Jeff,
Do you happen to have any links describing the change from Type1 to Type4? Also, does part of the GUID identify the type of GUID it is? (If so, then this would reduce the number of possibilities that the GUID could produce.)
Tom covered the subject pretty well on that.
--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.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
I need a coat today.
The back porch:
-
GilaMonster (2/3/2014)
Jeff Moden (2/3/2014)
This guy isn't the only person of such ilk when it comes to indexes. I also see that Brent Ozar published an article about what a waste of time it is to even REORGANIZE indexes. While I, again, see some merit in his proposal, I don't believe that enough testing has been done to make it a standard practice where I work.That is one I completely disagree with, and I have good solid reasons as to why. Tony tried arguing that one with me, not budging.
Cool... that means that I'm not the only one. Thanks, Gail.
Tony who?
--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.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Steve Jones - SSC Editor (2/5/2014)
I need a coat today.The back porch:
That's what my thermometer used to read in my garage in the middle of summer right after my first wife walked through. 😀
--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.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
WayneS (2/4/2014)
... 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.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
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! :w00t::w00t:
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 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/ -
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! :w00t::w00t:
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[/url]
Learn Extended Events -
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! :w00t::w00t:
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 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/ -
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! :w00t::w00t:
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... 🙁
-
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! :w00t::w00t:
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
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 -
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![/I]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?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St -
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[/url]
Learn Extended Events -
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.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
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[/url]
Learn Extended Events
Viewing 15 posts - 42,796 through 42,810 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply