The columns_updated function gives you the ability to easily test to see if specific columns were modified with less code than you might otherwise need to use. In this article Andy Warren demonstrates how to create a trigger that uses this function and points out some reasons why you may NOT want to use it!
2003-08-21
18,270 reads
Don't like the blackbox approach of maintenance plans? Like the maintenance plans but need a tweak to suit your needs? New author Robin Back has put together a monster script to allow you to build your own quickly and easily.
2003-08-20
9,851 reads
Where should SQL Server go in the future? Steve Jones continues to explore his wish list for future versions of SQL Server. This article looks at some of the performance related enahncements he'd like to see.
2003-08-18
4,634 reads
Brian writes regularly for us on sql security issues, this week he discusses the pros and cons of various authentication methods.
2003-08-14
18,263 reads
SQL Scripter is a tool for SQL Server 7.0/2000 database administrators and developers to script data in a valid T-SQL format which can be executed in Query Analyzer. All types are supported (INSERT, UPDATE, DELETE). It's free in the moment. (Not Reviewed)
2003-08-13
1,259 reads
Chris discusses questions raised by his first article on clustered indexes. Few subjects more important to master than clustered indexes, this is good reading!
2003-08-12
10,041 reads
Red Earth Technologies announces the release of Superior SQL Builder, a new SQL tool that visually builds complete SQL scripts, not just single queries. It employs a completely different method of developing SQL scripts. By taking advantage of new scripting technology, Superior SQL Builder can visually build complete SQL scripts within a single, integrated environment. This means that SQL scripts can be developed faster, while reducing syntax and logic errors. (Not Reviewed)
2003-08-12
68 reads
Where should SQL Server go in the future? What enhancements are needed? Steve Jones continues to explore his wish list for future versions of SQL Server.
2003-08-11
5,173 reads
The final beta of Log Navigator has been released. This sql server auditing tool reads the MS SQL Server transaction log to track all data changes with no performance overhead or use of triggers. You can read database auditing trails from activity that took place even before the tool was installed. Powerful filters allow you to sort audit data by date, user, table and more. New features include LIVE LOG support and XML export. (Not Reviewed)
2003-08-11
48 reads
Changing a replicated table in SQL 7 was a lot of work. SQL 2000 offers some help, but in many cases it's not enough. This article by Andy Warren shows you which changes SQL 2000 will help you with and which ones it won't.
2003-08-08
14,495 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Risk Vs Reward, The never...
Comments posted to this topic are about the item Hyperscale Replicas IV
Comments posted to this topic are about the item The SQL Server Date Magic:...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers