Top 10 things I hate about SQL Server
-
http://weblogs.sqlteam.com/jeffs/archive/2005/05/24/5248.aspx[^] Old link, still funny as ever. I loved this comment: # re: TOP 10 THINGS I HATE ABOUT SQL SERVER 2/27/2006 11:59 PM Desperate This may not be the place to ask for help, but I was trying to shorten the name of one of my tables so that I might save time and effort typing the name in the future. The orginal name was Orders_For_February. My intention was to change it to Orders_For_Feb. So I used the Truncate... Truncate Table Orders_For_February Not only did it not make the table name smaller, there is no Data now!!! I have tried UnTruncate, but this does not seem to be a command. Next time I will try this on our development environment first.
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.
-
http://weblogs.sqlteam.com/jeffs/archive/2005/05/24/5248.aspx[^] Old link, still funny as ever. I loved this comment: # re: TOP 10 THINGS I HATE ABOUT SQL SERVER 2/27/2006 11:59 PM Desperate This may not be the place to ask for help, but I was trying to shorten the name of one of my tables so that I might save time and effort typing the name in the future. The orginal name was Orders_For_February. My intention was to change it to Orders_For_Feb. So I used the Truncate... Truncate Table Orders_For_February Not only did it not make the table name smaller, there is no Data now!!! I have tried UnTruncate, but this does not seem to be a command. Next time I will try this on our development environment first.
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.
truncate :)
On two occasions I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. - Charles Babbage
-
http://weblogs.sqlteam.com/jeffs/archive/2005/05/24/5248.aspx[^] Old link, still funny as ever. I loved this comment: # re: TOP 10 THINGS I HATE ABOUT SQL SERVER 2/27/2006 11:59 PM Desperate This may not be the place to ask for help, but I was trying to shorten the name of one of my tables so that I might save time and effort typing the name in the future. The orginal name was Orders_For_February. My intention was to change it to Orders_For_Feb. So I used the Truncate... Truncate Table Orders_For_February Not only did it not make the table name smaller, there is no Data now!!! I have tried UnTruncate, but this does not seem to be a command. Next time I will try this on our development environment first.
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.
-
http://weblogs.sqlteam.com/jeffs/archive/2005/05/24/5248.aspx[^] Old link, still funny as ever. I loved this comment: # re: TOP 10 THINGS I HATE ABOUT SQL SERVER 2/27/2006 11:59 PM Desperate This may not be the place to ask for help, but I was trying to shorten the name of one of my tables so that I might save time and effort typing the name in the future. The orginal name was Orders_For_February. My intention was to change it to Orders_For_Feb. So I used the Truncate... Truncate Table Orders_For_February Not only did it not make the table name smaller, there is no Data now!!! I have tried UnTruncate, but this does not seem to be a command. Next time I will try this on our development environment first.
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.
Control Z does not work on a bad update statement. Lazy MS :)
-
http://weblogs.sqlteam.com/jeffs/archive/2005/05/24/5248.aspx[^] Old link, still funny as ever. I loved this comment: # re: TOP 10 THINGS I HATE ABOUT SQL SERVER 2/27/2006 11:59 PM Desperate This may not be the place to ask for help, but I was trying to shorten the name of one of my tables so that I might save time and effort typing the name in the future. The orginal name was Orders_For_February. My intention was to change it to Orders_For_Feb. So I used the Truncate... Truncate Table Orders_For_February Not only did it not make the table name smaller, there is no Data now!!! I have tried UnTruncate, but this does not seem to be a command. Next time I will try this on our development environment first.
It's only when you look at an ant through a magnifying glass on a sunny day that you realise how often they burst into flames.
Given that I'm just finishing my first project involving a data base, this was a :cool: post to see. Fortunately, I don't think I'm guilty of believing too many of the items cited.
Software Zen:
delete this;