SQLdose

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

Beginning T-SQL and Career Roadmap for Women (and Men)! #SQLSatBR

By

Download session materials and watch the recordings of my excellent sessions on Transact-SQL and...

Actual Kubernetes

By

This post continues looking at my process of learning more about Kubernetes. I’ve been...

New product: Azure Data Share

By

A brand new product by Microsoft called Azure Data Share was recently announced. It...

Read the latest Blogs

Forums

How to make in memory SQL transformations within a data flow task

By svenflock

Hi all, first of all, I am new to Integration Services. I googled everything...

CAST FOR XML - Illegal Name Character

By jamie_collins

I am trying to write a query that generates an html report to be...

Get the inactive records in sqlserver

By kbhanu15

HI Team, please help to get the expected data. my Data like below: create...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers