-
-
Recent Posts
- AzureRM, Azure CLI and the PowerShell Az Module
- Installing Azure CLI on Linux Mint
- Create multiple dashboards in the Azure Portal
- Custom Job scheduling, remote queries, and avoiding false negatives using PowerShell and SQL Agent
- In-Memory logging and log “compression”
- Manipulating SQL Agent Jobs through PowerShell
- Loading and using SQL Server Management Objects in PowerShell
Categories
- Certification (2)
- Cloud Computing (8)
- Community (50)
- Database (73)
- Events (66)
- HADR (20)
- Learning (4)
- Linux (29)
- Microservices (1)
- Networking (8)
- Personal Development (54)
- Programming (7)
- Security (7)
- SharePoint (2)
- SQLServerPedia Syndication (174)
- SSIS (3)
- Storage (9)
- Systems Center (1)
- Virtualization (14)
- Windows (35)
Tags
- 24HOP
- Active Directory
- Audio
- Automation
- Availability Groups
- Azure
- AzureRM
- Azure VM
- Backup and Recovery
- Business
- C#
- Charity
- Clustering
- Concurrency
- Connectivity
- Constraints
- Database
- DBMS_SCHEDULER
- Desktop
- Development
- DMV
- DNS
- Docker
- Dockercon
- dotnet
- Error
- Escalation
- File-System
- GUI
- Humour
- Hyper-V
- In-Memory
- Integrity
- Isolation Levels
- Jobs
- Linux
- Listener
- Locking
- Mirroring
- NETBIOS
- Nomcom
- Oracle
- Parallelism
- PASS Summit
- Performance
- PowerShell
- Public Speaking
- Quorum
- RAC
- Reporting
- Scale-Out
- Scheduling
- Security
- Setup
- SharePoint Saturday
- Skype
- SMO
- Snapshots
- SQL
- SQLBits
- sqlcmd
- SQL Nexus
- SQLRally
- SQLSaturday
- SSMS
- Stored Procedure
- Systems Center
- T-SQL
- T-SQL Tuesday
- TCPIP
- TSQL
- Tuning
- 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 Database, SQLServerPedia Syndication, Storage
Tagged File-System, Performance, SQL, T-SQL
3 Comments
