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

SQL SERVER – Get SQL Server Version and Edition Information – SQL in Sixty Seconds #043 – Video

February 13, 2013

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

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

What do consultants do when they come across any new instance of SQL Server? Well, their very first question is what version of SQL Server is it? The reason is simple – SQL Server is a very vast product and each version of the product have new features released and…

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1 and Included Columns Col2 and Col3 – Part 5

February 12, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

This is the fifth part of the series regarding Redundant Indexes. If have not read earlier part – there is quite a good chance that you will miss the context of this part. I quickly suggest you to read earlier four parts. On my production server I personally use embarcadero DB Optimizer for…

SQL SERVER – What is Semantics Model – A Simple Explanation

February 11, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

“Semantics” refers to the meaning behind words, sentences, or phrases. This is its general meaning. In technology, even the word “semantics” has more meanings. Semantics, and semantic models, refer to how data is organized within a database to make it more useful for users. So, in technology, semantics have the…

SQL SERVER – Primary Key and NonClustered Index in Simple Words

February 10, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

I have been writing a weekly round up from my blog where I go over last six years of blog posts and pick the best posts from the pasts. While I do this, there are two major place where I focus 1) If there are change in features – I…

SQL SERVER – Weekly Series – Memory Lane – #015

February 9, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQLAuthority News – Delhi Women Safety – 2400th Blog Post – A Milestone

February 7, 2013

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQL Milestone

I have stopped writing milestone posts recently as I realized that they really do not serve any other value besides having boastful note about myself. I rather do some important contribution to my blog so I started to build Weekly Memory Lane series and that is a much better contribution in…

SQL SERVER – Generate Random Values – SQL in Sixty Seconds #042 – Video

February 6, 2013

Pinal Dave

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

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

Though it looks simple it is very difficult to generate random numbers which one can’t guess. There are many different ways to generate random values in SQL Server. I have previously blogged about it over here where I have demonstrated five different methods to generate random values in SQL Server.…