T-SQL: Why “It Depends”
Why does everyone use "it depends" as an answer to many T-SQL questions? Bob Hovious brings us a short example of how performance can change based on data loads for the same code.
2010-03-16
13,260 reads
Articles
An overview of Master Data Services - MDS in SQL Server 2008 R2
With Master Data Services, IT organizations can centrally manage critical data assets companywide.
2010-03-16
2,557 reads
Solving All Versus (Select All) SSRS End User Confusion
When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of...
2010-03-16
2,847 reads
Beginning T-SQL 2008 - Book Review
A book review of a new T-SQL book for SQL Server 2008, written by longtime SQLServerCentral author and MVP, Kathi Kellenburger.
2010-03-15
1,922 reads
Denormalization Strategies
In building a database, typically we want a well normalized design. However there are cases for considering options for denormalization in complex systems. Timothy Claason gives you some thoughts on the subject.
2010-03-15
11,446 reads
SQL Server Central launches online training for SQL Server Developers, DBA’s, and Analyst’s
Build your SQL Server skills without leaving your desk.
2010-03-15 (first published: 2010-03-11)
7,097 reads
SQL Server 2008 Audit Change Group
Auditing your SQL Server instances has become more of a concern these days. SQL Server 2008 introduced a new feature named SQL Server Audit. Enabling this feature can be done in just a few simple steps, but so could disabling this feature. And when it comes to audits, many times you are asked to provide proof that the audit itself has not been tampered with.
2010-03-15
2,121 reads
SQL Server 2008 T-SQL Enhancements Part - II
Continuing with his series on changes in SQL Server 2008, Arshad Ali takes a look at table enhancements and new data types.
2010-03-12 (first published: 2009-07-27)
29,523 reads
Log Growing Pains
Understanding the transaction log seems to be a very difficult concept fro mos DBAs to grasp. Jason Brimhall brings us a new article that helps to troubleshoot the cause of log growths.
2010-03-11
18,880 reads
Kimball University: Three ETL Compromises to Avoid
Why neglecting slowly changing dimensions, failing to capture metadata and overlooking scope creep can be the undoing of a dimensional data warehousing initiative.
2010-03-11
4,390 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