Create EndPoint

Server principal 'xx\yy' has granted one or more permission(s). Revoke the permission(s) before dropping the server principal. (Microsoft SQL Server, Error: 15173). If you are gett

Work time calculation

One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time

Simple Object and String Search within Objects

This Simple script will help to do a Server wide search for an object name or usage of a String in Object Code like Function, Procedure, Views

Romanian Number Humanizer in SQL Server

Romanian Number Humanizer

Quick check server space and DB size

Script to quickly check the drive space utilization.

Querying deadlock graph from SQL Extended Events

Sample script to read deadlock graph XML from default system health XEvent.

Checking All Date Columns in a Table(s)

Find minimum and maximum values for all date columns in a table or range of tables, using a mask.

Split string using multiple delimiters - version 2

http://www.sqlservercentral.com/scripts/split+string/117123/

The above script will split upto 256 char length only. This new version will split upto N length.

Calculate distance between 2 coordinates/latlong

This function is used to get the distance between 2 coordinates/latlong in the different formats

Read all trace file data and print the action performed

If you want to read trace file records from default trace location and want to print to see what are all the activities happened on SQL Server, the query will be helpful for you.