New posts in Sql Server 2014

What's the difference between WITH CTE & WITH CTE (<column_names>)?

How can SQL Delete using a sub query

Trim whitespace (spaces, tabs, newlines)

Why is my EXISTS query doing an index scan instead of an index seek?

Can SQL Server system tables be defragmented?

SQL Server using index scan instead of seek when updating a view that has an INSTEAD OF UPDATE trigger via a cursor

SQL Server changes execution plan - Part 2

Does there exist a way to determine the exact file that contains an allocation unit in a filegroup of multiple files?

Availability Group how to determine last Failover time

Maintenance Plan Wizard generates invalid script?