Feeds:
Posts
Comments

Archive for August, 2010

SQLAuthority News – Speaking Online at Virtual Techdays – Aug 18, 2010 – Spatial Datatypes

Posted in About Me, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Author Visit, SQLAuthority News, SQLServer, T SQL, Technology, tagged on August 17, 2010 | 6 Comments »

I am honored that I have been invited to speak at Virtual TechDays on Aug 18, 2010 by Microsoft. I will be speaking on my favorite subject of Spatial Datatypes. This exclusive Online event will have 30 deep technical sessions per day – and, attendance is completely FREE. There are dedicated tracks for Architects, Software  [...]

Read Full Post »

SQL SERVER – Finding the Occurrence of Character in String

Posted in Pinal Dave, SQL, SQL Authority, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL String, SQL Tips and Tricks, T SQL, Technology on August 16, 2010 | 12 Comments »

This article is written in response to provide hint to TSQL Beginners Challenge 14. The challenge is about counting the number of occurrences of characters in the string. Here is quick method how you can count occurrence of character in any string. Here is quick example which provides you two different details. How many times [...]

Read Full Post »

SQLAuthority News – Bookmark Link for Sync Framework for SQL Azure

Posted in SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on August 15, 2010 | 3 Comments »

I have been looking for good tutorial for Sync Framework for SQL Server. There was quite a bit demand of the product. I have received quite a few request as well. I finally found good list of the link of Sync Framework. The links are listed below. Introduction to Sync Framework Introduction to Sync Framework [...]

Read Full Post »

SQLAuthority News – Why SQL Server is better than any other RDBMS Applications?

Posted in MVP, Pinal Dave, Readers Contribution, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on August 14, 2010 | 12 Comments »

Earlier I had announced contest on blog where I gave away two MSDN Subscriptions to person who has provided best comment on the subject of “Why SQL Server is better than any other RDBMS Applications?” I have received tremendous response to the contest. I got many responses, it was extremely difficult to announce the winner [...]

Read Full Post »

SQL SERVER – Computed Column and Performance – Part 3

Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on August 13, 2010 | 3 Comments »

I am really enjoying writing about computed column and its effect in terms of performance. Before continuing this article, I suggest you read the earlier articles on the same subject to get the complete context. This is the list of the all the articles in the series of computed column. SQL SERVER – Computed Column [...]

Read Full Post »

« Newer Posts - Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 15,279 other followers