David Poole

David Poole has been developing business applications since the days of the
Commodore Pet.

Those were the days when 8K was called RAM not KEYBOARD BUFFER.

He now works as Data Solutions Architect at Moneysupermarket
  • Interests: Badminton, Cycling and Music. Keen piano player.

Inherriting objects from an updated MODEL database

If new objects are created in the model database then these new objects only get created for new databases.Similarly, if objects are removed from user databases then getting them back into the database can be a pain.The following two stored procs copy objects from model to the current database if they do not already exist.

2003-01-10

30 reads

To find the next available ID

There are times when you have a limited range of ids and these have to be re-used as they become available.The script lists the first missing id in a table.Note that this script works best for a table with a limited number of rows, say sub 100,000I tested this on a PIII 500MHz 256Mb RAM […]

2002-12-09

114 reads

Loop through records without using a cursor

I sometimes have to loop through records in a database and perform a specific action on the value that is returned. For example, In the script below I loop through the user tables in sysobjects and simply print them out. This technique is useful when dropping all indices/triggers on a particular table, or adding WITH […]

3 (2)

2001-11-25

9,144 reads

Blogs

Daily Coping 6 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

All jobs that ran during a given time frame.

By

Short post today. Simple query that will tell you every job that ran between...

Instructions for Handling Errors of MySQL and PHPMyAdmin

By

One of my clients, Justin Williams, is a blogger. He owns a website named...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

Self-Joined to Find if Archived Versions of Record Exist w/o Duplicate Records

By brandon 94807

I have a table keeping client notes that can be updated and the previous...

Licensing question

By noobdba

Thinking of getting a perpetual standard licensing with certain number of cores. Was wondering...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers