-
-
Recent Posts
Categories
- Certification (1)
- Cloud Computing (5)
- Community (40)
- Events (61)
- Inside SQLSaturday (1)
- Learning (4)
- Linux (26)
- Networking (8)
- Oracle (5)
- Personal Development (45)
- Public Speaking (1)
- Security (7)
- SharePoint (3)
- SQL (128)
- SQLSaturday (1)
- SQLServerPedia Syndication (160)
- SSIS (2)
- Storage (9)
- Systems Center (1)
- Uncategorized (1)
- Virtualization (14)
- Windows (32)
Tags
24HOP Active Directory AlwaysOn APT Automation Availability Availability Groups Backup and Recovery Blogger Table Business C# Charity Clustering Concurrency Configuration Connectivity Constraints Database DBMS_SCHEDULER Desktop Development Disable DMV DNS dotnet Enable Error Escalation File-System GUI Humour Hyper-V Integrity Isolation Levels Jobs Kalen Delaney Linux Listener Locking Mirroring NETBIOS Nomcom Parallelism PASS Summit Performance Public Speaking Quorum RAC Reporting Rodney Landrum Ruben Pertusa Lopez Scale-Out Scheduling Schema Security Setup SharePoint Saturday Skype Snapshots SQLBits sqlcmd SQL Nexus SQLRally SQLSaturday SSMS Stored Procedure Systems Center T-SQL T-SQL Tuesday TCPIP Tuning Users VirtualBox Wait Stats WINE
Tag Archives: Performance
Problem removing files from TempDB
I recently ran into an interesting problem while attempting to remove approximately half of the TempDB data files configured in a testing environment. As you might expect, there are various SQL Server tasks that are performed infrequently by a DBA, and this is … Continue reading
Posted in SQL, SQLServerPedia Syndication, Storage
Tagged File-System, Performance, T-SQL
3 Comments
SQLBits 9 Slidedeck for READPAST & Furious
I am very pleased to publish the slide-deck for my Friday presentation “READPAST & Furious: Transactions, Locking and Isolation“. Just click here to obtain the slide-deck in PDF format. I had an absolutely fantastic time giving the presentation and really … Continue reading
Posted in Events, Personal Development, SQL, SQLServerPedia Syndication
Tagged Concurrency, Performance, Public Speaking, SQLBits, Tuning
When should you use NOLOCK?
Well the quick answer to that question is never. And there you have it, the quickest blog post in history (perhaps!). …Except that I should really have said “When should you use READUNCOMMITTED isolation or hint?” and then the question … Continue reading
Posted in SQL, SQLServerPedia Syndication
Tagged Concurrency, Isolation Levels, Locking, Performance, Scale-Out
2 Comments
