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

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

May 25, 2015

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…

SQL SERVER – Only Formatted Files on Which the Cluster Resource of the Server has a Dependency can be Used

May 22, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Getting little help and learning from each other always helps. When I don’t get to know of something and I need to explore something, I try to check with my SQL friends who can guide me in the right direction. This blog is a classic example of me trying to…

SQL SERVER – Adding Reference Data to Master Data Services – Notes from the Field #081

May 21, 2015

Pinal Dave

SQL Tips and Tricks

Master Data Services, Notes from the Field, SQL Scripts, SQL Server, SQL Server Security

[Note from Pinal]: This is a 81th episode of Notes from the Field series. Master Data Services is one of the most important, but a very little explored feature of SQL Server. If you have been reading this blog, when it is about BI, I always take help from LinchPin People who are BI experts. I requested Reeves from LinchiPin people to help me answer this unique question. Let us learn in this blog post how to add reference data to Master Data Services (MDS).

SQL SERVER – Puzzle with MONTH Function – Win USD 50 Amazon Gift Card

May 20, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Embarcadero

It has been a while since we ran the contest. I reached out to kind team of Embarcadero and they agreed to support the next contest. The contest has two steps and they are very simple. It took me a while to build contest, but it is a really fun…

SQL SERVER – Antivirus Exclusions Best Practices With SQL Server

May 19, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Utility

One of the classics as far as best practices is concerned is to exclude SQL Server files and folders on your antivirus programs running on the server. We all know this statements and often I see DBAs not adding any extra care to this recommendation. There are not many blogs…