This was just an answer in a forum in September, but I keep getting requests for the script. So I am sharing it here for anyone that could be interested: Problem: large amount of registered servers, multiple DBA's needing updated registration info, DBA workstations added or rebuilt, many servers added at once. In cases like […]
2007-06-05 (first published: 2005-01-26)
932 reads
The only way to guarantee that your business rules are always enforced for all your data is by using constraints. Learn how to use them to enforce business rules in the database.
2007-06-05
3,215 reads
In systems that require, for auditing purposes, advanced logging and reproducibility of reports between runs, a straightforward update, insert, or delete may be counter-productive. In such circumstances, a bitemporal model is necessary
2007-06-04
2,464 reads
COALESCE() accepts a series of values and a value to use in the event that all items in the list are null; then, it returns the first not-null value. This tip describes two creative uses of the COALESCE() function in SQL Server.
2007-06-01
5,777 reads
Full scan statistics update can be slow and expensive on a large system, and a single update statistics job for a whole database can easily exceed an overnight maintenance window. This article looks at jobs that could update statistics on the system in parallel.
2007-05-31
2,046 reads
Post data as coming from an HTML FORM with METHOD=POST to an URL and retrieve the result. The script uses the WinHttp.WinHttpRequest.5.1 object.Call like :exec dbo.usp_httppost 'http://www.sqlservercentral.com/search/turbo.asp','searchstring=ftp&btnG= Go &cArticles=on&cForums=on&cScripts=on&sitesearch=http://www.sqlservercentral.com'
2007-05-30 (first published: 2005-01-19)
1,822 reads
Robyn Page delves into all the things you need to know, rather than want to know, about SQL Server replication.
2007-05-30
5,363 reads
Desc : This SQL statement will provide script for backup all your jobs.-- Remark : Grow-up "maximum characters per column" (for 8192) and disable "print column headers" in 'tools' / 'options'
2007-05-29 (first published: 2005-01-12)
403 reads
Learn how to upload multiple XML files to an SQL Server 2005 database XML data type column.
2007-05-29
3,285 reads
You can use arithmetic operators in date/time calculations in SQL Server, but sometimes the date/time functions provided by Microsoft are the better option. Follow a few scenarios that demonstrate when arithmetic operators are safe and when they are risky.
2007-05-28
7,463 reads
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Referrals have never been more important in the job market. They’re no longer nice...
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers