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

SQL SERVER – Find Collation of Database and Table Column Using T-SQL

December 16, 2008

Database, SQL Collation, SQL Scripts, SQL Server Management Studio

Today we will go over very quick tip about finding out collation of database and table column. Collations specify the rules for how strings of character data are sorted and compared, based on the norms of particular languages and locales Today’s script are self explanatory so I will not explain…

SQLAuthority News – Wedding Day of Author – Photographs – Mr. and Mrs. SQLAuthority

December 15, 2008

Pinal Dave

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

Wedding

On December 12, 2008 I had posted a note on blog when I completed 800th Article on this blog. The same day was also my wedding day. Read more about the same here SQLAuthority News – Wedding Day of Author. Thank you very much for your wishes and wonderful emails.…

SQL SERVER – Email from Blog Reader – Not a Potential Bug in SQL – Puzzle

December 13, 2008

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Sub Query

Few days ago, I received wonderful email from blog reader and it was like good puzzle. I enjoyed solving this puzzle. I did not write the name of the blog reader because I am not sure if he wants his name here or not. Please read this article and run…

SQLAuthority News – Wedding Day of Author – 800th Article of Blog

December 12, 2008

Pinal Dave

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

MVP, SQLAuthority Author Visit, Wedding

Today is big day for me. I am getting married today. Wedding is just one hour away and I am writing this article. I will post more information tomorrow about this event of my life. While assigning categories to this article, I laughed when I selected “SQLAuthority Author Visit” tag.…

SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle – Solution

December 11, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

Best Practices, SQL Scripts

Yesterday we looked at Puzzle and I did got great response to this question. Very interestingly not many got it right. First go through the puzzle first and then come back here and read answer. Read Original Interview Question and Puzzle. Question: Select all the person from table PersonColor who…

SQLAuthority News – SQL SERVER 2008 Upgrade Technical Reference Guide Download

December 11, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download

Note: SQL SERVER 2008 Upgrade Technical Reference Guide Download by Microsoft This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended…

SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle

December 10, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts

In the recent time of recession my company is able to continue its progress and we are hiring. It is very surprising to me that many developers who have experience with SQL Server could not get following simple question right. There were nearly 40 candidates I interviewed but none of…