Fun with OVER

SQL Battleship

It's you versus the computer in the classic game of Battleship, completely playable from the SQL Server Management Studio interface!

Review Your BUCKET_COUNT Statistics with DMV

Greg Larsen discusses the BUCKET_COUNT setting of a HASH index and how to determine how well SQL Server distributes the In-Memory table rows across multiple buckets of a HASH index, by exploring a new DMV, provided with SQL Server 2014, along with the In-Memory OLTP table functionality.

Function to count set bits in a signed integer

This function counts the number of 1's in the binary representation of an integer.

Find Top 5 executed queries ordered by execution count

I wrote this query that helps us find executed queries with most number of execution counts. The DMV that we have used in this script is sys.dm_exec_query_stats and the function that we have used is sys.dm_exec_sql_text.

Developing a Report Definition Customization Extension for Multi-Language Reports

When you need to present the same SQL Server Reporting Services (SSRS) report in eight or more different languages, or in different formats for different recipients, and the boss demands last-minute changes, it suddenly makes sense to use the Report Definition Customisation Extension (RDCE) .NET class library to create the final reports automatically. But how?

Universal Product Codes: a Database Primer

An introduction to Universal Product Codes with code to help you use them in your database.

Designing Databases for Rapid Resilience

As the volume of data increases, DBAs need to plan more actively for rapid restores in the event of failure. For this, the intelligent use of filegroups is important, particularly when the Enterprise Edition of SQL Server offers the hope of online restores. How, though, should you arrange your data on the different filegroups? What happenens if the primary filegroup gets corrupted? Why backup and restore indexes?

New feature in SQL Server 2012 - Sequence

A new feature in SQL Server 2012 is Sequence. A Sequence object provides functionality similar to Identity.

Check connect to all linkeds

This script checks all links on the server