Default Framing–Window Functions

I’ve been playing with the window functions in T-SQL a bit, and I find them very interesting. They certainly solve...

Friday Followup For November 14, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

How to replace a specific string from a large string with Write feature ? TIP #72

 
This is very interesting feature and I recently come to know this awesome feature.
Lets understand this by an example below...

Memory consideration (Windows + SQL)

We all know that with the latest Windows 2012 R2 and SQL 2014, even with the standard edition, it can...

PASS Summit 2014 Wrap Up

This past week of conferences was simply amazing. It was the best week of my career. Period. Now that I’m...

Reblog: November 7 to November 13

Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...

SSRS #75 – Use RunningValue() Function and VB Script to capture discrete dates

Drill-down report is a common design
In SSRS, it’s a common design to allow users to drill down to more granular...

Update all SSRS reports to apply consistent header / footer on demand

Teaching good old SSRS a new trick…

Background
Not too long ago I had a client with a very simple, yet practical requirement: they...

Adding a column to the primary key.

Every now and again you realize that the primary key for a table does not uniquely describe a row. Not...

Another good reason to avoid AUTO_CLOSE

Does anybody need another good reason to avoid setting AUTO_CLOSE on a database? Looks like I found one.
Some days ago, all of...