These vids are really great!
The folks at SQL Share do a really nice job with their quick 2-minute videos series on SQL Server topics. I really like the depth and breath of these short snippets, and is just right for some of the basic tasks when either doing development or administration in SQL Server. Wished that I would have thought of the idea! Likewise the crew at Midnight DBA also do some pretty slick stuff too, so go check out both of those sites for training vids. If you need a quick-start on a subject, either just might be of assistance. I oughta call those folks and see if I can get in on the fun with them!
I saw one today from SQL Share on the new feature in SQL Server 2008 for scripting data. This is a very handy feature for sure. There is, though, one little caveat to remember when using this new addition. A large database will create a huge text file very quickly, so opening it in SSMS will be a no-no most of the time, and, you may have to use sqlcmd to actually run the script. Sure, you can open it in say UltraEdit or some other file, but even when you turn off the temporary files feature you can still see only so much data. Large tables with a lot of rows will create one massive file – I know I tried one just for the heck of it. Boy was that a bad idea. Also, if you need to have only the data, simply flip the SCRIPT CREATE option to off, so that all you get is the INSERTS and not all of the other stuff.
Happy Scripting!
Lee
-----------------------
Merry Christmas!
a43760cf-82da-4509-ad78-5dc9d543ab5d|0|.0