Problem: How to check whether the SQL server is configured for case sensitivity or not? Solution: Case sensitivity: By Case Sensitive, we mean[…]
Read moreAuthor: parmsingla
SQL server 2012: Kill SSIS package Execution in Integration Services catalog
Kill SSIS package in Integration Services catalog using tsql
Read moreSQL Server -Find Nth Highest Salary
Problem: Find Nth highest salary in Minimal time. Solution: Interviewer often asks to find Nth Highest Salary in an interview. Many solutions are available on[…]
Read moreSQL Server-Performance Tuning Tips
Introduction: This document list the ways of improving the performance of T-SQL. It has few tips and techniques that we used[…]
Read moreSQL Server Services installed by SQL Server 2012
List of Services Installed by SQL Server 2012 Depending on the components that you decide to install, SQL Server Setup[…]
Read moreSQL Server -Window XP useful commands for DBA
run>msinfo32 It gets the system information like OS, version name, components and many more. run>sqlservermanager11.msc Opens the SQL server configuration[…]
Read moreSQL Server -Find currently Running jobs
If you want to find the currently running jobs then following queries will help you. List All Currently Running SQL[…]
Read more
