January 2008 - Posts

• New version of Niels Berglund's SQLCLRProject

  SQLCLRProject is an alternative to the built-in support in VS for deploying SQLCLR objects. Check it out at: http://nielsb.wordpress.com/sqlclrproject/ Read More... Posted Tuesday, January 15, 2008 11:55 PM by TiborKaraszi | 0 Comments Filed under: Tools

• Non-trusted constraints and performance

  (See my part 1 article about non-trusted constraints in general: http://sqlblog.com/blogs/tibor_karaszi/archive/2008/01/12/non-trusted-constraints.aspx ) The optimizer is a pretty smart little animal. It can even use constraints to eliminate some data Read More... Posted Saturday, January 12, 2008 6:09 PM by TiborKaraszi | 4 Comments Filed under: Performance, Tools

• Non-trusted constraints

  A discussion in the newsgroups before the holidays lead to trusted constraints and performance. This inspired me to blog about it, but I decided to have some vacation first :-). Instead of having one long article, I'll do a two-part. This one is about Read More... Posted Saturday, January 12, 2008 5:13 PM by TiborKaraszi | 5 Comments Filed under: TSQL

• More maint procedures

  A few months ago, I blogged about a simple procedure to do backup ( http://sqlblog.com/blogs/tibor_karaszi/archive/2007/09/25/tsql-script-to-do-backup-like-maintenance-plans.aspx ). Just to let you know that Ola Hallengren has some of his own. Much more Read More... Posted Friday, January 11, 2008 11:57 AM by TiborKaraszi | 0 Comments Filed under: Backup, Maintenance