Defining Your Culture
Imagine that you take over a team, department, maybe even a whole company, and as you look around at how...
2011-08-23
650 reads
Disk IO performance and SQLIO
Performance testing a new disk subsystem from a SQL Server perspective is one of the fun aspects of DBA work....
2011-08-23
3,449 reads
Autogrow bug – fixed with Denali
Recently I ran into a bug related to autogrow of the log file. Because this was the second time I...
2011-08-23
1,877 reads
SQLMCM Training – Day 15
The whole last 3 days I've spent almost every minute with reviewing the material from
the last 2 weeks (around 38...
2011-08-23
632 reads
Outstanding DBAs Make Relationships a Priority
In our open all hours global working world, do you ever wonder if perhaps the technology that is supposed to...
2011-08-22
1,035 reads
SQL Server – sys.dm_db_persisted_sku_features tells you about edition-specific features
sys.dm_db_persisted_sku_features lists all features which are utilized by the database. Features specific to Enterprise/Developer edition are:
- Compression,
- Partitioning,
- TDE and...
2011-08-22
1,376 reads
T-SQL to find Fragmented Indexes
Fragmentation of Indexes is one of the reason for low performing queries resulting in a poor application performance.
Today, I will...
2011-08-22
7,521 reads
SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes of maybe getting one selected. Last year, I only...
2011-08-22
9 reads
SQL Saturday 94
SQL Saturday 94 in Salt Lake City is fast approaching. Will you be there? I submitted three sessions in hopes...
2011-08-22
686 reads
Tracking down KPI error in PerformancePoint
On a few occasions, I have opened up my PerformancePoint scorecard on SharePoint to see an error staring at me:
So...
2011-08-22
776 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers