What's the difference between user_name() and suser_sname()?

Does setuser affect user_name()? Does it affect suser_sname()

Creating a System Stored Procedure

Creating a system stored procedure isn't hard. You're always cautioned from making changes to the system, depending on the system for a particular functionality, etc., and you should be cautious. However adding system stored procedures to your servers can be beneficial and make your administration much more convenient. Read on the see how easy this can be to do.

You have a small shopping cart application and...

Quickly Moving Databases

This article by Chris Kempster shows you how to quickly move a database by detaching or taking a database offline.

You have setup SQL Server Agents alerts to...

Fragmentation 101

Another article from our own Chris Hedgate! This one looks at the different types of fragmentation that can exist inside your SQL Server and some ways you can go about minimizing them.

Enhanced Query Analyzer

Here's a little replacement for Query Analyzer that appears to provide most of the functions, plus a few more. While we haven't given it a full review, at first glance it appears to do the job. Plus there's NO INSTALL!!!! Always a plus for me.

You are a SQL Server DBA and you...

Execution Plans

How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance.