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...

Beware of Login Issues for Privileged Accounts

In a recent post, I described an attack against a privileged account using a simple SQL Injection technique of updating...

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...

Effects of Max Mem on Plan Cache

Reading a Microsoft Article (which can be found here) while making sure I understood what can cause a query plan to...

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...

SQL Judo’s Monthly Challenge – January 2014 – Restore the Master

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...

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...

Script to find the Fragmentation of indexes

Below is the script to find the fragmentation of the indexes created on a database.

SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level,
avg_fragmentation_in_percent,avg_page_space_used_in_percent,page_count
FROM sys.dm_db_index_physical_stats (DB_ID( N'Database name')...