• Interests: Vedic Maths

Technical Article

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,732 reads

Technical Article

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,685 reads

Technical Article

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

8,268 reads

Blogs

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Why Managed Identities are Awesome

By

For the first workdays of this new year, I had the pleasurable task of...

Read the latest Blogs

Forums

How to Increase Your Cash App Limit From $2500 To $7500? (2023 Guide)

By syrussymon542

If you're looking to increase your Cash App limit from $2500 to $7500, you'll...

find connection details for all ssis jobs

By Bhagat

Hi, is there are way using sql that brings a list of the ssis...

Does SQL Server eventually terminate idle connections to the database?

By HookSQLDBA7

We are only trying to answer the below questions regarding database connections for an...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers