Technical Article

Script to determine backup finish times

SQL Server provides the RESTORE HEADERONLY command which helps users determine backup completion times.  What if you have the need to use this completion time for comparison, perhaps to set up a job that only restores the file if it is xx hours old.  This script can be used to determine the maximum backup finish […]

2002-12-04

384 reads

Technical Article

Dependencies on a specific table column

SQL Server provides a built-in stored procedure, sp_depends, that returns object dependencies.  Recently, I discovered a need for determining dependencies on a table column, not just the table itself.  For example, a table may be referenced by many stored procedures and views, but a specific column in that table may only be referenced in a […]

5 (1)

2002-12-03

1,322 reads

Blogs

Daily Coping 28 Oct 2021

By

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

The DBA as a helpdesk.

By

Every one and again you will see people asking What skill do you think...

What’s my MAC Address in a Command Prompt?–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

what this constrain meaning ?

By ahmed_elbarbary.2010

I work on sql server 2012 i see constrain but i don't know what...

OK, I still think like a programmer -- is there a better way to do this?

By Stephen Rybacki

My SQL tools tell me this invokes an inefficient step with an index scan. ...

Update table FirstName & LastName from Email addresses

By DaveBriCam

I have a table with three fields, FirstName, LastName and EmailAddress. The EmailAddress field...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers