Blog Posts

Get a List of Files with Data

The trick here is to find a way to search thousands of files quickly and filter easily the bad from the good. Sounds like an opportunity for an automation...

2020-01-13 (first published: )

565 reads

T-SQL Basics: using OUTPUT

You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...

2020-01-09 (first published: )

948 reads

Blogs

Microsoft Tools That Help Query Tuning

By

Query tuning is not easy. In fact, for a lot of people, you shouldn’t...

Author of the Year 2019 Nomination at MSSQLTips

By

This year I’ve been nominated again for the Author of the Year award at...

Extended Events Misperceptions: Profiler is Easier

By

I know, I know, I’m on #teamexevents so I think that Extended Events can...

Read the latest Blogs

Forums

how to create query based on optional field on temp table ?

By ahmed_elbarbary.2010

problem how to create query based on optional field on temp table ? I...

how to create query based on optional field on temp table ?

By ahmed_elbarbary.2010

problem how to create query based on optional field on temp table ? I...

SQL Transaction Replication on a large DB

By ARPRINCE

I want to create a transaction replication (SVR-A to SVR-B) from scratch on one...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers