Case of the Mondays... causing me to randomly redefine the Scope of Global temp tables

Today, I was reminded that global temp tables scope lasts for the session, and doesn't last beyond that. The difference...

Effects of Max Mem on Plan Cache

Some effects on plan cache and max memory settings
Related Posts:

The Curiously Large CASE Statement March 20, 2019

Maintenance Plan Owner - Back to Basics December 13, 2018

ArithAbort and...

Happy New Year 2015

I know it’s late but I’ve been away, I hope you all had a good Christmas and New Year.
I...

Las Vegas UG This week

What a fun week we have tuned up for the folks in Las Vegas.  It is the first full week...

Las Vegas UG This week

What a fun week we have tuned up for the folks in Las Vegas.  It is the first full week of January and there is this huge convention going...

New Learning Tree 1 Day SQL Server Training

Learning Tree has recently introduced some new 1 day virtual training events There is range of courses and subjects for...

Power BI Semantic Model Supports Many-to-Many Relationships

Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular...

Power BI Semantic Model Supports Many-to-Many Relationships

Is is possible to duplicate the same many-to-many relationship behavior in VertiPaq that we have in SSAS multidimensional? Since Tabular...

SQL #56–Aggregation with ROLLUP operator is not fully supported

ROLLUP, CUBE, and GROUPING SETS Operators have been around since SQL Server 2005. These operators are extensions of the GROUP...

Table Variables, CTE and Temp Tables. Which one should I use?

There are several really good blogs that already exists that explain the differences between Table Variable, Common Table Expressions (CTE)...