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

SQL SERVER – SmallDateTime and Precision – A Continuous Confusion

May 22, 2012

Some kinds of confusion never go away. Here is one of the ancient confusing things in SQL. The precision of the SmallDateTime is one concept that confuses a lot of people, proven by the many messages I receive everyday relating to this subject. Let me start with the question: What is the…

SQL SERVER – Renaming Index – Index Naming Conventions

May 21, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

If you are regular reader of this blog, you must be aware of that there are two kinds of blog posts 1) I share what I learn recently 2) I share what I learn and request your participation. Today’s blog post is where I need your opinion to make this…

SQL SERVER – New Look for CodePlex Project – Hosting for Open Source Software

May 20, 2012

Pinal Dave

SQL

SQL Server

Codeplex is my favorite site. CodePlex is Microsoft’s free open source project hosting site. You can create projects to share with the world, collaborate with others on their projects, and download open source software. It is a great place to find so many open source project available to explore. All the software are the free and open source. I often go there at intervals to check what is new in SQL Server field as well on other technologies. Yesterday when I visited it, I had a nice surprise as it has a total makeover and looks very decent as well elegant at the same time.

SQL SERVER – Saturday Fun Puzzle with SQL Server DATETIME2 and CAST

May 19, 2012

Pinal Dave

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

SQL DateTime

Note: I have used SQL Server 2012 for this small fun experiment. Here is what we are going to do. We will run the script one at time instead of running them all together and try to guess the answer. I am confident that many will get it correct but…

SQLAuthority News – SQL Server 2012 Upgrade Technical Guide – A Comprehensive Whitepaper – (454 pages – 9 MB)

May 17, 2012

Pinal Dave

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

Database, DBA, SQL Documentation, SQL Download, SQL White Papers

Microsoft has just released SQL Server 2012 Upgrade Technical Guide. This guide is very comprehensive and covers the subject of upgrade in-depth. This is indeed a helpful detailed white paper. Even writing a summary of this white paper would take over 100 pages. This further proves that SQL Server 2012 is…

SQL SERVER – SQL in Sixty Seconds – 5 Videos from Joes 2 Pros Series – SQL Exam Prep Series 70-433

May 16, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Joes 2 Pros SQL Server Learning series is indeed fun. Joes 2 Pros series is written for beginners and who wants to build expertise for SQL Server programming and development from fundamental. In the beginning of the series author Rick Morelan is not shy to explain the simplest concept of…

SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME

May 15, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table

Sometime a simple solution have even simpler solutions but we often do not practice it as we do not see value in it or find it useful. Well, today’s blog post is also about something which I have seen not practiced much in codes. We are so much comfortable with…