Generating n-Tuples with SQL
An n-Tuple is a combination of values from rows of a table in pairs (2-Tuple) or triplets (3-Tuple), etc.
2012-05-17
12,971 reads
Articles
Get a Descriptive Name for SQL Server Analysis Services Profiler Event Class and Event Subclass
A customer provides an SQL Server Analysis Services trace file to analyze. You save this file into a trace table and execute T-SQL code to analyze the results. Rather than getting descriptive values for the EventClass and EventSubclass data, you get numerical values. How do you resolve these numerical values to meaningful descriptive names? Check out this tip to learn more.
2012-05-17
2,275 reads
Stop Asking and Start Making Decisions Today
You’re desperately trying to get things done but it’s just not happening for you. I’m going to let you in on a little secret, you’re doing it wrong!
2012-05-16
3,436 reads
The Real World: Implementing AWE
Describes the gains experienced in my environment by implementing AWE.
2012-05-16
8,153 reads
How to Create an Indicator and Gauge Report in SSRS - SQL Server 2008 R2 - Part 1
Arshad Ali discusses the details of creating reports with indicators and gauges in SQL Server 2008 and walks you through designing a one tablix report with two levels of grouping.
2012-05-16
3,124 reads
Partial Backup and Restore
Shawn McGehee discusses partial backups, how they're used, and how to avoid potential problems when restoring from a partial backup.
2012-05-15
3,016 reads
PASS Data Architecture VC presents Mike Fal on Eating the Elephant: SQL Server Table Partitioning
On Thursday May 17th 12PM noon Central, Mike Fal will discuss "SQL Server's table partitioning gives the DBA tools to manage this beast and support very large tables in a way where index management and data retrieval..."
2012-05-15
2,124 reads
A Stock Price Correlation Matrix
Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function
2012-05-14
7,079 reads
Amazon RDs and the PaaS formerly known as Azure
Phil Factor welcomes SQL Server support by Amazon RDS, as an alternative to having Microsoft as service provider as well as software provider, via the PaaS formerly known as Azure.
2012-05-14
262 reads
Snapshot Isolation Level in SQL Server - What, Why and How - Part 1
Snapshot isolation levels improve performance but there are some things to take into consideration when using this feature. Arshad Ali discusses what snapshot isolation levels are, their variants, and why and when we should use them.
2012-05-14
4,253 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers