January 21, 2016 at 9:33 pm
Steve Jones - SSC Editor (1/20/2016)
This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length. We were, by far, the largest user of this forum software, and larger than any other .NET forums I've seen.
It might be the ongest running thread on the web, but surely not the longest running on the internet. The internet has been around quite a bit longer that longer than the web, usenet was in use on the internet in 1980, ten years before the first ever browser, and various forums with centralised mailing list servers were even earlier. Last time I looked there were still some threads around from the old days. None of the old threads was ever anything like as busy as this one, though, so if by "longest" you mean with the largest total message volume you may well be spot on, but a thread that started in 2008 is very unlikely to be the oldest.
Tom
January 22, 2016 at 4:44 am
Ran into something weird with temp tables this morning / yesterday. I have resolved the problem, but without understanding what the problem really was. Would appreciate some insight if anyone has any.
Check it out here.
January 22, 2016 at 6:31 am
Greg Edwards-268690 (1/21/2016)
Eirikur Eiriksson (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
😎
Mine must have been for a small elephant, as it was only 1 400 gallon kettle.
Can you even imagine the size of the fire required for such a large pot? Plus, you'd probably want to finish it in a frying pan to for caramelization, so that would need another fire. 😛
January 22, 2016 at 6:43 am
Ed Wagner (1/22/2016)
Greg Edwards-268690 (1/21/2016)
Eirikur Eiriksson (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
😎
Mine must have been for a small elephant, as it was only 1 400 gallon kettle.
Can you even imagine the size of the fire required for such a large pot? Plus, you'd probably want to finish it in a frying pan to for caramelization, so that would need another fire. 😛
Rack of ribs and burnt ends.
Smoker towed by a semi.
On a different note, hope everyone gets through the weather OK.
Sounds like it will be a rough weekend storm for many.
January 22, 2016 at 7:08 am
Ed Wagner (1/22/2016)
Greg Edwards-268690 (1/21/2016)
Eirikur Eiriksson (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
😎
Mine must have been for a small elephant, as it was only 1 400 gallon kettle.
Can you even imagine the size of the fire required for such a large pot? Plus, you'd probably want to finish it in a frying pan to for caramelization, so that would need another fire. 😛
Nah. Just need to toss a couple gallons of kerosene on the fire the raise the temp. :w00t:
_______________________________________________________________
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/
January 22, 2016 at 9:30 am
Sean Lange (1/22/2016)
Ed Wagner (1/22/2016)
Greg Edwards-268690 (1/21/2016)
Eirikur Eiriksson (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
😎
Mine must have been for a small elephant, as it was only 1 400 gallon kettle.
Can you even imagine the size of the fire required for such a large pot? Plus, you'd probably want to finish it in a frying pan to for caramelization, so that would need another fire. 😛
Nah. Just need to toss a couple gallons of kerosene on the fire the raise the temp. :w00t:
Well, that would do it. I wonder what smoked elephant would taste like. The only thing I'm sure of is that it wouldn't fit in my smoker.
January 22, 2016 at 9:39 am
Ed Wagner (1/22/2016)
Greg Edwards-268690 (1/21/2016)
Eirikur Eiriksson (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
😎
Mine must have been for a small elephant, as it was only 1 400 gallon kettle.
Can you even imagine the size of the fire required for such a large pot? Plus, you'd probably want to finish it in a frying pan to for caramelization, so that would need another fire. 😛
Rub salt and oil into the scored skin. 220C for the first 30 minutes then turn down to 190C for the remaining six weeks of cooking time. Perfect crackling.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
January 22, 2016 at 1:12 pm
So I just had an amusing moment...
I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as I watched the percent_complete and encryption_state in sys.dm_exec_database_encryption_keys. Yet now it's showing encryption state 1?!?
WTH?
So I do some digging into the SQL logs and the server-side trace I have to run, and track down an alter database set encryption off. Get the name of the workstation from the trace, and I think I know who it might be so I go talk to the developer.
Turns out he's publishing changes to the DB (it's still being developed) from Visual Studio and wasn't paying attention to what it was doing at the start of the script (setting encryption off.) So he's going to not run that part of the script from here on out and I'm happy to find I'm not crazy and seeing / remembering things that didn't happen!
January 23, 2016 at 9:41 am
jasona.work (1/22/2016)
So I just had an amusing moment...I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as I watched the percent_complete and encryption_state in sys.dm_exec_database_encryption_keys. Yet now it's showing encryption state 1?!?
WTH?
So I do some digging into the SQL logs and the server-side trace I have to run, and track down an alter database set encryption off. Get the name of the workstation from the trace, and I think I know who it might be so I go talk to the developer.
Turns out he's publishing changes to the DB (it's still being developed) from Visual Studio and wasn't paying attention to what it was doing at the start of the script (setting encryption off.) So he's going to not run that part of the script from here on out and I'm happy to find I'm not crazy and seeing / remembering things that didn't happen!
That's weird. I think it would have driven me crazy for a time as well. Not having Enterprise Edition, I've never worked with TDE. Do the developers have the permissions to turn off TDE for a database?
January 23, 2016 at 9:49 am
Ed Wagner (1/23/2016)
jasona.work (1/22/2016)
So I just had an amusing moment...I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as I watched the percent_complete and encryption_state in sys.dm_exec_database_encryption_keys. Yet now it's showing encryption state 1?!?
WTH?
So I do some digging into the SQL logs and the server-side trace I have to run, and track down an alter database set encryption off. Get the name of the workstation from the trace, and I think I know who it might be so I go talk to the developer.
Turns out he's publishing changes to the DB (it's still being developed) from Visual Studio and wasn't paying attention to what it was doing at the start of the script (setting encryption off.) So he's going to not run that part of the script from here on out and I'm happy to find I'm not crazy and seeing / remembering things that didn't happen!
That's weird. I think it would have driven me crazy for a time as well. Not having Enterprise Edition, I've never worked with TDE. Do the developers have the permissions to turn off TDE for a database?
Good question Ed, makes me wonder if the devs have sa rights to the prod!
😎
January 23, 2016 at 9:52 am
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
jasona.work (1/22/2016)
So I just had an amusing moment...I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as I watched the percent_complete and encryption_state in sys.dm_exec_database_encryption_keys. Yet now it's showing encryption state 1?!?
WTH?
So I do some digging into the SQL logs and the server-side trace I have to run, and track down an alter database set encryption off. Get the name of the workstation from the trace, and I think I know who it might be so I go talk to the developer.
Turns out he's publishing changes to the DB (it's still being developed) from Visual Studio and wasn't paying attention to what it was doing at the start of the script (setting encryption off.) So he's going to not run that part of the script from here on out and I'm happy to find I'm not crazy and seeing / remembering things that didn't happen!
That's weird. I think it would have driven me crazy for a time as well. Not having Enterprise Edition, I've never worked with TDE. Do the developers have the permissions to turn off TDE for a database?
Good question Ed, makes me wonder if the devs have sa rights to the prod!
😎
Heh - no wonder poor Jason is wondering if he's gone crazy.
January 23, 2016 at 9:58 am
ChrisM@Work (1/22/2016)
Ed Wagner (1/22/2016)
Greg Edwards-268690 (1/21/2016)
Eirikur Eiriksson (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
😎
Mine must have been for a small elephant, as it was only 1 400 gallon kettle.
Can you even imagine the size of the fire required for such a large pot? Plus, you'd probably want to finish it in a frying pan to for caramelization, so that would need another fire. 😛
Rub salt and oil into the scored skin. 220C for the first 30 minutes then turn down to 190C for the remaining six weeks of cooking time. Perfect crackling.
I like the sound of it but if it takes me an hour to perfectly pamper the Sunday roast, this would take days. My suggestion is to pour few thousand gallons of high quality olive oil on a target spot in Great Salt Plains State Park, grab the Dumbo by the ears in your Chinook, to a top speed low altitude flyby and drop it about 200 feets from the oil.
😎
January 23, 2016 at 10:02 am
Ed Wagner (1/23/2016)
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
jasona.work (1/22/2016)
So I just had an amusing moment...I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as I watched the percent_complete and encryption_state in sys.dm_exec_database_encryption_keys. Yet now it's showing encryption state 1?!?
WTH?
So I do some digging into the SQL logs and the server-side trace I have to run, and track down an alter database set encryption off. Get the name of the workstation from the trace, and I think I know who it might be so I go talk to the developer.
Turns out he's publishing changes to the DB (it's still being developed) from Visual Studio and wasn't paying attention to what it was doing at the start of the script (setting encryption off.) So he's going to not run that part of the script from here on out and I'm happy to find I'm not crazy and seeing / remembering things that didn't happen!
That's weird. I think it would have driven me crazy for a time as well. Not having Enterprise Edition, I've never worked with TDE. Do the developers have the permissions to turn off TDE for a database?
Good question Ed, makes me wonder if the devs have sa rights to the prod!
😎
Heh - no wonder poor Jason is wondering if he's gone crazy.
If this is the case then he should!
😎
January 23, 2016 at 10:04 am
Eirikur Eiriksson (1/23/2016)
ChrisM@Work (1/22/2016)
Ed Wagner (1/22/2016)
Greg Edwards-268690 (1/21/2016)
Eirikur Eiriksson (1/21/2016)
Greg Edwards-268690 (1/21/2016)
Steve Jones - SSC Editor (1/21/2016)
Greg Edwards-268690 (1/21/2016)
It seems he has an elephant on the menu, and a 6 quart pot to cook it in.But refuses to start carving up the elephant.
dinner's gonna be late
An old company recipe book describes cooking for 5 weeks at 450 degrees after spending 2 months cutting the elephant into bite size pieces. And that it serves about 3000 people.
So have you done this before? 😛
😎
Mine must have been for a small elephant, as it was only 1 400 gallon kettle.
Can you even imagine the size of the fire required for such a large pot? Plus, you'd probably want to finish it in a frying pan to for caramelization, so that would need another fire. 😛
Rub salt and oil into the scored skin. 220C for the first 30 minutes then turn down to 190C for the remaining six weeks of cooking time. Perfect crackling.
I like the sound of it but if it takes me an hour to perfectly pamper the Sunday roast, this would take days. My suggestion is to pour few thousand gallons of high quality olive oil on a target spot in Great Salt Plains State Park, grab the Dumbo by the ears in your Chinook, to a top speed low altitude flyby and drop it about 200 feets from the oil.
😎
Now I have to ask how long it would take to heat up that much oil. You'd have to have it up to temperature or the meat would just get oil soaked without cooking. Also, if you drop it from 200 feet, you're going to have a lot of splashing, so it would be better to lower it in slowly. Lastly, make sure the elephant is dry when you place it in the oil. You don't need to take the helicopter out of the air.
Gee, can you tell I like to cook? 😉
January 23, 2016 at 10:21 am
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
Eirikur Eiriksson (1/23/2016)
Ed Wagner (1/23/2016)
jasona.work (1/22/2016)
So I just had an amusing moment...I'm checking my servers for DBs that aren't TDE enabled and I come across a DB I *KNOW* was encrypted this morning as I watched the percent_complete and encryption_state in sys.dm_exec_database_encryption_keys. Yet now it's showing encryption state 1?!?
WTH?
So I do some digging into the SQL logs and the server-side trace I have to run, and track down an alter database set encryption off. Get the name of the workstation from the trace, and I think I know who it might be so I go talk to the developer.
Turns out he's publishing changes to the DB (it's still being developed) from Visual Studio and wasn't paying attention to what it was doing at the start of the script (setting encryption off.) So he's going to not run that part of the script from here on out and I'm happy to find I'm not crazy and seeing / remembering things that didn't happen!
That's weird. I think it would have driven me crazy for a time as well. Not having Enterprise Edition, I've never worked with TDE. Do the developers have the permissions to turn off TDE for a database?
Good question Ed, makes me wonder if the devs have sa rights to the prod!
😎
Heh - no wonder poor Jason is wondering if he's gone crazy.
If this is the case then he should!
😎
TDE. The bane of my existence. We had to encrypt the databases, based upon auditing requirements. Well, because the dev's need to have 5 (count 'em, 5) different environments that are copies of production as well as LOCAL COPIES OF PRODUCTION WHEN NEEDED I have to encrypt-decrypt-encrypt-decrypt day after day.
Thankfully I've been able to automate this, and even better, have made some good strides changing the way we do things.
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/
Viewing 15 posts - 52,336 through 52,350 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply