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

SQLAuthority News – Download Microsoft SQL Server 2005 Service Pack 3

December 18, 2008

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

Database, SQL Download, SQL Service Pack

Service Pack 3 for Microsoft SQL Server 2005 is now available. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP3. You can use these packages to upgrade any of the following SQL Server 2005 editions: Enterprise Enterprise Evaluation…

SQL SERVER – Interesting Interview Questions – Revisited

December 17, 2008

Pinal Dave

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

Best Practices, Software Development, SQL Scripts

I really enjoyed users participation in my previous question. Read SQL SERVER – Interesting Interview Questions before continuing reading this article. This interview question was about user participation and about how good and how different you can come with your T-SQL script. What I really liked is that many users…

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

December 16, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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 – Connect using Enterprise Manager to SQL Server 2005/2008

December 14, 2008

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SQL Utility, SSMS

I received the following email from Mike Bikinis. about enterprise manager. “How can I connect to SQL Server 2005 or SQL Server 2008 using SQL Server 2000’s Enterprise Manager?”

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.…