SQL Server 2005 Derived Tables, Common Table Expressions and Indexed Views Query Processing Part II

I have now started the process of evaluating the other possible ways of executing the query. These include using a derived table, Common Table Expression and an Indexed View. My intent is to not use any functions that could twist my results. Below is the script that I used and the result.   SELECT ID,MonthPart,YearPart FROM…

3

Visual Studio Team Edition for Database Professionals.

Today we anounced Visual Studio 2005 Team Edition for Database Professionals “Visual Studio Team Edition for Database Professionals delivers a market-shifting database development product designed to manage database change, improve software quality through database testing and bring the benefits of Visual Studio Team System and life cycle development to the database professional.” This is a…

3

technologeist

tech·nol·o·geist [ tek nólləgst ] (plural tech·nol·o·geists) noun   Definition: 1. method of applying technical knowledge: a method or methodology that applies technical knowledge or tools by a supposed supernatural being. [Early 21st century. < English technogeek “techology focused” < tekhnē “art, skill, super human” ]  tech·no·log·geek [ tèknə lójgeek ]adj

0

Why am I Intellectually Constipated?

Even though it is a great time to be a technologeist, this list is the reason why I am IC, with no cure or remedy in site. 1. Windows Vista Beta 2. Speech Server 2007 Beta3. Commerce Server 2007 Beta4. Exchange Server 12 Beta5. Microsoft Windows Compute Cluster Server 2003 Beta6. Office 12 Beta7. Systems…

0

Windows Vista Beta 2 – HUH?

After getting a taste of the things to come in Windows Vista, by loading IE7 and the new Windows Media Player 11, I took the leap and rebuilt my laptop with the 5381 Beta 2 build. I was a little worried that I was going to have to ghost my machine back to XP, but after…

1

Colorado PASS Camp 2006 – SQL Server Technology Summit

First I want to thank everyone who attended the Colorado PASS Camp 2006 in Denver and my session this week. After we got past the technical issues, it was fast a furious as I tried to get to everything I wanted to show. Here is the link to the lab I presented and the PowerPoint…

0

Waht deos it maen to be ilcelnteltulay cpnsttiaeod?

    Cdnuolt blveiee taht I cluod aulaclty uesdnatnrd waht I was rdanieg.The phaonmneal pweor of the hmuan mnid, aoccdrnig to a rscheearch atCmabrigde Uinervtisy, it deosn’t mttaer in waht oredr the ltteers in awrod are, the olny iprmoatnt tihng is taht the frist and lsat ltteer bein the rghit pclae. The rset can be a…

2