Wednesday, May 25, 2011

Moved over to foxtricks.posterous.com

›
I move over the blog to http://foxtricks.posterous.com Most posts from this blog can be found over there. You will be redirected in a fe...
Sunday, June 28, 2009

Going beyond sp_helpindex

›
Every SQL Server developer and DBA has to use the sp_helpindex from time to time to get some information on the indexes on a table. I have...
Friday, June 12, 2009

How to determine the default database path in all SQL Server Versions

›
When you create a database in SQL Server using the "CREATE DATABASE" statement without any options, the database files will be cre...
4 comments:
Tuesday, July 8, 2008

How to create SQL Server temp tables without collation problems

›
This message has moved to http://foxtricks.posterous.com
3 comments:
Friday, May 9, 2008

How to strip trailing zeros

›
A client came to me with another string formatting problem. I would never recommend formatting strings in T-SQL, but rather to do formatting...
4 comments:
Friday, November 23, 2007

How to make a thread safe insert/update procedure on SQL Server

›
When developing an application that does a lot of inserts and updates, it is sometimes easier to wrap both statements in one stored procedur...
10 comments:
Friday, August 10, 2007

Building a small Virtual PC with windows xp and SQL Server 2005 Developer edition

›
I love Virtual PC 2007, but I hate how every VPC image I used so far is at least 5GB and easily grows to 10GB. It is hard to keep multiple ...