Another Method of Testing for Updated Columns in a Trigger
This article by Andy Warren discusses how to use if update() in your update triggers to simplify your code. They are easy to use and quite effective!
2003-11-12
18,047 reads
Articles
When's Your Anniversary
Ever need to find out what anniversary dates are coming up? What about a list of birthdays in the near future? This article looks at querying for repeating dates.
2003-11-11
7,654 reads
Deleting Duplicate Rows
This article presents one technique to be used for removing duplicate rows in a table.
2003-11-07
15,260 reads
Transcript of SQL Technet Chat
This is a transcript of a recent chat that included our own Brian Knight!
2003-11-07
3,412 reads
Amazing FUD
How often do you hear FUD either for or against Microsoft? Know what FUD is? Steve Jones recently ran across an article looking at reasons why you don't want Microsoft products in your enterprise, specifically servers. Here's a few comments and a link to the article.
2003-11-06
4,585 reads
More Ideas About Using SQL-DMO
This article by Andy Warren introduces some additional SQL-DMO methods that are very useful when automating administrative tasks.
2003-11-05
11,572 reads
myLittleAdmin v2.5 available
myLittleTools.net is pleased to announce the release of its web-based MS SQL and MSDE database administration tool. Several tools have been added, including "BackUp and Restore database" tools, "CSV Import" tool, "Generate INSERT scripts" tool, "Detach/attach database" tool. Several toys have also been added, including the possibility to display database space used with SVG graph, or a new skin.
2003-11-05
1,734 reads
2003-11-04
179 reads
Why the SQL Server Optimizer Uses a Nonclustered Index Instead of a Cl
Interesting info about why the optimizer might choose to use a nonclustered index over a clustered index. Links to two other articles that cover each type of index in more detail.
2003-11-04
1,286 reads
Review of AdeptSQL
Another product review! Chris put AdeptSQL (a schema comparison and sync product) to work and wrote up the results. This article also includes some feedback from the vendor that is worth reading.
2003-11-03
5,194 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
A Fun Computer Quote
Comments posted to this topic are about the item A Fun Computer Quote
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers