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,724 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,612 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,357 reads

Blogs

Join SQLSat Memphis Virtually This Saturday

By

Looking forward to presenting at SQLSaturday Memphis virtually this weekend! Both my wife and I...

Failing SQL Agent Jobs – Part 4

By

Here we are, another Tuesday!! It is time for our Fourth and final installment...

I Want PASS to Survive

By

I want PASS to survive. I can say that unequivocally, because this organization has...

Read the latest Blogs

Forums

issue with adding another column in a table

By sameer

Hi, i have a table named as Book_master_tbl having only 10 records and as...

When one of your DBA colleagues leaves the company, what is your checklist?

By Cláudio Silva

Comments posted to this topic are about the item When one of your DBA...

Using Intel Optane/DAX/PMEM with FCI

By Luke L

I'm working to plan a new upgrade to our existing data warehouse infrastructure.  We're...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers