Interview Query – 1

Somewhere on internet i found this question. Thought to share it with you all.
We have two tables,  school_students and Class_student.
 
 ...

2018-09-17 (first published: )

2,450 reads

Starting with MS SQL Server

In one of my previous blog (https://sqldose.wordpress.com/2015/10/20/a-basic-introduction-of-database-tables-and-sql/ ) I gave a basic introduction about what is A Database and what is...

2016-04-10

523 reads

Non-Clustered Index

In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...

2015-10-04

377 reads

Blogs

Quick 6 month check – how are those learning goals going…?

By

So in January I wrote a blog post on some goals I had this...

Power BI Monthly Digest – July 2019

By

In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...

Read the latest Blogs

Forums

Changing Hardware

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Changing Hardware

Always On AG

By Admingod

I was trying to create cluster for AG group and it fails to create...

Generate Random alphanumeric value based on timestamp

By Siva Ramasamy

Hi All, Thank you for looking into my question. Does anyone have a script...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Intersection

See possible answers