SQL Tips and Tricks Archives - Page 246 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Removing Leading Zeros From Column in Table – Part 2

November 22, 2012

Earlier I wrote a blog post about Remvoing Leading Zeros from Column In Table. It was a great co-incident that my friend Madhivanan (no need of introduction for him) also post a similar article over on BeyondRelational.com. I strongly suggest to read his blog as well as he has suggested…

SQL SERVER – Using RAND() in User Defined Functions (UDF)

November 20, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

Here is the question I received in email.
“Pinal,
I am writing a function where we need to generate random password. While writing T-SQL I faced following issue. Everytime I tried to use RAND() function in my User Defined Function I am getting following error:

SQL SERVER – Removing Leading Zeros From Column in Table

November 19, 2012

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

Some questions surprises me and make me write code which I have never explored before. Today was similar experience as well. I have always received the question regarding how to reserve leading zeroes in SQL Server while displaying them on the SSMS or another application. I have written articles on this subject over here about leading zeros.

SQLAuthority News – Microsoft SQL Server 2012 Service Pack 1 Released (SP1)

November 18, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download, SQL Service Pack

Last week, I was attending SQLPASS 2012 and I had great fun attending the event. During the event long awaited SQL Serer 2012 Service Pack 1 was released. I am pretty excited with SP1 as new service packs are cumulative updates and upgrade all editions and service levels of SQL…

SQL SERVER – Retrieving Random Rows from Table Using NEWID()

November 16, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

I have previously written about how to get random rows from SQL Server. SQL SERVER – Generate A Single Random Number for Range of Rows of Any Table – Very interesting Question from Reader SQL SERVER – Random Number Generator Script – SQL Query However, I have not blogged about following trick…

SQL SERVER – Concurrency Basics – Guest Post by Vinod Kumar

November 15, 2012

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

This guest post is by Vinod Kumar. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Working on various versions from SQL Server 7.0, Oracle 7.3 and other database technologies – he now works with the Microsoft Technology Center (MTC) as a Technology Architect.…

SQLAuthority News – Happy Deepavali and Happy New Year

November 13, 2012

Pinal Dave

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

Diwali or Deepavali is popularly known as the festival of lights. It literally means “array of light” or “row of lamps“. Today we build a small clay maps and fill it with oil and light it up. The significance of lighting the lamp is the triumph of good over evil. I work…