SQL Server 2016 SP1 Edition Limit Changes

This content is 2 years old. Microsoft made the following changes in their documentation (see screenshot above) to accurately reflect the memory limits on lower editions of SQL Server. Edition Information:  https://www.microsoft.com/en-us/sql-server/sql-server-editions Estimate Memory Requirements for Memory-Optimized Tables Key Points The limits for In-Memory OLTP data is per database. The limits for Columnstore segment cache is per … Read moreSQL Server 2016 SP1 Edition Limit Changes

Show Jobs that Will Run in Microsoft SQL Server

This content is 7 years old.I don’t remember the link I found this little tidbit at, but it’s useful. This will display the scheduled jobs on your Microsoft SQL Server instance that will be running in the future. USE msdb ;WITH CTE AS (SELECT schedule_id, job_id, RIGHT(‘0’+CAST(next_run_time AS VARCHAR(6)),6) AS next_run_time, next_run_date FROM sysjobschedules) SELECT … Read moreShow Jobs that Will Run in Microsoft SQL Server

Index Fragmentation Report in Microsoft SQL Server

This content is 7 years old.I came across something that I found useful today when troubleshooting some query performance reports. I won’t re-post the entire article, but here’s what I found useful and I tweaked it to my needs by ordering by avg_fragmentation_in_percent as well as only displaying results with IPS.page_counts greater than 1000 and … Read moreIndex Fragmentation Report in Microsoft SQL Server