SQL Server data files

Blogs

Disabling Non-Clustered Indexes For Fun and Profit

By

One of the frequently quoted ETL best practices is to disable your non-clustered indexes...

Steps for a Successful Data Migration Session at Microsoft Ignite

By

I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as...

Daily Coping 2 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SQL Sever becoming Non Responsive

By IT researcher

SQL  server 2008 R2 - express edition becomes non-responsive, whenever connection count crosses 12000....

replication from SQL Express 2017 > Ent Ed 2016.

By snomadj

Hey All, Requirement is replicate data from 2 tables from SQL Express 2017 >...

How can i get the data as below using sql

By aggy_02_20

Hi ...I am a newbie to SQL.......Help me with the below req for the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Using mode() in R

See possible answers