• Interests: Vedic Maths

Locate primary key - foreign key relations

Recently one of my friend was doing some investigation in a new/unknown database and had really hard time locating the primary key – foreign key relations. Like it’s really tough to locate these relations when not enforced at database level in terms of primary key and foreign key constraints. But generally all database developers keep […]

4.14 (7)

2011-09-14 (first published: )

2,729 reads

Combine multiple rows into single output

We can use this function to combine multiple rows into single one. Generally to create comma separated list for each unique item. So this can create comma separated product list for any given category. The same can be used to make a list of items in a given order.ThanksMohit Nayyarhttp://mohitnayyar.blogspot.com/

5 (3)

2007-09-14

3,627 reads

To Get Latest SQL Job Status

This query will give you the current job status of all scheduled jobs on sql server. Just by using sysJobs, and sysJobHistory table you will get to know the details about the last status of the scheduled jobs, irrespective of their status like failed, successful, or cancelled.Note: You must have admin right on MSDB database […]

3.54 (13)

2003-09-04

7,758 reads

Blogs

Daily Coping 17 Sep 2021

By

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

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

SQL 2016 SP3 CHECKDB WITH EXTENDED_LOGICAL_CHECKS problem.

By Ken McKelvey

This seems to be the same problem which occurred with SQL2017 CU21 and is...

Find all SPs, FNs, and VWs where particular string occurs

By Vladimir Isaev

I have this task to find all SPs, FNs, and VWs where particular string...

Excel privary levels

By V

There are three Excel privacy levels: Private, Organizational, Public. When Excel's privacy level is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers