-
Recent Posts
Categories
- Certification (1)
- Cloud Computing (5)
- Community (46)
- Docker (1)
- Events (66)
- Inside SQLSaturday (1)
- Learning (4)
- Linux (27)
- Networking (8)
- Oracle (5)
- Personal Development (46)
- PowerShell (1)
- Public Speaking (1)
- Security (7)
- SharePoint (3)
- SQL (129)
- SQLSaturday (2)
- SQLServerPedia Syndication (165)
- SSIS (3)
- 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
- Connectivity
- Constraints
- Database
- DBMS_SCHEDULER
- Desktop
- Development
- Disable
- DMV
- DNS
- Dockercon
- 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