SQL RNNR

Blog Post

Top 3 Database Life Hacks

Three very powerful but simple hacks that can give you back dozens of minutes per day.
Related Posts:

Best New(ish) SSMS Feature December 26, 2017

Puzzles and Daily Trivia May 14,...

2020-02-24 (first published: )

1,441 reads

Blog Post

Top 3 Database Life Hacks

Three very powerful but simple hacks that can give you back dozens of minutes per day.
Related Posts:

Best New(ish) SSMS Feature December 26, 2017

Puzzles and Daily Trivia May 14,...

2020-02-12

21 reads

Blog Post

Trace Query in Extended Events

The ability to quickly and easily trace a query is important to database professionals. This script provides one useful alternative to trace a specific spid similar to the method...

2020-01-28

104 reads

Blogs

A New Word: Anderance

By

anderance – n. the awareness that your partner perceives the relationship from a totally...

Troubleshooting SQL Server – Starting with the Error Log

By

We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...

From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures

By

In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...

Read the latest Blogs

Forums

Work out closing balance using opening balance of prior month

By Bhagat

Hello, I think I need a recursive cte query but unsure of the logic....

The Security of Old Tech

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Security of Old Tech

Revisiting SQL Server Window Functions- A Practical Walkthrough

By Chandan Shukla

Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...

Visit the forum

Question of the Day

Tables with a SPARSE Column and Consumption

True or False:  Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.

See possible answers