Miscellaneous

Technical Article

Script to Show All Failed Jobs in Specified Period

  • Script

This script will allow you to create a stored procedure that will check a server for any jobs that have failed in a specified number of days. It has proven valuable to me, since I have servers with lots of jobs that run frequently; I got tired of checking the history of each job to […]

5 (4)

You rated this post out of 5. Change rating

2002-01-01

4,412 reads

Technical Article

List Table Definition

  • Script

System Stored Procedure to List the Table Definition of a table as a printable report. The procedure must exist in the master database. This works for any table in the current database. Do not fully qualify the tablename. Calling sample: use pubs exec sp_listtabledef 'authors'

3 (3)

You rated this post out of 5. Change rating

2001-12-18

3,432 reads

Technical Article

OSQL Process Watcher

  • Script

These 2 files plus sleep.exe (Resource kit) gives an administrator a good view of important blocking statistics in almost a real time fashion. You can use this with profiler to obtain some unique information very fast on a lead blocker if your gathering the right counters in profiler and dumping them in a table and […]

You rated this post out of 5. Change rating

2001-12-10

544 reads

Technical Article

Simple OLE DB Provider for XML

  • Article

The OLE DB Simple provider for XML (XML OSP) can be used to load the hierarchical data that is in an XML document into a read-only ADO recordset. The data can then be read and accessed by using the standard methods of the ADO Recordset object. The XML OSP can be used to provide a different method for working with data that is contained in XML documents.

2001-12-10

1,479 reads

Technical Article

How to Short-circuit Where Clauses

  • Script

There are many times when you might be concatenating text in a stored procedure to make a where clause, because the input parameters are optional. An alternative is to create many versions of the stored procedure - one for each possible combination of parameters - which can soon become too big. There is a more […]

3.75 (4)

You rated this post out of 5. Change rating

2001-11-25

4,282 reads

Blogs

Back in the EU

By

I flew to Amsterdam last night and hopefully by the time this publishes I’ll...

The Feedback Multiplier: How Leaders Can Turn Input into Innovation

By

In every organization there is a hidden currency more valuable than capital, more enduring...

Setting up SQL Server S3 Object Storage Integration using MinIO with Docker Compose (Updated for SQL Server 2025)

By

Update for SQL Server 2025: This post and the GitHub repo have been updated for...

Read the latest Blogs

Forums

Flexible Laptop on Rent in Noida for Students & Businesses

By SRITTECH

Looking for laptops without heavy investment? Laptop on rent in Noida is ideal for...

how to use a variable in a CASE statement?

By water490

hi everyone I am getting an error when I add a variable to a...

How to Use SQL Server Features to Cut Web App Latency in Half

By Muhammad Adnan

Comments posted to this topic are about the item How to Use SQL Server...

Visit the forum

Question of the Day

The New SQL Server 2025 Data type

In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?

See possible answers