Problem Statement:Get the VLF count of all the dbs in a SQL server Instance. Solution: –variables to hold each ‘iteration’ DECLARE @query VARCHAR(100) DECLARE @dbname SYSNAME DECLARE @vlfs INT –table variable used to ‘loop’ over databases […]
Read moreLatest Posts
MSSQL Server : Automatically Restore DBs from backup files
Problem Statement:Many a times we need to restore multiple dbs from the backfiles on disk. We must write scripts to[…]
Read moreExam 70-475 (Designing and Implementing Big Data Analytics Solutions)
Skills Measured – Some Links Design big data batch processing and interactive solutions (20-25%) Ingest data for batch and interactive[…]
Read moreSQL Server:Write on “???” failed: 1453(Insufficient quota to complete the requested service.
Error:Write on “???” failed: 1453(Insufficient quota to complete the requested service. solution: Restrict the max server memory setting of the[…]
Read moreSQL Server Always On-Secondary database is NOT Synchronizing
Due to disk space crunch secondary database had gone into not synchronizing mode and it remained into that state even[…]
Read moreSSIS 2008R2 Training
SQL Server -Defragment Indexes
Problem: Many a times you need to defragment indexes on SQL server. Following query is quite handy for doing this[…]
Read more
