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

SQL SERVER – Parallelism Query in Database

August 6, 2010

I recently came across two interesting questions asked by Feodor over here. He has asked very interesting questions. Please check them as follows: If I have a dual core computer and I would like to get a query executed with parallelism in order to test it, how would I do…

SQLAuthority News – SQL Data Camp, Chennai, July 17, 2010 – A Huge Success

August 5, 2010

Pinal Dave

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

MVP, Spatial Database, SQL Index, SQLAuthority Author Visit

I had great pleasure to attend very first SQL Data Camp at Chennai on July 17, 2010. This event was very unique as this was very first one-day SQL Event in whole Indian Subcontinent. The event was blast as there were so many back–to-back SQL Sessions with SQL Server MVPs.…

SQL SERVER – Computed Column – PERSISTED and Performance – Part 2

August 4, 2010

Pinal Dave

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

SQL Scripts

This is the third article in the series which I am writing on Persisted Columns. I suggest you read following two article first before continuing on this article. This is the list of the all the articles in the series of computed column. SQL SERVER – Computed Column – PERSISTED…

SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example

August 1, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Function, SQL Scripts

In one of the recent consultancy, I was asked if I can give working example of BINARY_CHECKSUM. This is usually used to detect changes in a row. If any row has any value changed, this function can be used to figure out if the values are changed in the rows.…

SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts

July 31, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

This month was very interesting month for me. I visited 2 different countries – Malaysia and Sri Lanka. I had great time attending 3 community sessions – Chennai, Kuala Lumpur and Ahmedabad. Though, I was at home only 5 nights, I was fortunate enough to spend good amount of the…