Feeds:
Posts
Comments

Archive for the ‘SQL Query’ Category

SQLAuthority News – Business Intelligence features of SQL Server 2012 RC0 – Download Virtual Machine

Posted in Business Intelligence, PostADay, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on February 12, 2012 | Leave a Comment »

I am in front of computer 16+ hours of the day. However, I accept that I am bit lazy when it is about doing installation etc. I always prefer that IT department help me to install my computer and I use it right away. Same feeling I get when I have to install Beta, RC [...]

Read Full Post »

SQL SERVER – Solution – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

Posted in Pinal Dave, PostADay, Readers Question, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on February 11, 2012 | 1 Comment »

Yesterday was really fun. I asked a simple Brain Teaser and we had excellent conversation on SQLAuthority Page as well SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser. That was an easy puzzle for those who have attended the SQL Server Questions and Answers online course. Here is a quick recap of the puzzle. Lots [...]

Read Full Post »

SQL SERVER – A Quick Puzzle on JOIN and NULL – SQL Brain Teaser

Posted in Pinal Dave, PostADay, Readers Question, SQL, SQL Authority, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on February 10, 2012 | 14 Comments »

It seems that we all love to solve puzzles. On SQLAuthority Page, we have been playing the number game and those who are playing with us know how much fun we are having. Sometimes, the answers are so innovative and informative that they open up those aspects of the technology which I have not thought [...]

Read Full Post »

SQL SERVER – INNER JOIN Returning More Records than Exists in Table

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Joins, SQL Puzzle, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology on February 9, 2012 | 10 Comments »

I blog and engage with the community because it gives me satisfaction when someone resolves an issue. A few days ago, I blogged about a DBA who began his first day at a new company and could not find out where the installation summary file was. He was very happy when I featured his story [...]

Read Full Post »

SQL SERVER – Installation Log Summary File Location – 2012 – 2008 R2

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on February 7, 2012 | 9 Comments »

Here is email received from user: “Pinal, I am new DBA in my organization and I have to manage SQL Server 2005, 2008 and 2008 R2. Today is my first day at job and my manager has asked me to install all these different edition on our test environment. I have finished installing them. Later [...]

Read Full Post »

Older Posts »

Follow

Get every new post delivered to your Inbox.

Join 16,216 other followers