You get an SQL70001 when you attempt to build a database project inside Visual Studio.
You try to use NEWID() in a UDF in SQL Server 2008 but you get an error that stops you.
I’ve written a script that will tell you how much space each table in your database is using up.
Moving a database file to a new location is a common task that if done incorrectly can cause massive headaches. Here is a quick overview of how to perform this task.
Sometimes you want to download a table from your live system into a testing environment, but don’t want to have to pull the whole database down. Moving a single table to a new filegroup makes this sort of task much easier as you can just backup and restore the filegroup into an existing database. Here is the script to move a table to a new filegroup.
Wierd problem that has a very simple fix.
Trigger recursion can be the cause of very hard to find bugs. Luckily it is easily prevented.
So you have a recursive table model with parent/child relationships. Unfortunately with this model circular references are possible and can wreak havoc in your application. Here is how to prevent them.
A complete list of all collations available in SQL Server 2008 R2 (there’s a lot!).
I’m going to have a quick look at computed columns in SQL server 2008 today and give a quick overview of how to create them and how they work.