August « 2010 « SQL Server Journey with SQL Authority

Archive for August, 2010

SQL SERVER – Computed Columns – Index and Performance

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 22, 2010 | 2 Comments »

This is the last article in the series of the computed columns I have been writing. Here are previous articles. SQL SERVER – Computed Column – PERSISTED and Storage This article talks about how computed columns are created and why they take more storage space than before. SQL SERVER – Computed Column – PERSISTED and [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Optimization, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on August 21, 2010 | Leave a Comment »

I am really enjoying writing about computed column and its effect in terms of storage. Before I go on with this topic, I suggest you read the earlier articles about computed column to get the complete context. This is the list of the all the articles in the series of computed column. SQL SERVER – [...]

Read Full Post »

SQL SERVER – Function to Retrieve First Word of Sentence – String Operation

Posted in SQL, SQL Authority, SQL Function, SQL Query, SQL Server, SQL String, SQL Tips and Tricks, T SQL, Technology on August 20, 2010 | 7 Comments »

I have sent of function library where I store all the UDF I have ever written. Recently I received email from my friend requesting if I have UDF which manipulate string and returns only very first word of the statement. Well, I realize that I do not have such a script at all. I found [...]

Read Full Post »

SQL SERVER – Negative Identity Seed Value and Negative Increment Interval

Posted in Pinal Dave, SQL, SQL Authority, SQL Function, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged Identity on August 19, 2010 | 19 Comments »

I just had interesting conversation with one of my friend who said identity value can not start from Zero. I told him that it can even start from negative value. He did not believe it. I quickly come with example and he was surprised to see it. USE [AdventureWorks] GO IF EXISTS (SELECT * FROM [...]

Read Full Post »

SQL SERVER – Download SQL Server 2008 Interview Questions and Answers Complete List

Posted in Pinal Dave, SQL, SQL Authority, SQL Interview Questions and Answers, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLServer, T SQL, Technology on August 18, 2010 | 13 Comments »

I was getting many request to update SQL Server Interview Questions and Answers I had written couple of years ago. I have modified the original document a bit and corrected few of the typos and errors. I have really enjoyed going over all the Interview Questions and Answers. It has been the most popular subject [...]

Read Full Post »

« Newer Posts - Older Posts »