• 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,729 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,627 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

7,780 reads

Blogs

Azure Cosmos DB – HTAP using Azure Synapse Link

By

I haven’t done much blogging in the last 6 months. My last article was...

Azure Cosmos DB – HTAP using Synapse Analytics

By

I haven’t done much blogging in the last 6 months. My last article was...

Power BI Meets Programmability – TOM, XMLA, and C#

By

For anyone who read the title of this and immediately thought, “Oh no, I...

Read the latest Blogs

Forums

AlwaysON on one Node

By Arsh

Hi friends, Is it possible to configure ALwaysON with two instances on one node...

SQL Server Single Instance FCI - Failover Error

By Shivkumar

I have the following setup. 3 Node WSFC Cluster hosted on EC2 in three...

Disabling all access to the server

By Alex John

Hello everyone! We have a small group of users (4) using MS Access 2000...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers