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

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

June 17, 2011

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

Earlier I asked puzzle why statistics are not updated. Read the complete details over here: Statistics are not Updated but are Created Once In the question I have demonstrated even though statistics should have been updated after lots of insert in the table are not updated.(Read the details SQL SERVER –…

SQL SERVER – Free Online Training on .net and SQL

June 16, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Best Practices

I around 10 Free Online Training Codes available of .NET and SQL Training from Pluralsight. I am willing to give it to someone who wants learn technology this weekend. You just have to go to my Facebook page and leave a comment explaining in one line – what course will…

SQL SERVER – Solution – Puzzle – SELECT * vs SELECT COUNT(*)

June 15, 2011

Pinal Dave

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

SQL Scripts

Earlier I have published Puzzle Why SELECT * throws an error but SELECT COUNT(*) does not. This question have received many interesting comments. Let us go over few of the answers, which are valid. Before I start the same, let me acknowledge Rob Farley who has not only answered correctly…

SQLAuthority News – BI Quiz Question – How to Optimize Cube? – Hints

June 14, 2011

Pinal Dave

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

I earlier wrote about SQL BI Quiz over here. The details of the quiz is as following: Working with huge data is very common when it is about Data Warehousing. It is necessary to create Cubes on the data to make it meaningful and consumable. There are cases when retrieving…

SQL SERVER – Watch Online and Download – Inside of Next Generation SQL Server – Best Practices Analyzer using Microsoft Baseline Configuration Analyzer

June 14, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

I presented on subject Inside of Next Generation SQL Server – Denali online at Zeollar.com. This sessions are really fun as they are online, downloadable, and 100% demo oriented. I used SQL Server ‘Denali’ CTP 1 to present on the subject of What is New in Denali. My earlier session…

SQL SERVER – First Month as DBA Trainee – Disasters and Recovery

June 14, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Best Practices

This blog post is written in response to the T-SQL Tuesday hosted by Allen Kinsel. He has selected very interesting subject for T-SQL Tuesday – Disaster and Recovery. This subject took me in past – my past. There were various things, I had done or proposed when I started very…

SQL SERVER – Extending SQL Azure with Azure worker role – Guest Post by Paras Doshi

June 13, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure

This is guest post by Paras Doshi. Paras Doshi is a research Intern at SolidQ.com and a Microsoft student partner. He is currently working in the domain of SQL Azure. SQL Azure is nothing but a SQL server in the cloud. SQL Azure provides benefits such as on demand rapid…