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,2364,2374,2384,2394,240»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Monday, December 16, 2013 8:07 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, August 28, 2014 1:00 PM
Points: 4,196, Visits: 3,235
WayneS (12/16/2013)
Jack Corbett (12/16/2013)
WayneS (12/13/2013)
Greg Edwards-268690 (12/13/2013)
jasona.work (12/13/2013)
Ed Wagner (12/13/2013)
jasona.work (12/13/2013)
OK, where did the year go?
I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago I was starting this job and planning my vacation...

I know what you mean, Jason. Christmas is almost here and my shopping isn't done. Winter is also here are we're supposed to get 3" to 6" starting tonight. Seize each day and try to make the most of it.


From the snow you're talking about, sounds like you're in my neck of the woods.

Which means tomorrow or Sunday, I get to see how my sportly little, low slung car can handle it!


Finally warming up a bit here. Some areas have been getting snow by the foot, so the 8" we got last week wasn't so bad. The ice storms are the worst - I can't imagine being without lights and heat for days.


Generators. Electric Heaters.
You know, a DR plan.


Glad you used generators instead of generator if you want to run electric heaters off generator power. I prefer a generator and a wood stove.

We got 8-12 inches of snow this weekend. As far as I'm concerned we can be done with snow for the season now, and I do mean winter although it hasn't officially started yet!


Hehe.
When I built our house, I designed it to use radiant-floor heat. Hot water is heated by an outdoor wood furnace. Gas (propane) range. Only electrical needs are some tiny pumps for moving the hot water through the floor (and from wood furnace to house), and for fridge/freezer. One generator (converted to propane) easily handles all of that. Oh, and the spark igniter for the range.

Now, if I power on all of my computer equipment...

That sounds like a pretty smart design. I take it you must get a few power outages where you are. I don't know what kind of internet service you're going to have in a power outage unless you're on satellite, but hey, you can't have everything when the power's out.

The weather has been pretty crazy so far this winter err...snow season. The next thing we see will be Dwain saying he has snow and Steve posting a picture of a palm tree in his front yard.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1523507
Posted Monday, December 16, 2013 8:11 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, August 28, 2014 1:00 PM
Points: 4,196, Visits: 3,235
jasona.work (12/13/2013)
Ed Wagner (12/13/2013)
jasona.work (12/13/2013)
OK, where did the year go?
I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago I was starting this job and planning my vacation...

I know what you mean, Jason. Christmas is almost here and my shopping isn't done. Winter is also here are we're supposed to get 3" to 6" starting tonight. Seize each day and try to make the most of it.


From the snow you're talking about, sounds like you're in my neck of the woods.

Which means tomorrow or Sunday, I get to see how my sportly little, low slung car can handle it!

Well, how did your car handle this past weekend? Were you able to get out of your driveway? And what kind of sporty little car is it?



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1523509
Posted Monday, December 16, 2013 8:25 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: Today @ 5:37 AM
Points: 3,627, Visits: 5,275
Ed Wagner (12/16/2013)

The next thing we see will be Dwain saying he has snow ...


I wouldn't hold my breath. The last time I saw snow was in Toronto a few years back in Jan (and that was more than I'd ever seen before in my life).

All the Thais are breaking out their jackets to weather the frosty 72 F weather we have at the moment.



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 #1523514
Posted Monday, December 16, 2013 8:34 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Yesterday @ 9:58 AM
Points: 36,995, Visits: 31,517
WayneS (12/16/2013)
Jack Corbett (12/16/2013)
WayneS (12/13/2013)
Greg Edwards-268690 (12/13/2013)
jasona.work (12/13/2013)
Ed Wagner (12/13/2013)
jasona.work (12/13/2013)
OK, where did the year go?
I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago I was starting this job and planning my vacation...

I know what you mean, Jason. Christmas is almost here and my shopping isn't done. Winter is also here are we're supposed to get 3" to 6" starting tonight. Seize each day and try to make the most of it.


From the snow you're talking about, sounds like you're in my neck of the woods.

Which means tomorrow or Sunday, I get to see how my sportly little, low slung car can handle it!


Finally warming up a bit here. Some areas have been getting snow by the foot, so the 8" we got last week wasn't so bad. The ice storms are the worst - I can't imagine being without lights and heat for days.


Generators. Electric Heaters.
You know, a DR plan.


Glad you used generators instead of generator if you want to run electric heaters off generator power. I prefer a generator and a wood stove.

We got 8-12 inches of snow this weekend. As far as I'm concerned we can be done with snow for the season now, and I do mean winter although it hasn't officially started yet!


Hehe.
When I built our house, I designed it to use radiant-floor heat. Hot water is heated by an outdoor wood furnace. Gas (propane) range. Only electrical needs are some tiny pumps for moving the hot water through the floor (and from wood furnace to house), and for fridge/freezer. One generator (converted to propane) easily handles all of that. Oh, and the spark igniter for the range.

Now, if I power on all of my computer equipment...


Heh... next modification should be to heat the water using a heat exchanger on the exhaust of the generator. Gotta squeeze dem BTUs!


--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 #1523516
Posted Tuesday, December 17, 2013 5:51 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 7:19 AM
Points: 980, Visits: 5,112
Ed Wagner (12/16/2013)
jasona.work (12/13/2013)
Ed Wagner (12/13/2013)
jasona.work (12/13/2013)
OK, where did the year go?
I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago I was starting this job and planning my vacation...

I know what you mean, Jason. Christmas is almost here and my shopping isn't done. Winter is also here are we're supposed to get 3" to 6" starting tonight. Seize each day and try to make the most of it.


From the snow you're talking about, sounds like you're in my neck of the woods.

Which means tomorrow or Sunday, I get to see how my sportly little, low slung car can handle it!

Well, how did your car handle this past weekend? Were you able to get out of your driveway? And what kind of sporty little car is it?


Well, I forgot how much fun and how much terror a rear-wheel drive car can be in snow...


Took it out Saturday morning, before any of the roads had been cleared. Went OK on the roads, the worst of the snow was packed down or driven clear. Getting going at a stop was a slow, patient, plan well ahead process. If I gave it gas, the back end would try to slide out, so I had to let it get going first.

As for what kind of car:
It's this little guy
Post #1523644
Posted Tuesday, December 17, 2013 6:03 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, August 28, 2014 1:00 PM
Points: 4,196, Visits: 3,235
jasona.work (12/17/2013)
Ed Wagner (12/16/2013)
jasona.work (12/13/2013)
Ed Wagner (12/13/2013)
jasona.work (12/13/2013)
OK, where did the year go?
I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago I was starting this job and planning my vacation...

I know what you mean, Jason. Christmas is almost here and my shopping isn't done. Winter is also here are we're supposed to get 3" to 6" starting tonight. Seize each day and try to make the most of it.


From the snow you're talking about, sounds like you're in my neck of the woods.

Which means tomorrow or Sunday, I get to see how my sportly little, low slung car can handle it!

Well, how did your car handle this past weekend? Were you able to get out of your driveway? And what kind of sporty little car is it?


Well, I forgot how much fun and how much terror a rear-wheel drive car can be in snow...


Took it out Saturday morning, before any of the roads had been cleared. Went OK on the roads, the worst of the snow was packed down or driven clear. Getting going at a stop was a slow, patient, plan well ahead process. If I gave it gas, the back end would try to slide out, so I had to let it get going first.

As for what kind of car:
It's this little guy

It does look like a fun little car, but I do remember how rear-wheel drive cars perform and the terror they can cause in the heart of the driver when show is introduced into the equation. Given a clear parking lot, however...that's a different story. I just showed my 12-year old daughter how to spin backwards in my front-wheel drive car this past weekend. I can't help it - I just have to do it once every winter.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1523650
Posted Tuesday, December 17, 2013 7:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:32 PM
Points: 13,302, Visits: 12,168
Ed Wagner (12/17/2013)
jasona.work (12/17/2013)
Ed Wagner (12/16/2013)
jasona.work (12/13/2013)
Ed Wagner (12/13/2013)
jasona.work (12/13/2013)
OK, where did the year go?
I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago I was starting this job and planning my vacation...

I know what you mean, Jason. Christmas is almost here and my shopping isn't done. Winter is also here are we're supposed to get 3" to 6" starting tonight. Seize each day and try to make the most of it.


From the snow you're talking about, sounds like you're in my neck of the woods.

Which means tomorrow or Sunday, I get to see how my sportly little, low slung car can handle it!

Well, how did your car handle this past weekend? Were you able to get out of your driveway? And what kind of sporty little car is it?


Well, I forgot how much fun and how much terror a rear-wheel drive car can be in snow...


Took it out Saturday morning, before any of the roads had been cleared. Went OK on the roads, the worst of the snow was packed down or driven clear. Getting going at a stop was a slow, patient, plan well ahead process. If I gave it gas, the back end would try to slide out, so I had to let it get going first.

As for what kind of car:
It's this little guy

It does look like a fun little car, but I do remember how rear-wheel drive cars perform and the terror they can cause in the heart of the driver when show is introduced into the equation. Given a clear parking lot, however...that's a different story. I just showed my 12-year old daughter how to spin backwards in my front-wheel drive car this past weekend. I can't help it - I just have to do it once every winter.


I do the same thing in my minivan once a year and my wife completely looses her cool. She totally freaks out about how dangerous it is blah blah blah. She doesn't seem to care that I learned how to do it safely from my own father.


_______________________________________________________________

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 #1523669
Posted Tuesday, December 17, 2013 9:21 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:07 PM
Points: 2,766, Visits: 7,241
Sean Lange (12/17/2013)
Ed Wagner (12/17/2013)
jasona.work (12/17/2013)
Ed Wagner (12/16/2013)
jasona.work (12/13/2013)
Ed Wagner (12/13/2013)
jasona.work (12/13/2013)
OK, where did the year go?
I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago I was starting this job and planning my vacation...

I know what you mean, Jason. Christmas is almost here and my shopping isn't done. Winter is also here are we're supposed to get 3" to 6" starting tonight. Seize each day and try to make the most of it.


From the snow you're talking about, sounds like you're in my neck of the woods.

Which means tomorrow or Sunday, I get to see how my sportly little, low slung car can handle it!

Well, how did your car handle this past weekend? Were you able to get out of your driveway? And what kind of sporty little car is it?


Well, I forgot how much fun and how much terror a rear-wheel drive car can be in snow...


Took it out Saturday morning, before any of the roads had been cleared. Went OK on the roads, the worst of the snow was packed down or driven clear. Getting going at a stop was a slow, patient, plan well ahead process. If I gave it gas, the back end would try to slide out, so I had to let it get going first.

As for what kind of car:
It's this little guy

It does look like a fun little car, but I do remember how rear-wheel drive cars perform and the terror they can cause in the heart of the driver when show is introduced into the equation. Given a clear parking lot, however...that's a different story. I just showed my 12-year old daughter how to spin backwards in my front-wheel drive car this past weekend. I can't help it - I just have to do it once every winter.


I do the same thing in my minivan once a year and my wife completely looses her cool. She totally freaks out about how dangerous it is blah blah blah. She doesn't seem to care that I learned how to do it safely from my own father.


Did he teach you in a minivan? Minivans are a lot more top heavy and less stable than most cars.


--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
Post #1523763
Posted Tuesday, December 17, 2013 9:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:32 PM
Points: 13,302, Visits: 12,168
Stefan Krzywicki (12/17/2013)
Sean Lange (12/17/2013)
Ed Wagner (12/17/2013)
jasona.work (12/17/2013)
Ed Wagner (12/16/2013)
jasona.work (12/13/2013)
Ed Wagner (12/13/2013)
jasona.work (12/13/2013)
OK, where did the year go?
I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago I was starting this job and planning my vacation...

I know what you mean, Jason. Christmas is almost here and my shopping isn't done. Winter is also here are we're supposed to get 3" to 6" starting tonight. Seize each day and try to make the most of it.


From the snow you're talking about, sounds like you're in my neck of the woods.

Which means tomorrow or Sunday, I get to see how my sportly little, low slung car can handle it!

Well, how did your car handle this past weekend? Were you able to get out of your driveway? And what kind of sporty little car is it?


Well, I forgot how much fun and how much terror a rear-wheel drive car can be in snow...


Took it out Saturday morning, before any of the roads had been cleared. Went OK on the roads, the worst of the snow was packed down or driven clear. Getting going at a stop was a slow, patient, plan well ahead process. If I gave it gas, the back end would try to slide out, so I had to let it get going first.

As for what kind of car:
It's this little guy

It does look like a fun little car, but I do remember how rear-wheel drive cars perform and the terror they can cause in the heart of the driver when show is introduced into the equation. Given a clear parking lot, however...that's a different story. I just showed my 12-year old daughter how to spin backwards in my front-wheel drive car this past weekend. I can't help it - I just have to do it once every winter.


I do the same thing in my minivan once a year and my wife completely looses her cool. She totally freaks out about how dangerous it is blah blah blah. She doesn't seem to care that I learned how to do it safely from my own father.


Did he teach you in a minivan? Minivans are a lot more top heavy and less stable than most cars.


LOL. There was no such thing a minivan back then, at least not by that name. We did however do donuts in my VW bus. Talk about top heavy and unstable.


_______________________________________________________________

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 #1523768
Posted Tuesday, December 17, 2013 10:07 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 29, 2014 8:59 AM
Points: 2,670, Visits: 19,241
Sean Lange (12/17/2013)
Stefan Krzywicki (12/17/2013)
Sean Lange (12/17/2013)
Ed Wagner (12/17/2013)
jasona.work (12/17/2013)
Ed Wagner (12/16/2013)
jasona.work (12/13/2013)
Ed Wagner (12/13/2013)
jasona.work (12/13/2013)
OK, where did the year go?
I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago I was starting this job and planning my vacation...

I know what you mean, Jason. Christmas is almost here and my shopping isn't done. Winter is also here are we're supposed to get 3" to 6" starting tonight. Seize each day and try to make the most of it.


From the snow you're talking about, sounds like you're in my neck of the woods.

Which means tomorrow or Sunday, I get to see how my sportly little, low slung car can handle it!

Well, how did your car handle this past weekend? Were you able to get out of your driveway? And what kind of sporty little car is it?


Well, I forgot how much fun and how much terror a rear-wheel drive car can be in snow...


Took it out Saturday morning, before any of the roads had been cleared. Went OK on the roads, the worst of the snow was packed down or driven clear. Getting going at a stop was a slow, patient, plan well ahead process. If I gave it gas, the back end would try to slide out, so I had to let it get going first.

As for what kind of car:
It's this little guy

It does look like a fun little car, but I do remember how rear-wheel drive cars perform and the terror they can cause in the heart of the driver when show is introduced into the equation. Given a clear parking lot, however...that's a different story. I just showed my 12-year old daughter how to spin backwards in my front-wheel drive car this past weekend. I can't help it - I just have to do it once every winter.


I do the same thing in my minivan once a year and my wife completely looses her cool. She totally freaks out about how dangerous it is blah blah blah. She doesn't seem to care that I learned how to do it safely from my own father.


Did he teach you in a minivan? Minivans are a lot more top heavy and less stable than most cars.


LOL. There was no such thing a minivan back then, at least not by that name. We did however do donuts in my VW bus. Talk about top heavy and unstable.
Fun aside, I feel it's important to break it loose at least once a year, so that you remember what it feels like and how to control/recover from it. Saves a second of panic when it happens for real.


---------------------------------------------------------
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 #1523794
« Prev Topic | Next Topic »

Add to briefcase «««4,2364,2374,2384,2394,240»»»

Permissions Expand / Collapse