When joining multiple tables together in a query, use aliases every time on every field.
Say we've got two tables, Customers and Salespersons. The Customers table has a PreferredSalespersonID field that identifies who their normal sales rep is, and that lets us quickly grab the right salesperson when a customer calls in. We want to display ...
Read the full article
Linked servers let users query different database servers from a central SQL Server. Some uses for this might be:
DBA utility scripts - from a central repository server, we could query all of the servers in our environment to check for things like backup dates or configuration settings
Consolidated reporting - we could gather results from multiple ...
Read the full article
Jason Massie and I had a steel cage blogmatch about whether to configure a SAN with shared or dedicated drives, and we both passed out for exhaustion.
This debate is starting up again but with a slightly different spin: virtualization. In an environment with Microsoft Hyper-V or VMware ESX, more than one SQL Server ...
Read the full article
Database administrators: are you backing up your SQL Servers to local drives? If so, you need to stop for a minute to think about a few possible side effects, and maybe think about backing up to a network share instead. Why? I'm glad you asked!
Get your data off the server faster
My fellow Quest SQL Server ...
Read the full article
Jason Massie and Brent Ozar work with SQL Server for a living and write blogs for fun, but that’s where the similarities end. Jason’s a fan of shared storage SANs: putting SQL Server data and logs on the same set of physical ...
Read the full article