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

SQL SERVER – Error Msg 511 using SQL Server Sparse columns

May 30, 2015

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…

Using Power of Web to Query Databases / Sources With Skyvia

May 27, 2015

Pinal Dave

SQL

Devart, SQL Scripts, SQL Server, SQL Utility

Web technologies are moving at a pace that we can hardly keep up in pace. More and more of investments are going on in the space of web that even database developers like me find it interesting. In the same context, recently I was exploring on Skyvia (SQL SERVER – Integrate Your Data with Skyvia – Cloud ETL Solution) from ETL to how one might query and was surprised to see how some of these can be made useful.

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…