Not only is the process of normalization valuable for increasing data quality and simplifying the process of modifying data, but it actually makes the database perform much faster. To prove the point, Peter Larsson takes a large unnormalised database and subjects it to successive stages of normalisation.
This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.
Today we have an editorial from Aug 3, 2007. It is being republished as Steve is on vacation. Today Steve asks the question about which fun games you might like outside of work.
Planning on patching my SQL Servers to the latest service pack, but not sure how to complete this for a environment that is using database mirroring? In this tip, will outline the environment and then walk through the process of patching mirrored servers.
A callout text box outside the map area would help to enhance the visual effect of presenting data in reporting services.
This editorial was originally published on Sept 11, 2007. It is being re-run as Steve is on holiday. This is an interesting look at the cloud from 2007.
Joe Celko delves into the main uses of views, explains how the WITH CHECK OPTION works, and demonstrates how the INSTEAD OF trigger can be used in those cases where views cannot be updatable.
Today's editorial was originally published on Sept 4, 2007. It is being re-run as Steve is on holiday. Today Steve talks about the problems with customer service, and how some companies respond.
To prepare a database for mirroring, you need to perform the following steps: Script the restore of the latest full database backup, script the restore of every transaction log backup that has been made after that full database backup, copy the full database backup and transaction log backups to the mirror server, and run the restore scripts on the mirror server.
In this tip I will walk through these steps and provide sample scripts to prepare a database for mirroring.
This guest editorial from Michael Coles was originally published on Aug 1, 2007. It is being re-run as Steve is on vacation. Today Michael talks about the potential for reward for taking risk.
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Comments posted to this topic are about the item A Quick Second Opinion
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Comments posted to this topic are about the item Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers