Improving the performance of functions

Recently I had to employ functions to perform a kind of name resolution on a column within the database. The database had a user table with usr_name and usr_id and then all other FK tables used usr_id . Within the procedures we could naturally do joins to fetch the username but there were many other…

An Overview of the tools SQL Server database professionals use

Recently I was asked what tools database professionals use and I wanted to clarify a little bit on the topic so here goes. Previously we used to have a number of different tools when working with the database. If you look at just SQL 2000 we had Query Analyzer and Enterprise manager one for the…