Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – UNPIVOT Table Example

May 29, 2008

PIVOT, SQL Function, SQL Scripts, UNPIVOT

My previous article SQL SERVER – PIVOT Table Example encouraged few of my readers to ask me question about UNPIVOT table. UNPIVOT table is reverse of PIVOT Table. USE AdventureWorks GO CREATE TABLE #Pvt ([CA] INT NOT NULL, [AZ] INT NOT NULL, [TX] INT NOT NULL); INSERT INTO #Pvt ([CA],…

SQLAuthority News – Download – Windows Server 2008 w/ SQL Server 2005

May 28, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Download

Note: Download Here by Microsoft This download comes as a pre-configured VHD. This download enables testing of application designs on the Windows Server Platform. As design gets more closely integrated into the process of building websites and web applications it becomes more critical to have all the necessary software installed…

SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 3

May 27, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

Datetime functions and stored procedures always interests me. Nanda Kumar has suggested modification to previous written article about SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 2. He has improved on UDF. CREATE FUNCTION dbo.udf_DayOfWeek(@dtDate DATETIME) RETURNS VARCHAR(10) AS BEGIN DECLARE…

SQLAuthority News – SQL SERVER 2008 – New Logo

May 26, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA

Microsoft SQL Server 2008 has new logo. I really liked the new design. Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – T-SQL Script to Devide One Column into Two Column

May 25, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Just a day ago, we faced situation where one column in database contained two values which were separated by comma. We wanted to separate this two values in their own columns. It was interesting that value of the column was variable and something dynamic needed to be written. Following is…

SQL Authority News – SQL Server Interview Questions – SQL Related Jobs – DBA Job Description

May 24, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, SQL Jobs

I like to help every candidate who are finding job. I have previously written article here which can help all the people who are looking for job or looking for candidates. SQL Server Interview Questions and Answers Complete List Download Find Job Related to SQL SERVER SQL Server DBA- Job…

SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 2

May 23, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

I have written article about SQL SERVER – UDF – Get the Day of the Week Function. I have received good modified script from reader Mihir Popat has suggested another code where Sunday does not have to be necessary the first day of the week. CREATE FUNCTION dbo.udf_DayOfWeek(@dtDate DATETIME) RETURNS…