Browse by Tags -

Browse by Tags

SQLug.se challenge 2010 - the Swedish national championship for SQL Server developers

The Swedish national championship for SQL Server developers, SQLug.se challenge 2010 , is now finished. The competition has been running on the Swedish SQL Server User Group's website, but I publish the competition problem also on my blog in case you want to test your skills on it! The problem comes...

Posted to Johan Åhlén (Weblog) by jahlen on Mon, Dec 6 2010
Search all SPs for a string

Ever asked this question: “I wonder if we access this table from any stored procedures?”. Well here is how to find out: SELECT distinct so.name, so.xtype FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id WHERE sc.TEXT LIKE '%TABLE/COLUMN/string%' Nice! So now you can search all the...

Posted to Mikael Sand - Trying to be different (Weblog) by Mikael Sand on Tue, Nov 16 2010
Minesweeper in T-SQL

Who said that coding T-SQL should not be fun? Minesweeper is a real old classic (that's still being shipped with Windows). Truly creative of Auke Teeninga to implement Minesweeper in T-SQL... Keep on playing!

Posted to Johan Åhlén (Weblog) by jahlen on Sun, Sep 5 2010
Try your SQL optimizing skills and win great honor

As winner of the previous round, I’ve been given the honor to write the problem for Phil Factor Speed Phreak Challenge #6. This problem is from the real world (algorithmic trading) and the sample data is real. The challenge is to reproduce highest buy and lowest sell prices from data captured from a...

Posted to Johan Åhlén (Weblog) by jahlen on Mon, Aug 16 2010
Exploring SQL Server under the hood using undocumented DBCC commands

Have you ever wanted to see the details on how data is organised in a SQL Server database? Exactly how tables, indexes, blogs, etc are stored. How SQL Server can find a specific row in a table. This is possible through two undocumented DBCC commands: DBCC IND and DBCC PAGE. Here's a description of...

Posted to Johan Åhlén (Weblog) by jahlen on Sun, Aug 15 2010
Performance optimization - T-SQL, SSIS, SQL CLR, etc what is fastest?

Ever wondered what is the fastest technology for your queries? One way to find out is to let a couple of SQL Server optimization freaks compete who can write the fastest solution. This is what the Phil Factor SQL Speed Phreak Competition is about. Below is the results of round 5 of the competition, the...

Posted to Johan Åhlén (Weblog) by jahlen on Mon, May 31 2010
InstantCube - building a SQL Server Modeling DSL application for quick cube development

Introduction This article describes how to build a tool , InstantCube, that uses SQL Server Modeling Services that drastically reduces the development time of simple Analysis Services cubes. Using the tool you can accomplish with a few lines of DSL (Domain Specific Language) what would take many times...

Posted to Johan Åhlén (Weblog) by jahlen on Tue, Nov 17 2009
Article published on SQLServerCentral.com

Welcome to read my article, Improving Cube Performance with Precalculated Aggregations , on SQLServerCentral.com. http://www.sqlservercentral.com/articles/SSAS/68309/ More articles will be coming when I have the time to write.

Posted to Johan Åhlén (Weblog) by jahlen on Fri, Nov 6 2009
Unleashing the power of SQL Server ENTERPRISE EDITION - Part 1

Background Having seen a number of MS SQL Server Business Intelligence implementations, I have noticed that surprisingly few consultants know the difference between SQL Server Enterprise Edition and SQL Server Standard Edition, and even fewer use the Enterprise Edition features. I think this may be partly...

Posted to Johan Åhlén (Weblog) by jahlen on Wed, Sep 16 2009
T-SQL is mean, there is no median

SQL-Server and I has had a bit of a fallout. I don't talk to it and it doesn't talk to me. A shame really since we used to be very close back in 2001. Today we once again stood face to face. I said: "Oh, you look good. You have changed, and I like it. It looks nice on you." The reason...

Posted to Mikael Sand - Trying to be different (Weblog) by Mikael Sand on Fri, Jul 24 2009

Page 1 of 1 (10 items)