Create Column store index in SQL Server 2012 : Demo

Errors With Column Store Index in SQL Server 2012: DEMO

Errors With Column Store Index in SQL Server

The Service Was Unable To Log On As With The Currently Configured Password Due To The Following Error ,Logon failure: The User Has Not Been Granted The Requested Logon Type At This Computer

How To Enable \ Disable Firewall in Windows 2012 : Demo

How To Check If SQL Server Is Not Able To Connect Due To Firewall In Windows 2012

Database Is Offline With Single User Mode (Hidden Negative SPID)

How To Connect SQL Server 2014 PDW, Connection Guide

Generate Script To Migrate sp_configure Settings In SQL Server

MSSQL_ENG003165: Database was restored, however an error was encountered while replication was being restored/removed. The database has been left offline.

Pre-Requisites For Sql Server 2012 / 2014 Installation

Difference Between SQL Server 2008 and SQL Server 2012

How To Refresh DQS (Data Quality Services) Databases in SQL Server : Demo

How To Fix Orphan User For All Databases in SQL Server

How To Find Version of Double-Take From Registry Using SQL Query

Locking And Head Blocker Scenario In SQL Server : Demo

Auto Headers In SQL Server Query Analyzer in SQL 2016,SQL 2014 , SQL 2012 , SQL 2008

Why SQL Server Database Need Log File ?

Not Able To Start SQL Server Reporting Services

SQL Server Replication: Subscriber Is Not Visible In Subscriber List

Replication Error: “Login failed for user 'user account'. Reason: Attempting to use an NT account name with SQL Server Authentication.”

Script To Find Space Used By All Tables In Sql Server

What is MPP ( Massive Parallel Processor )

What Is The Difference Between SMP and MPP

Replication Snapshot Fail “Microsoft.SqlServer.Management.Smo.FailedOperationException Exception”

How To Find "Last Checkdb Run For All Databases" in SQL server

A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated

What is Read- Ahead in SQL Server??

What Is “Merry-go-round scan” In SQL Server Enterprise Edition??

What Is Eager Writing in SQL Server?

What do you mean by "Minimally Logged" in bulk recovery model?

How To Recycle Logs Of SQL Server \ Agent \ Default Trace \ Full Text Search \ Full-Text Filter Daemon:

Script To Generate Server level Permissions in SQL Server

Script To Generate Server level Permissions in SQL Server

Facts About Enabling / Disabling Indexes in Sql Server

How To Disable - Enable Indexes In SQL Server

Find SQL Server Details Using Query Analyzer

How To Explicitly Connect SQL Server Using Specific ( Named Pipes / TCP / Shared Memory ) Protocol : Interview Question

What is Statistic in Sql Server Part - 3

 Yes ! Auto update stats causing Performance issues??

What is Statistic in Sql Server Part - 1

What is Statistic in Sql Server Part - 2

What is Statistic in Sql Server Part - 2

Interview Question : Does sp_updatestats update the statistics of a table if I just run it or does it use specific formula??

What is Statistic in Sql Server Part - 1

What is Statistic in Sql Server Part - 3

How To Change SQL Server Port In SQL Cluster : Demo

How To Change Sql Server Service Account In Sql Cluster : Demo

An error occurred during the execution of xp_cmdshell. A call to ‘LogonUserW’ failed with error code : ‘1385’.

How To Shrink All database Log Files Together

How To view Registered SPN (Existing Service Principal Name )

How To Set SPN ( Service Principal Name ) : Demo

Procedure has no Parameters and Arguments were Supplied.

Sql Server Configuration Manager Remote Procedure Call Failed (0x800706be)

SQL Server Installation Add Features is not Showing All Instances

Today we get a request to install SQL server reporting services for 4 of 8 of the instances on a server.
As usual we pick our sql 2012 dump and start installing. When we reached to Add feature page of installation we were not able to see 4 of 8 instances in drop down as in screen shot

Difference Between varchar(max) and varchar(8000)

Script for Multiple Restore in one shot SQL server

Windows update can't check for updates because the service is not running

Patching does have its own issues, hard to predict

 This time I was doing windows updates

Control panel --> System and security --> Windows update -->check for updates

The image file is valid , but is for a machine type other than the current machine

While patching SQL server 2005 SP1 to SP2, we face below error

Error: The image file is valid , but is for a machine type other than the current machine

This error clearly states that patch file is good, the issue  is with my machines

SQL Server System Databases

 Many people does know about system databases but no one remembers detailed version and get confuse in tricky questions. So I have put this in points

Master Database :

1. 
   

Script To Reindex Database In Sql Server

A file activation error occurred. The physical file name may be incorrect.

Copy all files from one drive to other via SQL Server Script xp_cmdshell

Copy all files from one drive to other via SQL Server Script using Robocopy

SQL Server ACID Properties

Difference Between Mutex vs Semaphore

SQL Server Full Job History

EXECUTE permission was denied on the object ‘xp_cmdshell’, database ‘mssqlsystemresource’, schema ‘sys’

Replication Doubts:

The list of trace flags available for SQL Server

How To Increase Performance Of Slow Insert In SQL Server

Restore Latest Backup in SQL Server

How do list files ,date and size inside a folder using SQL Server

How to delete Transaction log file in SQL server : Demo

How To Read Default Trace In Sql Server

SQL Script To Get Available And Free Disk Space From SQL Server

Cannot create a row of size XXXX which is greater than the allowable maximum row size of 8060

When dbcc checkdb last run OR Frequency of checkdb

Currently Running Queries on SQL Server

Check database size and free space in SQL Server

Difference Between Index Seek vs Index Scan

'Cannot execute as the database principal because the principal "##MS_PolicyEventProcessingLogin##" does not exist

Sql Server Transaction Log File Is Not Shrinking

How To Find Windows Version Using Registry and SQL Query

How To Enable Deadlock Trace in Sql Server

How to get list of databases from multiple servers using Powershell script

Cannot use special principal dbo

Error: Cannot use special principal dbo: Error 15405

Script to find sql server version on multiple instances using Power shell

Script to find sql server version on multiple instances using Power shell

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