It should be easy to model a game of poker in SQL. The problem is, however, that you need to model a permutation from a set of elements. Joe Celko argues that using a group of columns to do this isn't necessarily a violation of 1NF, since a permutation is atomic. Then comes the second problem: how would you sort such a column-base permutation in order? Sorting columns in SQL?
2013-01-04
4,573 reads
Partitioning has improved with each new version of SQL Server. From partitioned views in SQL Server 7.0 through partition table parallelism in SQL Server 2008. With SQL Server 2012, we are now allowed to even create up to a 15K partition on a single table.
2013-01-03
4,975 reads
Often times we are tasked with having to programmatically come with a list of durations per SQL Server Agent Job to trend the run times and order the results by date. Unfortunately it's not always easy in the way the data is stored in the system tables in the MSDB database. This tip explains how to use the system tables to get the data into the correct format for dates and job durations.
2013-01-02
3,890 reads
This article will show you how to automatically generate insert, update, and delete procedures for tables in your database
2013-01-01 (first published: 2011-02-10)
30,490 reads
The Performance Analysis of Logs tool is a general tool for collecting and analysing log data. With the addition of a template, it becomes an effective way of analysing data from performance counters for SQL Server, in order to diagnose performance problems and capture baseline information.
2013-01-01
5,629 reads
How can you copy dimensions from one SQL Server Analysis Services (SSAS) Project to another? Are there any options to do so? This tip outlines three approaches for SQL Server BI Professionals who need to copy dimensions from one SSAS project to another.
2012-12-31
2,893 reads
The Tally Table has proven to be a simple and elegant method for avoiding many varieties of RBAR. Unfortunately, one of its more common uses, that of a CSV splitter, has a well-known and serious performance problem. MVP Jeff Moden shows us what that problem is and how to correct it. (UPDATED with additional info and attachments on 5/12/2011).
2012-12-28 (first published: 2011-05-02)
141,980 reads
The "index create memory" option in sp_configure advance server settings, controls the maximum amount of memory initially allocated for creating indexes. This tip deals with common issues around this setting.
2012-12-28
3,267 reads
2012-12-28
321 reads
Here's a great method for managing ETL for data marts and small data warehouses with just T-SQL.
2012-12-27
5,012 reads
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers