Table Size Script Update for 2015
As was recently promised, I have an update to an old tried and true script for calculating the size of...
2015-08-04
1,061 reads
Hekaton - In Memory OLTP - Getting Started / FAQ :- 1
SQL Server 2014 introduced a major feature called "In Memory - Hekaton" Tables, in which even the fundamental concepts of SQL...
2015-08-04
1,093 reads
Start SQL Server in Single User Mode
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-08-03
4,103 reads
Clearing Out a Database With SQL Compare
I ran into a question recently about how to clear out a database of all objects. I assume someone was...
2015-08-03
1,254 reads
Using the DAC
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-08-03
739 reads
SQL Server – Sparse Column Property using SELECT INTO
Hi friends, in our day to day work we used SELECT…INTO clause to create replica of a table for different...
2015-08-03
673 reads
Monday Morning SQL Break – August 3, 2015
It’s (finally) time for Monday’s weekly blog and twitter round-up for last week (it’s even on time). This post is...
2015-08-03
601 reads
Differences Between Actual & Estimated Plans
I have, in the past, made way too much of the need for Actual Plans when doing performance troubleshooting. The...
2015-08-03
881 reads
SQL Crossword
I decided I’d have some fun today. So for your entertainment here is my first crossword puzzle. (Word and PDF...
2015-08-03
960 reads
Consolidating Multiple Data Marts
One of the challenges that I've worked on in the past months involved adapting our technical architecture to address issues exposed by business re-engineering. The BI group at CHC used to assign specific...
2015-08-03
48 reads
Blogs
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers