T-SQL.dk

A blog on code, coffee & curiosities

Search
  • About
  • Contact
  • Engagements
    • Delivering BI Continuously
  • Volunteering
Skip to content

Tag: T-SQL

Programming

How to generate the alphabet from ASCII codes in T-SQL

Jens Vestergaard19/02/2014 Leave a comment

Just now I had the requirement to create a loop in SSIS, and have that loop the alphabet. In order to facilitate that, I generated a T-SQL statement, that provides the alphabet including the Danish Æ, Ø and Å. If you don’t need these, you can leave out the latter part of the last where […]

Read the article
Programming

Using a Custom Assembly to search an Analysis Services dimension

Jens Vestergaard19/06/201220/06/2012 4 Comments

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 wanted to be able to search by first name, last name, age, social security number […]

Read the article
Programming

Quick-tip: Default column type in SSMS

Jens Vestergaard24/09/2011 Leave a comment

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.

Read the article
Programming

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

Jens Vestergaard24/09/201124/09/2011 Leave a comment

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 10M fact rows and preferably at least one dimension with approximately 1M members. One approach […]

Read the article
Programming

Renaming the name of the physical database and log file

Jens Vestergaard10/08/201110/08/2011 Leave a comment

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 test (import 5.5 mio facts + 250K dimension elements into a dw model) rename the […]

Read the article

Posts navigation

  • 1
  • 2
  • 3

Categories

  • Coffee (9)
  • Community (56)
  • Entry Level (12)
  • Family (3)
  • Mixed (50)
  • Music (5)
  • Personal (4)
  • Programming (179)
  • Roleplay (6)
  • The Who (3)
  • tsql2sday (13)

Tags

.Net Analysis Services azure BI Business Intelligence C# Coffee Community D&D entrylevel Espresso FAIL Fejl Humor iot IWantToShare MCP MDX MsBIP MSConnect NFL Personal PowerBI Powershell Security Speaking SQL SQL2012 sqlfamily SQLPASS sqlsaturday SQLServer SQL Server SQL Server 2008 SQLTip SSAS SSIS SSIS 2008 SSMS SSRS T-SQL Teradata TSQL2SDAY VS2008 VS2010

LinkedIn

I am happy to connect on LinkedIn:

Jens Vestergaard

Subscribe

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Categories

  • Coffee
  • Community
  • Entry Level
  • Family
  • Mixed
  • Music
  • Personal
  • Programming
  • Roleplay
  • The Who
  • tsql2sday

Archives

LinkedIn

I am happy to connect on LinkedIn:

Jens Vestergaard

Social

  • View vestergaardj’s profile on Twitter
  • View vestergaard_jens’s profile on Instagram
  • View jvestergaard’s profile on LinkedIn
Theme: Ameno by BG Web Agency
rename_database_physical_files.sql