June 23, 2011 at 7:37 am
Jeff Moden (6/23/2011)
Craig Farrell (6/20/2011)
Don't even get me started on the incredibly interesting answers I've gotten for "Describe two differences between Truncate and Delete".BWAAA-HAAA!!!! Such easy questions! 😉 Everyone knows they're spelled differently and have a different number of letters! :hehe:
That one I have to pass on to my boss!
June 23, 2011 at 9:08 am
Jeff Moden (6/23/2011)
Craig Farrell (6/20/2011)
Don't even get me started on the incredibly interesting answers I've gotten for "Describe two differences between Truncate and Delete".BWAAA-HAAA!!!! Such easy questions! 😉 Everyone knows they're spelled differently and have a different number of letters! :hehe:
They are?
Truncate = D R O P T A B L E
Delete = D R O P T A B L E
I don't see the diff.
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
June 23, 2011 at 9:18 am
SQLRNNR (6/23/2011)
They are?
Truncate = D R O P T A B L E
Delete = D R O P T A B L E
I don't see the diff.
I think you have it backwards
Drop table -> delete
drop table -> truncate
drop table -> DBA phone rings
Yep, they are different.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 23, 2011 at 9:24 am
Steve Jones - SSC Editor (6/23/2011)
SQLRNNR (6/23/2011)
They are?
Truncate = D R O P T A B L E
Delete = D R O P T A B L E
I don't see the diff.
I think you have it backwards
Drop table -> delete
drop table -> truncate
drop table -> DBA phone rings
Yep, they are different.
Why monkey around? Drop Database saves so many steps.
--------------------------------------
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
June 23, 2011 at 9:39 am
Having been there I would say there is no such thing as a silly question. While I try not to give the full answer if i feel the person hasn't put enough effort I do try to make sure they are pointed in the right direction.
Frankly I believe in SQL as a technology and would be glad to help anybody who wants it.
Beside a few basic questions are worth it when u come across a Gem every once in a while.
Case in point
I recently learned that we could host database files on a Raw partition , I always assumed they would have be part of a file system , btw i have a newbie to thank for that.
June 23, 2011 at 9:43 am
Jayanth_Kurup (6/23/2011)
Having been there I would say there is no such thing as a silly question. While I try not to give the full answer if i feel the person hasn't put enough effort I do try to make sure they are pointed in the right direction.Frankly I believe in SQL as a technology and would be glad to help anybody who wants it.
Beside a few basic questions are worth it when u come across a Gem every once in a while.
Case in point
I recently learned that we could host database files on a Raw partition , I always assumed they would have be part of a file system , btw i have a newbie to thank for that.
I agree. There is no such thing as a silly question. There are only silly people asking me questions.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
June 23, 2011 at 9:49 am
Jayanth_Kurup (6/23/2011)
I recently learned that we could host database files on a Raw partition , I always assumed they would have be part of a file system , btw i have a newbie to thank for that.
Ah! Thank you, I didn't know this one.
There seems to be some limitation, though.
BTW, this THREAD stopped being related to the original question maaaany posts ago. Now it's a sort of watercooler thread. Welcome aboard!
At times, when I find incredibly messy questions, I am highly tempted to post an abrupt "Yes, they are". I managed to resist up to now. 🙂
-- Gianluca Sartori
June 23, 2011 at 10:21 am
Gianluca Sartori (6/23/2011)
Jayanth_Kurup (6/23/2011)
I recently learned that we could host database files on a Raw partition , I always assumed they would have be part of a file system , btw i have a newbie to thank for that.Ah! Thank you, I didn't know this one.
There seems to be some limitation, though.
BTW, this THREAD stopped being related to the original question maaaany posts ago. Now it's a sort of watercooler thread. Welcome aboard!
Is it watercooler or scuttlebutt?
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
June 23, 2011 at 10:34 am
SQLRNNR (6/23/2011)
Gianluca Sartori (6/23/2011)
....BTW, this THREAD stopped being related to the original question maaaany posts ago. Now it's a sort of watercooler thread. Welcome aboard!Is it watercooler or scuttlebutt?
Yes... @=)
June 23, 2011 at 10:46 am
June 23, 2011 at 11:01 am
Jayanth_Kurup (6/23/2011)
Damn , I knew I should have read thru the previous 2757 pages 😀
Page 1384 is gold!
--------------------------------------
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
June 23, 2011 at 11:06 am
SQLRNNR (6/23/2011)
Gianluca Sartori (6/23/2011)
Jayanth_Kurup (6/23/2011)
I recently learned that we could host database files on a Raw partition , I always assumed they would have be part of a file system , btw i have a newbie to thank for that.Ah! Thank you, I didn't know this one.
There seems to be some limitation, though.
BTW, this THREAD stopped being related to the original question maaaany posts ago. Now it's a sort of watercooler thread. Welcome aboard!
Is it watercooler or scuttlebutt?
Nah we are all here sucking on those frozen beer popsicles that Jeff hordes in his freezer.
June 23, 2011 at 11:46 am
Stefan Krzywicki (6/23/2011)
Jayanth_Kurup (6/23/2011)
Damn , I knew I should have read thru the previous 2757 pages 😀Page 1384 is gold!
Is that the default 10 posts/page?
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
June 23, 2011 at 12:05 pm
SQLRNNR (6/23/2011)
Stefan Krzywicki (6/23/2011)
Jayanth_Kurup (6/23/2011)
Damn , I knew I should have read thru the previous 2757 pages 😀Page 1384 is gold!
Is that the default 10 posts/page?
Yes, but I also just picked a number in the middle at random. : -)
--------------------------------------
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
June 23, 2011 at 12:06 pm
Brandie Tarvin (6/23/2011)
SQLRNNR (6/23/2011)
Gianluca Sartori (6/23/2011)
....BTW, this THREAD stopped being related to the original question maaaany posts ago. Now it's a sort of watercooler thread. Welcome aboard!Is it watercooler or scuttlebutt?
Yes... @=)
water-butt?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"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."
Viewing 15 posts - 27,571 through 27,585 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply