David tries his hand at Project Management and what follows is a list of tips and problems from that experience. As David points out, it's interesting to see things from the other (not developer or DBA) point of view.
2003-06-04
5,747 reads
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
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
One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!
2002-10-11
11,929 reads
This SQL2000 function accepts a delimited list of values as a string and the character you want to use as a delimiter.The function then splits these out and returns them as a table.The function assumes that the input string will contain unique integer values.Useage: - SELECT Id FROM fnSplit('1,2,3,4' , ',')
2002-06-27
574 reads
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 […]
2001-11-25
9,144 reads
2001-09-04
3,035 reads
What skills do you need to be a DBA? Lots of different ones, but people often forget there are non-technical skills that matter. This article by David Poole examines some of the softer skills
that can help your career.
2001-08-28
7,921 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Short post today. Simple query that will tell you every job that ran between...
One of my clients, Justin Williams, is a blogger. He owns a website named...
Comments posted to this topic are about the item Checking Up on Vendors, which...
I have a table keeping client notes that can be updated and the previous...
Thinking of getting a perpetual standard licensing with certain number of cores. Was wondering...
Ask SSC