Differences In Native Compiled Procedures Execution Plans

All the wonderful functionality that in-memory tables and natively compiled procedures provide in SQL Server 2014 is pretty cool. But,...

Friday Followup For June 13, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

Query backup history

As a quick script tip for today I'll show you a script I use regularly for reporting purposes.
It shows you the...

Query backup history

As a quick script tip for today I’ll show you a script I use regularly for reporting purposes.

It shows you the...

Reblog: June 6 to June 12

Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...

SQL Saturday South Florida And Then Vacation

I’m leaving early afternoon for the longish drive to South Florida for SQLSaturday tomorrow. The schedule looks impressive! I missed...

Data loss in clustered index occurs when you run online build index in SQL Server 2012

Scared? Don’t worry, there is a workaround and a hotfix. More on that in a moment.
This morning I checked my...

Giving Away Woodworking Magazines

I read a lot and one of the topics I enjoy reading about is woodworking. Recently I’ve been on a...

Happy Anniversary!

Today, http://mssqlfun.com/ completed 2 precious years with your support & acknowledgment. It’s wonderful time enriched with fun & learning.
Please keep liking us...

Mainstream Support Ending Soon || SQL Server 2008 and SQL Server 2008 R2

Microsoft declares to release last & final service packs for SQL Server 2008 and SQL Server 2008 R2 very soon.
Mainstream Support...