Posts
- SQL DATA File Movement
- Shrink Tempdb without service restart
- How to check index fragmentation and resolve it
- DBCC Commands
- Database Growth Report
- SQL blocking & Header Blocker
- Useful-trace-flags
- Most Common wait-types
- Complete sql server dba tutorial for
"Hello and welcome to my blog! Dive into a world of MS SQL Database solutions where every challenge is met with expertise. Prepare to expand your knowledge daily as we unravel the intricacies of database management together."
Subscribe to:
Posts (Atom)
Backup types in SQL server
1) full 2) differential 3) tlog 4) tail log --for full backup its include entire backup of your database. query= backup database DB_name...
-
Trace Flag 1117 (Auto Grow All Files in a Filegroup): This trace flag ensures that all files in a filegroup grow together when one file need...
-
Question: How to Shrink TempDB Without SQL Server Restart? Answer: Some times we are not able to shrink the tempdb files following simple s...
No comments:
Post a Comment