August 23, 2013 at 9:04 am
SQLRNNR (8/23/2013)
Sean Lange (8/23/2013)
SQLRNNR (8/23/2013)
Koen Verbeeck (8/23/2013)
ChrisM@Work (8/23/2013)
GilaMonster (8/23/2013)
Fal (8/22/2013)
Speaking of fruit. The missus and I are getting a new kitchen in and are trying to finalise a few issues.We were thinking of getting a stone benchtop, but depending on the stone you may need to oil it, or it can suffer from thermal shock. Has anyone had any bad experiences with stone benchtops?
My Mother got granite worktops in her kitchen some years back. Beautiful and very strong. Polished, sealed and completely waterproof. Only downside - plates, cups or glasses dropped onto it will break.
Do you know which granite, Gail? I spent a while talking to the guys who came in to fit my quartz - they said they preferred black granite to white because it rarely broke during fitting. I appreciate you have your own source of granite in SA and it may well be different to ours.
The friends I was talking about have white granite. Really beautiful. There seemed to be no issues with the fitting.
I have black granite with brown specks. We love it.
I have cheap crappy white formica...we hate it.
I am not a fan of formica.
Me neither but apparently our builder liked to use cheap everything. I have been slowly replacing all the cheap parts over the last 6-7 years. My kitchen is getting closer to the top of the list but it is going to be a pricey one because I have to expand it in the process. Our remodeling goes a lot slower than most because I do it all myself. Makes it a lot cheaper but also a LOT slower.
_______________________________________________________________
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/
August 23, 2013 at 9:33 am
Sean Lange (8/23/2013)
SQLRNNR (8/23/2013)
Sean Lange (8/23/2013)
SQLRNNR (8/23/2013)
Koen Verbeeck (8/23/2013)
ChrisM@Work (8/23/2013)
GilaMonster (8/23/2013)
Fal (8/22/2013)
Speaking of fruit. The missus and I are getting a new kitchen in and are trying to finalise a few issues.We were thinking of getting a stone benchtop, but depending on the stone you may need to oil it, or it can suffer from thermal shock. Has anyone had any bad experiences with stone benchtops?
My Mother got granite worktops in her kitchen some years back. Beautiful and very strong. Polished, sealed and completely waterproof. Only downside - plates, cups or glasses dropped onto it will break.
Do you know which granite, Gail? I spent a while talking to the guys who came in to fit my quartz - they said they preferred black granite to white because it rarely broke during fitting. I appreciate you have your own source of granite in SA and it may well be different to ours.
The friends I was talking about have white granite. Really beautiful. There seemed to be no issues with the fitting.
I have black granite with brown specks. We love it.
I have cheap crappy white formica...we hate it.
I am not a fan of formica.
Me neither but apparently our builder liked to use cheap everything. I have been slowly replacing all the cheap parts over the last 6-7 years. My kitchen is getting closer to the top of the list but it is going to be a pricey one because I have to expand it in the process. Our remodeling goes a lot slower than most because I do it all myself. Makes it a lot cheaper but also a LOT slower.
I'd put our laminate countertops up against any in the "ugly" category. As granite, quartz, or even solid-surface materials will be out of the budget for the next several years, an interior decorator friend suggested we consider featherweight concrete applied right over the laminate.[/url] It seems very DIY-able. We like the look of concrete countertops; we're intrigued and we're checking it out.
Jason Wolfkill
August 23, 2013 at 10:02 am
wolfkillj (8/23/2013)
Sean Lange (8/23/2013)
SQLRNNR (8/23/2013)
Sean Lange (8/23/2013)
SQLRNNR (8/23/2013)
Koen Verbeeck (8/23/2013)
ChrisM@Work (8/23/2013)
GilaMonster (8/23/2013)
Fal (8/22/2013)
Speaking of fruit. The missus and I are getting a new kitchen in and are trying to finalise a few issues.We were thinking of getting a stone benchtop, but depending on the stone you may need to oil it, or it can suffer from thermal shock. Has anyone had any bad experiences with stone benchtops?
My Mother got granite worktops in her kitchen some years back. Beautiful and very strong. Polished, sealed and completely waterproof. Only downside - plates, cups or glasses dropped onto it will break.
Do you know which granite, Gail? I spent a while talking to the guys who came in to fit my quartz - they said they preferred black granite to white because it rarely broke during fitting. I appreciate you have your own source of granite in SA and it may well be different to ours.
The friends I was talking about have white granite. Really beautiful. There seemed to be no issues with the fitting.
I have black granite with brown specks. We love it.
I have cheap crappy white formica...we hate it.
I am not a fan of formica.
Me neither but apparently our builder liked to use cheap everything. I have been slowly replacing all the cheap parts over the last 6-7 years. My kitchen is getting closer to the top of the list but it is going to be a pricey one because I have to expand it in the process. Our remodeling goes a lot slower than most because I do it all myself. Makes it a lot cheaper but also a LOT slower.
I'd put our laminate countertops up against any in the "ugly" category. As granite, quartz, or even solid-surface materials will be out of the budget for the next several years, an interior decorator friend suggested we consider featherweight concrete applied right over the laminate.[/url] It seems very DIY-able. We like the look of concrete countertops; we're intrigued and we're checking it out.
The only read disadvantage of concrete countertops is that you have to keep resealing them. They do look pretty awesome though.
_______________________________________________________________
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/
August 23, 2013 at 11:10 am
Sean Lange (8/23/2013)
The only read disadvantage of concrete countertops is that you have to keep resealing them. They do look pretty awesome though.
Resealing concrete counters is easy enough that I don't consider it a deterrent to installing them, though.
Jason Wolfkill
August 23, 2013 at 11:27 am
Fal (8/22/2013)
We were thinking of getting a stone benchtop, but depending on the stone you may need to oil it, or it can suffer from thermal shock. Has anyone had any bad experiences with stone benchtops?Fal.
We have white quartz and I really love it. I do not like dark colors because all bread crumbs, dust and everything shows easily.
August 23, 2013 at 11:36 am
Sean Lange (8/22/2013)
Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low hanging fruit. 😀
There's just no need to answer when someone like yourself has already answered. You guys seem to get there before I can and I frequently don't have anything to add because of the high quality of the answer. Heh... with the free time you've provided me, I may actually have to get a life. :-D:-P
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2013 at 11:50 am
/me sits back, munching popcorn while reading the Full backup / transaction log breakup topic
😀
August 23, 2013 at 11:54 am
Jeff Moden (8/23/2013)
Sean Lange (8/22/2013)
Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low hanging fruit. 😀There's just no need to answer when someone like yourself has already answered. You guys seem to get there before I can and I frequently don't have anything to add because of the high quality of the answer. Heh... with the free time you've provided me, I may actually have to get a life. :-D:-P
But thankfully we have people like you and Gail to come along and clean up the mess after I post. You guys are always there to correct our inaccuracies which is much appreciated.
_______________________________________________________________
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/
August 23, 2013 at 1:20 pm
Sean Lange (8/23/2013)
Jeff Moden (8/23/2013)
Sean Lange (8/22/2013)
Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low hanging fruit. 😀There's just no need to answer when someone like yourself has already answered. You guys seem to get there before I can and I frequently don't have anything to add because of the high quality of the answer. Heh... with the free time you've provided me, I may actually have to get a life. :-D:-P
But thankfully we have people like you and Gail to come along and clean up the mess after I post. You guys are always there to correct our inaccuracies which is much appreciated.
+1
I have risked it a few times to answer in a DBA topic. Most of the time Gail pops in and corrects me. :blush:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 23, 2013 at 8:13 pm
Jeff Moden (8/23/2013)
Sean Lange (8/22/2013)
Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low hanging fruit. 😀There's just no need to answer when someone like yourself has already answered. You guys seem to get there before I can and I frequently don't have anything to add because of the high quality of the answer. Heh... with the free time you've provided me, I may actually have to get a life. :-D:-P
Should give you more time to write more great articles like sorting hiearchies.
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
August 24, 2013 at 6:34 pm
Sean Lange (8/23/2013)
Jeff Moden (8/23/2013)
Sean Lange (8/22/2013)
Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low hanging fruit. 😀There's just no need to answer when someone like yourself has already answered. You guys seem to get there before I can and I frequently don't have anything to add because of the high quality of the answer. Heh... with the free time you've provided me, I may actually have to get a life. :-D:-P
But thankfully we have people like you and Gail to come along and clean up the mess after I post. You guys are always there to correct our inaccuracies which is much appreciated.
I appreciate the kind words but I've actually not been spending as much time as SSC as I used to be able to. To coin a phrase, "It's no longer a matter of how many sticks I have in the fire... now it's a matter of how many fires I have sticks in."
--Jeff Moden
Change is inevitable... Change for the better is not.
August 24, 2013 at 6:35 pm
dwain.c (8/23/2013)
Jeff Moden (8/23/2013)
Sean Lange (8/22/2013)
Seems that most of the really "heavy hitters" have not been answering as much either so people like me can come grab the low hanging fruit. 😀There's just no need to answer when someone like yourself has already answered. You guys seem to get there before I can and I frequently don't have anything to add because of the high quality of the answer. Heh... with the free time you've provided me, I may actually have to get a life. :-D:-P
Should give you more time to write more great articles like sorting hiearchies.
Thanks for the feedback and the encouragement , Dwain.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 25, 2013 at 1:54 pm
What's your favourite index-related myth?
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
August 25, 2013 at 2:44 pm
GilaMonster (8/25/2013)
What's your favourite index-related myth?
Clustered index sorts on physical level.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 25, 2013 at 2:54 pm
GilaMonster (8/25/2013)
What's your favourite index-related myth?
What's yours?
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 41,041 through 41,055 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply