SQL Server Archives - Page 27 of 393 - SQL Authority with Pinal Dave

Interview Question of the Week #022 – How to Get Started with Big Data?

May 31, 2015

Big Data, SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Big data is one of the most popular subject in recent time and everybody wants to get started on this subject. During recent interviews there are plenty of the questions with related to Big Data. Here is the most popular question which I receive on this subject. Question: How to…

SQL SERVER – Error Msg 511 using SQL Server Sparse columns

May 30, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SPARSE Columns, SQL Error Messages, SQL Scripts

When I wrote the previous post around SQL SERVER – CREATE TABLE Failed Because Column ‘C1024′ in Table ‘myTable’ Exceeds the Maximum of 1024 Columns, I thought it was a simple concept. Lesser did I know that there can be something wrong. One of my blog reader said they were getting…

SQL SERVER – Using 20 Logical Processors Based on SQL Server Licensing

May 29, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

It is second to human nature to utilize every bit of juice for what we pay. You buy something and you would like to get the best out of it right? If you start thinking from an organizations point of view, they think they should buy something which satisfies their…

SQL SERVER – What are T-SQL Window Functions? – Notes from the Field #082

May 28, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Scripts

[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about easy and amazing functions of SQL Server. Kathi is an amazing instructor, she was the SQL author I have read in my early career. The reason, I love SQL Server because her writing has…

SQL SERVER – CREATE TABLE Failed Because Column ‘C1024’ in Table ‘myTable’ Exceeds the Maximum of 1024 Columns

May 25, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SPARSE Columns

Sometimes the best way to learn is by taking some of the capabilities to the extreme. This blog post is one of those explorations which I would like to share. A very long time ago I wrote a blog on this feature which was introduced in SQL Server 2008 called…

Interview Question of the Week #021 – Difference Between Index Seek and Index Scan (Table Scan)

May 24, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index

Question: What is the difference between Index Seek and Index Scan? Answer: Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table. Index Scan: Since a scan touches every row in the table whether or not it qualifies, the cost is proportional to the…

SQL Server – Knowing Deprecated or Discontinued Features Using Extended Events

May 23, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Extended Events

This blog is in continuation to what I wrote couple of weeks back – SQL Server – Knowing the Use of Deprecated or Discontinued Features. The concept of using a deprecated feature is not by intensions by developers but is an accident for many. When I wrote that blog post, lesser…