New posts in Sql Server 2014

Matching a ] (closing square bracket) with PATINDEX using the "[ ]" wildcard

Rebuild Index not freeing up space

Alternatives to running query for rarely changed data everytime on large table

Database level lock

sys.objects column [Type] weird value 'ST'

Locate the smallest missing element based on a specific formula

How to Dynamically change the database using TSQL

Self-join on primary key

Detaching a database permanently

How to change job output log location, when using Ola Hallengren's scripts