Tag Archives: T-SQL

Using a Custom Assembly to search an Analysis Services dimension

Posted on 19/06/2012 by Jens Vestergaard
Share

Problem A client of ours had the business requirement that they wanted to be able to search for members in certain dimensions in their cube. In particular two specific dimensions, patients and health care persons (doctors, dentists, nurses etc.). And they … Continue reading →

Posted in Programming | Tagged , , | 2 Comments

Quick-tip: Default column type in SSMS

Posted on 24/09/2011 by Jens Vestergaard
Share

Looking for some other settings I stumbled upon this very nice, and very hidden, feature in SQL Server Management Studio (SSMS): The ability to set your default column type! That should save me a lot of time, from now on.

Posted in Programming | Tagged , , | Leave a comment

Selecting an arbitrary number of random rows from a table with T-SQL

Posted on 24/09/2011 by Jens Vestergaard
Share

While searching for a fairly large dataset to use for performance baselining, I was looking at the option of duplicating data in the Adventure Works database to match our needs. In order to check for weak spots, I need at least … Continue reading →

Posted in Programming | Tagged , | Leave a comment

Renaming the name of the physical database and log file

Posted on 10/08/2011 by Jens Vestergaard
Share

During one of my current tasks, which was to run the same test on multiple copies of the same database, I needed to setup a flow where I could deploy the database from VS2010 or setup database w/ vsdbcmd run the … Continue reading →

Posted in Programming | Tagged , , , | Leave a comment

Restored database konflikter med et opdaterings deploy fra VS DB Ed.

Posted on 05/12/2009 by Jens Vestergaard
Share

Jeg løb ind i et lidt filøjerligt issue her til aftens da jeg skulle lave et opdateringsdeploy fra VS ud til min dev instans af en database. Jeg havde modtaget en backup fra en kollega, der indeholdt en masse testdata, … Continue reading →

Posted in Programming | Tagged , , | 1 Comment