Memory Consumed By SQLServer
Have you wondered how much memory was being consumed by SQL Server? Have you wondered if there was a way to find out that information from a tSQL command?...
2011-02-28
21 reads
Memory Consumed By SQLServer
Have you wondered how much memory was being consumed by SQL Server? Have you wondered if there was a way...
2011-02-28
3,540 reads
SSAS - Preserve Measure Null Values
Generally when designing a data warehouse (at least in my experience) you don’t think about NULL values appearing often in...
2011-02-28
5,872 reads
JTDS & Grails
Recently I had the chance to do some tuning on a system that was built using Grails (formerly Groovy on...
2011-02-28
2,494 reads
SQLskills SQL Server Immersion Training: A Retrospective
Last week I attended the inaugural training event of the new four-week SQL Server Immersion Training offered by Kimberly Tripp...
2011-02-28
2,013 reads
Adventure Works Sample Database Diagrams
Most of my examples utilize either adhoc type of data samples or one of the versions of AdventureWorks. I do...
2011-02-27
2,973 reads
Quests Performance Monitor Counters Poster
I just wanted to take a moment to thank Kevin Kline, Brent Ozar, Christian Bolton, Bob Ward, Rod Colledge and...
2011-02-27
3,049 reads
SQLskills Immersion Event on Internals and Performance – Day 5
Overview
Today was the fifth and final day of the Internals & Performance immersion event. I have really enjoyed learning from not...
2011-02-26
1,790 reads
Test Complete – MCM
I took the MCM test today, and finished it. I needed the time allotted and it was, well, an experience....
2011-02-25
1,791 reads
Finding Compressed Tables
Have you been working with compression? Have you inherited a database that may or may not have some tables compressed? On occasion you may want to know what the...
2011-02-25
26 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers