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

SQLAuthority News – Updates on Contests, Books and SQL Server

November 8, 2011

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

There are lots of things happening on this blog and I feel sometime it is difficult to keep up. One of the suggestion I keep on receiving if there is a single page where one can visit and know the updates. I did consider of the same at some point…

SQL SERVER – Introduction to CUME_DIST – Analytic Functions Introduced in SQL Server 2012

November 8, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

This blog post is written in response to the T-SQL Tuesday post of Prox ‘n’ Funx. This is a very interesting subject. By the way Brad Schulz is my favorite guy when it is about blogging. I respect him as well learn a lot from him. Everybody is writing something…

SQL SERVER – Video – Performance Improvement in Columnstore Index

November 7, 2011

Pinal Dave

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

SQL Index, SQL Scripts

I earlier wrote an article about SQL SERVER – Fundamentals of Columnstore Index and it got very well accepted in community. However, one of the suggestion I keep on receiving for that article is that many of the reader wanted to see columnstore index in the action but they were…

SQL SERVER – Updating Data in A Columnstore Index

November 6, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

So far I have written two articles on Columnstore Indexes, and both of them got very interesting readership. In fact, just recently I got a query on my previous article on Columnstore Index. Read the following two articles to get familiar with the Columnstore Index. They will give you a…

SQL SERVER – SSMS 2012 Reset Keyboard Shortcuts to Default

November 5, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server, SQL Server Management Studio

As a technologist, I love my laptop very much and I do not lend it to anyone as I am usually worried that my settings would be messed up when I get it back from its borrower. Honestly, I love how I have set up my laptop and I enjoy…

SQL SERVER 2012 Editions – Highlights of The Cloud-Ready Information Platform

November 4, 2011

Pinal Dave

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

Business Intelligence

Microsoft has just announced SQL Server 2012 Editions information on official SQL Server 2012 site. SQL Server 2012 will be available in three main editions: Enterprise Business Intelligence Standard The other editions are Web, Developer and Express. Here is the salient features of each of the edition: Enterprise Advanced high…

SQLAuthority News – SQL Server Interview Questions And Answers Book Summary

November 4, 2011

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks, SQLAuthority News

Best Practices, Database

Today we are using computers for various activities, motor vehicles for traveling to places, and mobile phones for conversation. How many of us can claim the invention of micro-processor, a basic wheel, or the telegraph? Similarly, this book was not written overnight. The journey of this book goes many years…