Scripts

sp_PerfSQ

A diagnostic tool for identifying Performance features of active SQL Queries. It collects performance detail from DMVs for queries with executing requests and is designed to demonstrate and quantify Query Shaping optimisation techniques by: quantifying query workload and throughput characteristics providing behavioural descriptors of potential performance inhibitors - refer column ThrottlePotential The ThrottlePotential column is […]

5 (3)

2019-11-07

2,120 reads

Generic trigger for maintaining the Audit Log

This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.

Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.

2.33 (3)

2019-10-15 (first published: )

681 reads

List Extended Database properties for all databases

I am using database properties to add some useful information for each database. Tired of exploring each database from the menu in SSMS to look for specific information, I decided to make a script listing the extended properties for all my databases. I am pleased to offer this to the community 🙂

2019-10-01 (first published: )

581 reads

WorkDay Functions

Functions to list the number of work days in period , determine if a given date is a work day, add work days to a given date.
Uses a table of holidays and a tally table.

2019-09-24 (first published: )

742 reads

A DateRange Table Valued function

The function is an inline table-valued function (or sometimes called a parameterised view) so it can be used just like a view or a table but needs parameters. It generates a single-column table of datetime2 with rows differing by any multiple of any of the dateparts that SQL Server provides.

5 (5)

2019-08-29 (first published: )

1,023 reads

Blogs

Renewed as a Friend of Red Gate

By

I recently received the news that I’ve been renewed as a Friend of Red...

Redgate Software Needs You!

By

I’ve been very blessed to be able to work for Redgate Software. We’ve done...

Extended Events: Database Auditing

By

Extended Events can do things that simply are not possible with Profiler and another...

Read the latest Blogs

Forums

SSMA 8.6 Unable to find functions in extended stored procedures

By stonechain

I have an instance of SQL Server 2017 (Developer) installed with SSMA for Oracle...

Running generic query for table information

By sizal0234

Hi, I want to run the below query to get information about the tables...

Instance level trigger to store login information (who created what)

By Lord Slaagh

Hello SSC, I am looking for a simplified way to track which user created...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers