• Interests: SQL, Biztalk, .NET

Technical Article

Create an audit trigger on a table

Sometimes you need an audit trigger on a table. I have created a generic trigger that will work for (almost)every table. if the audit table is not there yet, It will copy the table structure (but strip identity attributes) and put all the data in an AUDIT_ table.I believe this will work for almost every […]

5 (5)

You rated this post out of 5. Change rating

2004-09-02

1,597 reads

Technical Article

Restore Backup and all TRANLOGS in a specific DIR

Many DBA's have a Maintenance plan running that creates a backup every night and a transaction log backup every hour.Restoring them to another server (for whatever reason) can be a tedious job. That is why I wrote this T-SQL script.It will read the contents of a backup directory created by the maintenance plan and create […]

5 (1)

You rated this post out of 5. Change rating

2004-06-25

903 reads

Technical Article

Generate Insert/Update/Delete Sprocs for a table

A week ago I posted this script. It was a much simpeler version without error checking. Now all the sprocs return the same errors.    0 THERE WERE NO ERRORS  -99 UNEXPECTED NR OF RECORDS AFFECTED  0 THE SQL ERROR NUMBER Also with the insert statement the @ID is set. So you can retrieve the […]

You rated this post out of 5. Change rating

2003-02-25

386 reads

Technical Article

Generate Insert/Update/Delete/Get  SPROCS

This is a script that creates Insert / Update / Delete and Get stored procedures for a specific table.It will only work for tables with a unique primary key.Have a look at what is does, and if you like it, Vote for it. Maybe there are tons of sprocs out there that perform the same […]

4 (1)

You rated this post out of 5. Change rating

2003-02-19

269 reads

Technical Article

Log DISK IO statistics per Database file!!!

Well, ever wanted to know what was happening on disk....You could with FN_vitrualfilestats....Here is a NICE SPROC that samples all databases and puts it in a table. You can choose if you want to Retain values in the table or that it must be cleaned every time the sproc runs.( Put this data in a […]

You rated this post out of 5. Change rating

2003-01-31

894 reads

Technical Article

Stored Proc with optional parameters

Sometimes people want a Stored Proc with optional parameters. A lot of times people will use a coalesce for this. The problem with optional paremeters is that the query plan will never be an exact mach for that specific query. ( You never know what paremeters are filled..... )To solve this problem look at the […]

You rated this post out of 5. Change rating

2002-12-06

437 reads

Technical Article

INSERTS that will STAY after a ROLLBACK is issued

Sometimes it is usefull to log stuff in SQL server while stored procs are running. If a long stored proc runs you sometimes want to be able to log a message in a loggin file. But what if a rollback occurs.... The message is lost as well.Here is a method to set up a seperate […]

You rated this post out of 5. Change rating

2002-10-01

724 reads

Blogs

Parameter Sensitive Plan Optimization in SQL Server 2022. What is it and is it any good?

By

Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...

Azure chaos STUDIO

By

Chaos engineering is fun but especially important when building solutions in the cloud. It...

Announcing a New Book on SQL from 3Cloud Authors

By

I am proud to announce the launch of a new book, centered around the...

Read the latest Blogs

Forums

Fact Table - Various Grains

By flamblaster

Hi there, I'm on a team developing an enterprise data warehouse for our organization....

PostgreSQL Copy

By Shivayan Mukherjee

Comments posted to this topic are about the item PostgreSQL Copy

Secure Enclave Attestation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Secure Enclave Attestation

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers