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

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

August 17, 2010

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

Spatial Database, SQLAuthority Author Visit

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…

SQL SERVER – Finding the Occurrence of Character in String

August 16, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

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…

SQLAuthority News – Bookmark Link for Sync Framework for SQL Azure

August 15, 2010

Pinal Dave

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

SQL Documentation, SQL Download

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…

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

August 14, 2010

Pinal Dave

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

MVP

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…

SQL SERVER – Computed Column and Performance – Part 3

August 13, 2010

Pinal Dave

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

SQL Index, SQL Scripts

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 – SHRINKDATABASE For Every Database in the SQL Server

August 12, 2010

Pinal Dave

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

DBA, SQL Scripts

I was recently called to attend the Query Tuning Project. I had a very interesting experience in this event. I would like to share to you what actually happened. Note: If you are just going to say that shrinking database is bad, I agree with you and that is the…

SQLAuthority News – MSDN Subscription Giveaway Announced

August 11, 2010

Pinal Dave

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

MVP

Last Month received following “NOT FOR SALE” subscription of Microsoft Visual Studio 2010 Ultimate with MSDN. As a MVP, MCT I already have free subscription to MSDN and TechNet. I plan to give away this free subscription to someone who is need of the same or can use it the…