SQL Archives - Page 430 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Introduction and Example of UNION and UNION ALL

October 15, 2008

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

SQL Joins, SQL Scripts, SQL Union clause

It is very much interesting when I get request from blog reader to re-write my previous articles. I have received few request to rewrite my article SQL SERVER – Union vs. Union All – Which is better for performance? wi.th examples. I request you to read my previous article first…

SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only

October 14, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

SQL is great with String operations. Many times, I use T-SQL to do my string operation. Let us see User Defined Function, which I wrote few days ago, which will return only Numeric values from AlphaNumeric values. CREATE FUNCTION dbo.udf_GetNumeric (@strAlphaNumeric VARCHAR(256)) RETURNS VARCHAR(256) AS BEGIN DECLARE @intAlpha INT SET @intAlpha =…

SQLAuthority News – Book Review – Pro SQL Server 2005 Replication (Definitive Guide)

October 13, 2008

Pinal Dave

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

Database, DBA, SQL Backup and Restore, SQL Data Storage, SQL Replication, SQLAuthority Book Review

Pro SQL Server 2005 Replication (Definitive Guide) (Hardcover) by Sujoy Paul (Author) Link to Amazon Quick Review: This is good book for any novice developer to start in the world of database replication implementation and maintenance. Replication is important part of highly availability and one book covers all the concept…

SQLAuthority News – Download – Microsoft SQL Server 2008 Feature Pack, August 2008

October 11, 2008

Pinal Dave

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

SQL Download, SQL Utility

Download the 2008 Feature Pack for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008. The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of: Redistributable components…

SQL SERVER – 2008 – Enhenced TRIM() Function – Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds

October 10, 2008

Pinal Dave

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

SQL Function, SQL Scripts, SQL String, SQL Utility

After reading my article SQL SERVER – 2008 – TRIM() Function – User Defined Function, I have received email and comments where user are asking if it is possible to remove trailing spaces, leading spaces, white space, tabs, carriage returns, line feeds etc. I found following script posted by Russ…

SQL SERVER – 2008 – TRIM() Function – User Defined Function

October 9, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

I just received following question in email by James Louren. “How come SQL Server 2000, 2005 does not have function TRIM()? Is there any way to get similar results. What about SQL Server 2008?” James has asked very interesting question. I have previously wrote about SQL SERVER – TRIM() Function…

SQLAuthority News – SQL Server 2008 – Microsoft Certifications for 70-432 70-433 70-450 70-452

October 8, 2008

Pinal Dave

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

Database, Microsoft Certifications, Software Development

I have received many emails requesting information about SQL Server certifications examples. Microsoft has released new set of exams for SQL Server 2008 certifications. I am listing them here for quick reference. Exam 70-432 – TS: Microsoft SQL Server 2008, Implementation and Maintenance Installing and Configuring SQL Server 2008 (10…