server Tag

HOW TO: Find When SQL Server Wait Stats Were Last Cleared

For years I have found myself often needing these three pieces of information with regards to SQL Server:When was the last time the server was restarted?When was the last time the SQL instance was restarted?When was the last time the SQL Server wait stats were cleared?If the server itself is restarted, then the...

Changing Default Database File Locations in SQL Server

When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties. You can see these properties for yourself by right-clicking on the instance name...

Top 3 Performance Killers For Linked Server Queries
Top 3 Performance Killers For Linked Server Queries

One thing I have noticed in all my years as a data professional: few users understand (or care) how far away they are from their data. Quite often they expect instant results from their queries despite there currently being an upper bound due to things like network bandwidth, the speed...

SQL Server Query Performance Tuning: A 12 Step Program

Performance tuning is hard. Everyone knows that.Has anyone ever tried to figure out why?Sure, there's that big old "it depends" that gets tossed about. Look, at the end of the day you only have so many possible resource bottlenecks: disk, memory, CPU, and network. I don't care if you are...

Survey Check Box with Green Checkmark and Pencil
Database Servers and Client Tools Survey

Last week I was reminded that opinions are split as to whether or not installing the database client tools (SSMS, Database Control, etc.) onto database servers is a good idea or not.I've worked at companies where the installation of such tools was discouraged. I've also known companies where the installation...