Feeds:
Posts
Comments

Archive for September, 2011

SQL SERVER – Puzzle – Usage of New Index Hints for Denali – ForceSeek and ForceScan

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 23, 2011 | 6 Comments »

Today is Friday and tomorrow is the weekend. I just thought let us explore something new but additionally give you all a quick puzzle to explore. SQL Server Denali has new Query Hint – FORCESCAN. In earlier version of SQL Server we already have Query Hint FORCESEEK but now the counter part also exists. The [...]

Read Full Post »

SQL SERVER – Learning SSAS (SQL Server Analysis Services) Online in 6 Hours – Top Down Designing and Bottom Up Designing

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL Training, T SQL, Technology, tagged on September 22, 2011 | 65 Comments »

Those who are following me on Twitter and Facebook know that recently I am reenforcing my own concept for SQL Server Analysis Services (SSAS). Like many of us, I worked with Analysis Services in early years. In an earlier job, I got many projects for relational database performance tuning and over time, I lost touch [...]

Read Full Post »

SQLAuthority News – Latest expressor Data Integration Platform Posts

Posted in PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on September 22, 2011 | Leave a Comment »

Here is the quick summary of my recent blog post which I have written while I am experimenting expressor data Integration platform. SQL SERVER – Introduction to expressor 3.4 Lookup Tables In this blog post, I am going to take a closer look at expressor’s new and extremely versatile implementation of lookup tables, which they [...]

Read Full Post »

SQL SERVER – Denali – 14 New Functions – A Quick Guide

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Function, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 21, 2011 | 8 Comments »

Last two weeks I have written various blog post on new functions introduced in SQL Server Denali. So many comments and request I have received from various readers that they would like to see everything together. I have put up a quick guide here where I am writing all the 14 new functions linking them [...]

Read Full Post »

SQL SERVER – Denali – Date and Time Functions – EOMONTH() – A Quick Introduction

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on September 20, 2011 | 8 Comments »

In SQL Server Denali, seven new datetime functions have been introduced, namely, DATEFROMPARTS (year, month, day) DATETIME2FROMPARTS (year, month, day, hour, minute, seconds, fractions, precision) DATETIMEFROMPARTS (year, month, day, hour, minute, seconds, milliseconds) DATETIMEOFFSETFROMPARTS (year, month, day, hour, minute, seconds, fractions, hour_offset, minute_offset, precision) SMALLDATETIMEFROMPARTS (year, month, day, hour, minute) TIMEFROMPARTS (hour, minute, seconds, fractions, [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers