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.

Technical Article

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

31 reads

Technical Article

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

122 reads

Technical Article

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,151 reads

Blogs

Honored to be a Microsoft MVP Again

By

I was renewed this week as a Microsoft MVP. This is my 15th award...

Thank You Kevin!

By

I don’t think I’m going too far out on a limb to call Kevin...

Daily Coping 6 Jul 2022

By

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

Read the latest Blogs

Forums

Establishing a Connection to PostgreSQL with GoLang

By sabyda

Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...

How to create a linked service to a VM where I will copy files from Blob storage

By dndaughtery

I have files in Blob Storage that I'd like to copy over to a...

Logshipping meta data is not updated

By ramyours2003

Meta data in Log shipping tables are not updated  in msdb  when i checked...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers