When designing a database to support applications you need to consider how you are going to handle primary keys. This article explores natural and surrogate keys, and discusses the pros and cons of each, allowing you to determine what makes the best sense in your environment when you are designing your databases.
2011-02-15
5,434 reads
One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right,...
2011-02-15
1,312 reads
A review of SQL Monitor, the new DBA utility from Red Gate Software that can help you keep an eye on what your SQL Server instances are doing.
2011-02-14
3,776 reads
I sometimes want to perform auditing or other actions in a trigger based on some criteria. More specifically, there are a few cases that may warrant an e-mail; for example, if a web sale takes place that requires custom or overnight shipping and handling. It is tempting to just add code to the trigger that sends an e-mail when these criteria are met. But this can be problematic for two reasons: (1) your users are waiting for that processing to occur, and (2) if you can't send the e-mail, how do you decide whether or not to roll back the transaction, and how do you bring the problem to the attention of the administrator?
2011-02-14
2,819 reads
Come learn about SQL Server in Phoenix on Feb 19, 2011. For free! Spread the word to anyone you know in the area.
2011-02-14 (first published: 2011-02-09)
1,726 reads
Is there a way to not allow users to use SELECT * in their queries? New author AJ Raghuram has an interesting solution that can prevent this in code.
2011-02-11 (first published: 2009-11-05)
44,406 reads
This article demonstrates using SQL Server's data mining capabilities with the Excel.
2011-02-11
5,472 reads
Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you...
2011-02-11
2,330 reads
Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information...
2011-02-10
2,126 reads
Learn Integration Services from SSIS expert and MVP, Andy Leonard in March. This 5 day class will be held on Mar 21-25, 2011 in Farmville, Virginia.
2011-02-10 (first published: 2011-01-25)
6,075 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item Optimism Without Illusion or Why...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers