SQL Server 2005 Diagnostic Information Queries (June 2012)

Here is the latest version of my SQL Server 2005 Diagnostic Information Queries, with some minor tweaks and improvements, including...

T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore

T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore

This blog entry is participating in T-SQL Tuesday #31, hosted this month...

T-SQL Tuesday #31 – Logging

This month’s T-SQL Tuesday is hosted by Aaron Nelson (@SQLvariant | Blog). The topic is about logging. Many will talk about...

T-SQL Tuesday #31 – Logging

It’s T-SQL Tuesday time again, and this month Aaron Nelson (blog | @sqlvariant) is hosting. The topic is logging, and if...

Using PowerPivot to Monitor Reporting Services

PowerPivot is a powerful new tool from Microsoft that has been improved even more in the 2012 release, which you...

Creating a Filetable

How do you create a filetable? I assume you’ve enabled Filestream and created a filegroup for your filestream and filetable...

ORM Tools

ORM tools. They’re great. They’re evil.
In the right hands, used the proper way, they can be a very powerful, very...

Performance reviews – Self-evaluations

My annual performance review at work is coming up shortly, and this year they’ve decided to do things a bit...

RANKING Function in plain SQL

Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using...

RANKING Function in plain SQL

Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using RANK() function.DECLARE @StudentScore TABLE(StudentName VARCHAR(1),StudentScore INT)INSERT  @StudentScore VALUES ('A',85),...