Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "Data Modelling and Design"

2

Find all the tables and indexes that have data compression

I took a backup of one of our test databases today and gave it to someone so that it could be restored on one of their servers.

I got back the following in an email from the person who tried to do the restore

Date 11/16/20…

Read More...
0

SQL Server 2012 SP1 and in-memory OLTP DB Engine Hekaton announced

Microsoft announced a couple of things at the PASS conference today

SQL Server 2012 Service Pack 1 is now available for download, you can get it here: http://www.microsoft.com/en-us/download/details.aspx?id=35575

Just two of the new features avail…

Read More...
2

Plan Explorer Pro – First Glance

Over these past few days, I’ve had a chance to check out the new release of Plan Explorer Pro from SQL Sentry.  I’d like to thank them again, for giving me the chance to dig into this new edition and make full use of the additional features it has to of…

Read More...
1

Why do you need additional privileges for truncate table compared to delete?

One of the people on my team wants to have the ability to truncate tables on the staging database while this person is testing, why are special permissions required compared to a delete?

Read More...
4

Calculating Week-To-Date values using DAX

The expression language of Tabular Mode SSAS – DAX – provides several great time intelligence functions.  One of those it does not provide though a composite function – like DATESMTD or DATESQTD – is one to calculate Week-To-Date summations.  To calcula…

Read More...
0

Surrogate Keys Bite Back

Not too long ago I got a work order in that was requesting help with removing duplicate records out of a report. This report, and the database it was built upon, was built solely by a co-worker that left two years ago. This report just displayed a lis…

Read More...
0

SQL Server 2008 R2 SP2 Released

SQL Server 2008 R2 Service Pack 2 (SP2) has been released. Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center

Download SQL Server 2008 R2 SP2

Download SQL Server 2008 R2 SP2 Express

Down…

Read More...
2

SQL Saturday #126 (Indy) – Tabular Mode SSAS

SQL Saturday #126 is ALMOST HERE!  I’ve been looking forward to this event for a long time, and I’m excited to be selected as a presenter.
Join me this Saturday, 7/28/2012, in Indianapolis, IN for an introduction to Tabular Mode SSAS in SQL 2012.  We’l…

Read More...
2

“Connect” an Excel 2010 Slicer to an unrelated object.

Slicers are super cool!  By extending the power of filtering to apply to multiple PivotTables (or PivotCharts) they have really increas ed the reporting and data delivery power of Excel 2010.  Not only do they look cool and are fun to interact with, the…

Read More...
0

How to create a simple cross tab report in Reporting Services 2008

I have created several cross tab reports in the last few years. I have also seen several hacks with different ways to achieve what is actually already built into Reporting Services. To begin, let’s define what a cross tab report is.

According to…

Read More...
« Previous PageNext Page »