July 14, 2016 at 7:31 am
Brandie Tarvin (7/14/2016)
ThomasRushton (7/14/2016)
Brandie Tarvin (7/14/2016)
I'm in the last few days before Go Live on a major infrastructure upgrade. I'm lucky I can spell SEQUAL. @=)
Isn't that the time when SQL renames as "SQUEAL"? 😉
Pretty much! :w00t:
I remember it well. May you remain sufficiently caffeinated to get through unscathed.
Thomas Rushton
blog: https://thelonedba.wordpress.com
July 14, 2016 at 8:59 am
ThomasRushton (7/14/2016)
Brandie Tarvin (7/14/2016)
ThomasRushton (7/14/2016)
Brandie Tarvin (7/14/2016)
I'm in the last few days before Go Live on a major infrastructure upgrade. I'm lucky I can spell SEQUAL. @=)
Isn't that the time when SQL renames as "SQUEAL"? 😉
Pretty much! :w00t:
I remember it well. May you remain sufficiently caffeinated to get through unscathed.
From the directors point of view, SQL means Squeeze or "a strong financial demand or pressure, typically a restriction on borrowing, spending, or investment in a financial crisis.
"industry faced higher costs and a squeeze on profits""
😎
July 14, 2016 at 9:36 am
Brandie Tarvin (7/14/2016)
I'm in the last few days before Go Live on a major infrastructure upgrade. I'm lucky I can spell SEQUAL. @=)
I once had a friend tell me she had some sales guy ask her, "how do you spell SQL?" And the guy was serious!!!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
July 14, 2016 at 10:26 am
Ray K (7/14/2016)
Brandie Tarvin (7/14/2016)
I'm in the last few days before Go Live on a major infrastructure upgrade. I'm lucky I can spell SEQUAL. @=)I once had a friend tell me she had some sales guy ask her, "how do you spell SQL?" And the guy was serious!!!
I have a friend (not a native English speaker) who was called up for an interview by an agent. They agreed to meet outside a local KFC. My friend asked the agent to spell KFC. Not a good start to proceedings.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 14, 2016 at 10:50 am
Phil Parkin (7/14/2016)
Ray K (7/14/2016)
Brandie Tarvin (7/14/2016)
I'm in the last few days before Go Live on a major infrastructure upgrade. I'm lucky I can spell SEQUAL. @=)I once had a friend tell me she had some sales guy ask her, "how do you spell SQL?" And the guy was serious!!!
I have a friend (not a native English speaker) who was called up for an interview by an agent. They agreed to meet outside a local KFC. My friend asked the agent to spell KFC. Not a good start to proceedings.
Ouch!!!
_______________________________________________________________
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/
July 14, 2016 at 10:56 am
Phil Parkin (7/14/2016)
Ray K (7/14/2016)
Brandie Tarvin (7/14/2016)
I'm in the last few days before Go Live on a major infrastructure upgrade. I'm lucky I can spell SEQUAL. @=)I once had a friend tell me she had some sales guy ask her, "how do you spell SQL?" And the guy was serious!!!
I have a friend (not a native English speaker) who was called up for an interview by an agent. They agreed to meet outside a local KFC. My friend asked the agent to spell KFC. Not a good start to proceedings.
Depends on the "traffic"
(traffic = volume of spiff)
😎
July 15, 2016 at 5:29 am
Well, I decided that I should probably take a look at the generator in garage. We had some serious storms last night, I wanted to be prepared.
I moved all the boxes still stacked in front of it. Took a look at the label to possibly find an instruction book online.
It's a Hayward H100ID1. Which means it's not a generator. It's a POOL HEATER!
Back to the drawing board on figuring out how and what the wiring that's labled "generator" does!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 15, 2016 at 5:47 am
Michael L John (7/15/2016)
Well, I decided that I should probably take a look at the generator in garage. We had some serious storms last night, I wanted to be prepared.I moved all the boxes still stacked in front of it. Took a look at the label to possibly find an instruction book online.
It's a Hayward H100ID1. Which means it's not a generator. It's a POOL HEATER!
Back to the drawing board on figuring out how and what the wiring that's labled "generator" does!
Is there a pool for the pool heater?
July 15, 2016 at 6:18 am
Grumpy DBA (7/15/2016)
Michael L John (7/15/2016)
Well, I decided that I should probably take a look at the generator in garage. We had some serious storms last night, I wanted to be prepared.I moved all the boxes still stacked in front of it. Took a look at the label to possibly find an instruction book online.
It's a Hayward H100ID1. Which means it's not a generator. It's a POOL HEATER!
Back to the drawing board on figuring out how and what the wiring that's labled "generator" does!
Is there a pool for the pool heater?
Yes, we have a pool. I haven't needed a heater, the water's been in the 80-85 range since the beginning of June.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 15, 2016 at 6:26 am
Grumpy DBA (7/15/2016)
Michael L John (7/15/2016)
Well, I decided that I should probably take a look at the generator in garage. We had some serious storms last night, I wanted to be prepared.I moved all the boxes still stacked in front of it. Took a look at the label to possibly find an instruction book online.
It's a Hayward H100ID1. Which means it's not a generator. It's a POOL HEATER!
Back to the drawing board on figuring out how and what the wiring that's labled "generator" does!
Is there a pool for the pool heater?
Another possibility is that the previous owner had a portable generator that they fired up and plugged into the house during a power failure. If so, there will be a plug that's wired into the box, but the breaker for it may be turned off. I had this setup at my old house and I used a 220 V 20 A plug to feed the box in the garage. The plug looked like the one here: https://www.amazon.com/Leviton-2421-3-phase-Industrial-Grounding/dp/B000PDDDHY and the cord had 2 ends that plugged in and then twisted to lock them in place. I fired up the generator, turned off the main and turned on the breaker. It fed power to the whole house and it was discipline on what I appliances I used.
I've not been to your new house, but a friend of mine had a similar setup where the generator was stored in a separate building away from his house. The previous owner there must have wanted to get the noise farther away.
I think step 1 is for you to get the garage cleaned out so you can see what you have. Then you have a chance of tracing wires back to the main box.
July 15, 2016 at 6:55 am
Ed Wagner (7/15/2016)
Grumpy DBA (7/15/2016)
Michael L John (7/15/2016)
Well, I decided that I should probably take a look at the generator in garage. We had some serious storms last night, I wanted to be prepared.I moved all the boxes still stacked in front of it. Took a look at the label to possibly find an instruction book online.
It's a Hayward H100ID1. Which means it's not a generator. It's a POOL HEATER!
Back to the drawing board on figuring out how and what the wiring that's labled "generator" does!
Is there a pool for the pool heater?
Another possibility is that the previous owner had a portable generator that they fired up and plugged into the house during a power failure. If so, there will be a plug that's wired into the box, but the breaker for it may be turned off. I had this setup at my old house and I used a 220 V 20 A plug to feed the box in the garage. The plug looked like the one here: https://www.amazon.com/Leviton-2421-3-phase-Industrial-Grounding/dp/B000PDDDHY and the cord had 2 ends that plugged in and then twisted to lock them in place. I fired up the generator, turned off the main and turned on the breaker. It fed power to the whole house and it was discipline on what I appliances I used.
I've not been to your new house, but a friend of mine had a similar setup where the generator was stored in a separate building away from his house. The previous owner there must have wanted to get the noise farther away.
I think step 1 is for you to get the garage cleaned out so you can see what you have. Then you have a chance of tracing wires back to the main box.
Cleaning out the garage is the key to lots of things around here!!!!
I had made a similar set up at my old house. It was a 220 line with plugs on both ends. One end went into the generator, the other went into a box connected to a breaker in the panel. If the power went out, the main got flipped, the generator got fired up, and the power went into the house. Certainly not up to code, but it worked.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
July 15, 2016 at 7:50 am
Michael L John (7/15/2016)
It's a Hayward H100ID1. Which means it's not a generator. It's a POOL HEATER!
I bet you're so glad you checked!
July 15, 2016 at 10:10 am
Ed Wagner (7/15/2016)
Grumpy DBA (7/15/2016)
Michael L John (7/15/2016)
Well, I decided that I should probably take a look at the generator in garage. We had some serious storms last night, I wanted to be prepared.I moved all the boxes still stacked in front of it. Took a look at the label to possibly find an instruction book online.
It's a Hayward H100ID1. Which means it's not a generator. It's a POOL HEATER!
Back to the drawing board on figuring out how and what the wiring that's labled "generator" does!
Is there a pool for the pool heater?
Another possibility is that the previous owner had a portable generator that they fired up and plugged into the house during a power failure. If so, there will be a plug that's wired into the box, but the breaker for it may be turned off. I had this setup at my old house and I used a 220 V 20 A plug to feed the box in the garage. The plug looked like the one here: https://www.amazon.com/Leviton-2421-3-phase-Industrial-Grounding/dp/B000PDDDHY and the cord had 2 ends that plugged in and then twisted to lock them in place. I fired up the generator, turned off the main and turned on the breaker. It fed power to the whole house and it was discipline on what I appliances I used.
I've not been to your new house, but a friend of mine had a similar setup where the generator was stored in a separate building away from his house. The previous owner there must have wanted to get the noise farther away.
I think step 1 is for you to get the garage cleaned out so you can see what you have. Then you have a chance of tracing wires back to the main box.
That's what I'd think. My business partner has this. A plug in the wall where he plugs in a portable, hand crank generator when power is out.
July 15, 2016 at 4:18 pm
Ray K (7/14/2016)
Brandie Tarvin (7/14/2016)
I'm in the last few days before Go Live on a major infrastructure upgrade. I'm lucky I can spell SEQUAL. @=)I once had a friend tell me she had some sales guy ask her, "how do you spell SQL?" And the guy was serious!!!
Sounds like the folks I've been interviewing. Hmmmm.... maybe I should start asking them what the number for 911 is. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
July 15, 2016 at 8:59 pm
Jeff Moden (7/15/2016)
Ray K (7/14/2016)
Brandie Tarvin (7/14/2016)
I'm in the last few days before Go Live on a major infrastructure upgrade. I'm lucky I can spell SEQUAL. @=)I once had a friend tell me she had some sales guy ask her, "how do you spell SQL?" And the guy was serious!!!
Sounds like the folks I've been interviewing. Hmmmm.... maybe I should start asking them what the number for 911 is. 😛
I can't find nein won won on the phone.
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 - 54,961 through 54,975 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply