December 2009 - Posts

• Using sa as owner for jobs and databases

  This blog is not about avoiding logging in using the sa login. Hopefully we all know about this, and work towards avoidning this practice. Instead I want to talk about using sa, but not to login (authenticate), but as owner for jobs and databases. I want Read More... Posted Wednesday, December 30, 2009 9:19 AM by TiborKaraszi | 10 Comments Filed under: Security, SQL Server Agent

• Util procedure to show database size

  One of the first things I want to do when I look at a new SQL Server is to get an idea of space usage details for each database, including total space usage. For this I have been using my own sp_db_space_usage for a while now, so I decided to add it to Read More... Posted Tuesday, December 29, 2009 2:17 PM by TiborKaraszi | 8 Comments Filed under: Tools

• Be careful with constraints calling UDFs

  You might just not get what you think. I would be surprised if this hasn't been blogged already, but if so, it would be worth repeating. Here's the deal (example from a forum,, slightly re-worked): I want the values in one column to be unique, assuming Read More... Posted Thursday, December 17, 2009 7:28 PM by TiborKaraszi | 31 Comments Filed under: TSQL