How To Find Server details using SQL Query

Microsoft Community Contributor Badge

Microsoft Community Contributor badge

Maximum Stored Procedure, Function, Trigger, or View Nesting Level Exceeded (limit 32)

Power Shell Script To Read Registry Of Multiple Server

How To Run Single Script on Multiple Servers

HOW TO DONATE ORGANS

Failed to run patch request for instance: (exit code: -2068709375) : Single Node Cluster Patching !!

Single Node Cluster Patching

Frequently used DMV's in SQL Server

The media family on device '' is incorrectly formed. SQL Server cannot process this media family

What is the Difference Between Rebuild and Reorganize indexes ; Interview Question

The SQL Server failover cluster instance 'instance name' was not correctly detected. The instance was discovered on the local node but it was not found to be active.

Could not clear 'DIFFERENTIAL' bitmap in database 'database name' because of error 9002

SQL Server Management Studio (SSMS) Keyboard Shortcuts

What is the difference between SQL Profiler vs Server side Trace

Server Side Trace vs Client Side Trace

SQL Server Job details in SQL 2000 , SQL 2005 , SQL 2008

Query is running slow from client sql server, Real Time Performance Issue

What Is The Difference Between Checkpoint And Lazy Writer : Interview Question

Why SQL Server SPID is blocking itself

Hi All

Issue: SPID is blocking itself

Description: On one of our server SQL 2005 i have run one maintainence (update statistics)job in morning hours on a businessday and as it should not create any issues i was monitoring server health. After executing job i found spid 64(belongs to job)  is blocking itself.and after some time it went off

How to restore system databases on lower build

knowledge sharing : Restoring System databases on different build

Issue :

Datafiles and log files are lost on Uat server  due to OS issue
------> Sql server is down
------> All data and log files lost including system database
------> Only backups are available

What is Statistic in Sql Server Part - 1

What is Statistic in Sql Server Part - 2

What is Statistic in Sql Server Part - 3

Affects of Snapshot Isolation Level and Tempdb datafile full

Affects of Snapshot Isolation Level on Tempdb

Last weekend we face an issue where we got alert due tempdb datafile is 95.05% full, which is as usual for weekend but there is one thing unusual we found that log file was only 4 % full.

We thought there could be 2 possible reasons.

1. Sorting.  
2. Row versioning