SQL Archives - Page 308 of 464 - SQL Authority with Pinal Dave

SQL SERVER – Three Puzzling Questions – Need Your Answer

June 7, 2011

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

Last week I had asked three questions on my blog. I got very good response to the questions. I am planning to write summary post for each of three questions next week. Before I write summary post and give credit to all the valid answers. I was wondering if I…

SQL SERVER – BI Quiz – Troubleshooting Cube Performance

June 6, 2011

Pinal Dave

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

Business Intelligence

My friend Jacob Sebastian runs SQL BI Quiz competition. Where there are 30 different questions on each day of the month. Winners get opportunity to participate in this Quiz, learn something new and win great awards. Working with huge data is very common when it is about Data Warehousing. It…

SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit – Download – May Update

June 5, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

I often receive the question what is the quickest way to learn SQL Server 2008 R2. Microsoft have published developers training kit which one can download and learn at your own pace, it has tutorials, videos, and hands-on lab which one can practice. This training kit has been published earlier…

SQLAuthority News – Download Pre-configured VHD – SQL Server 2008 R2 Standard on Windows Server 2008 R2 SP1 Standard

June 5, 2011

Pinal Dave

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

SQL Documentation, SQL Download

It is extremely simple to test out latest SQL Server 2008 R2. You can even get pre-configured ready to use VHD, which you can download and use it. This becomes very easy as one does not have to do anything besides downloading VHD and installing it on Hyper-V. Download Pre-configured…

SQLAuthority News – Community Tech Days – TechEd on The Road – Ahmedabad – June 11, 2011

June 3, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Best Practices, Database, DBA, MVP, SQL Wait Stats

TechEd on Road is back! In Ahmedabad June 11, 2011! Inviting all Professional Developers, Project Managers, Architects, IT Managers, IT Administrators and Implementers of Ahmedabad to be a part of Tech•Ed on the Road, on 11th June, 2011. We have put together the best sessions from Tech•Ed India 2011 for…

SQL SERVER – Puzzle – Statistics are not Updated but are Created Once

June 2, 2011

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index, SQL Statistics

After having excellent response to my quiz – Why SELECT * throws an error but SELECT COUNT(*) does not?I have decided to ask another puzzling question to all of you. I am running this test on SQL Server 2008 R2. Here is the quick scenario about my setup. Create Table…

SQL SERVER – Creating All New Database with Full Recovery Model

June 1, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Sometimes, complex problems have very simple solutions. Let us see the following email which I received recently. “Hi Pinal, In our system when we create new database, by default, they are all created with the Simple Recovery Model. We have to manually change the recovery model after we create the…