If you truncate a table, you cannot undo the action like you can with a delete. What is the difference between the two methods to remove data from a table?
A Haunting TSQL Tuesday Tale
Tag: TSQL Tuesday
October 2010 TSQL Tuesday Reminder
Holy Cow, another month has flown by without much of a hint. We now have upon us another TSQL Tuesday. If you hadn’t heard or haven’t seen the twitter announcement, you can find it […]
TSQL Tuesday Indexes and Blobs
How does one find what columns were LOB columns in the database. I knew I had some past blog posts about various aspects of LOBs, but I had never broken it down to find the columns in the LOB. Even better was that I wanted to know what columns were in what index that were also a BLOB.
September TSQL Tuesday
It is hard to believe that time is flying like it is. Already it has been a month since I hosted TSQL Tuesday. This month the party is being hosted by the Database Whisperer, Michael […]
TSQL Tuesday 009 Roundup
T-SQL Tuesday #009: Beach Time I hope you enjoyed your time in the sun with your toes in the sand. We are wrapping up this vacation with a little recap on what we learned. There […]
R & R
It is once again time for the blog party known as TSQL Tuesday. I am hosting this month and wanted to also participate. The theme is “Beach Time” and this is TSQL Tuesday #9. Why […]
TSQL Tuesday Coming Up
The next TSQL Tuesday is only 1 week away. This month the topic covers getting a little R&R. We would like to know some of the things that you do in order to get the […]
T-SQL Tuesday #009: Beach Time
T-SQL Tuesday #009: Beach Time Congratulations! You have been chosen as a finalist in the Vacation Getaway package of a lifetime. You will be flown to a resort destination of your choosing. For this vacation, […]
Gettin’ Skewled
Observe and Report This month we get to frolic in our memories of school days. Thanks to HeadMaster Robert Davis (Blog | @SQLSoldier), we are entreated to a little detention while we figure out how […]
TSQL 2sday Coming Up
TSQL Tuesday is fast upon us once again. In fact, in my time zone, it is just a day away. This month the event is being hosted by Robert L. Davis. We get to go […]