Content rating: Beginner This blog was originally posted on December 17, 2009. I’ve pulled it out of the closet for T-SQL Tuesday #10, with apologies for being too gosh-darn busy to write something new. This is a companion blog to “Get Index Included Column Info“. What are indexes for? We need to talk indexes […]
Category: Tech and Learning
Tip: Use System Views to Compare Column Datatypes
Let’s say that you have a staging table, that then loads to a destination table in the same database. If you have more than one person working on the process, data types can quickly get out of whack. So: what’s the easiest way to compare datatypes bewteen two “matching” tables? System views, my friends! Let’s create […]
Tip: RESTORE FILELISTONLY / WITH MOVE
As we’ve seen in recent DBARant-able tales, not everyone is completely familiar with methods of restoring SQL backup files to new filepaths. The answer, in short, is: RESTORE FILELISTONLY/ RESTORE WITH MOVE. Let’s say that you backed up the database ImportantDB from your production server, and you want to restore it to a test server. […]