Tags » SQL Authority

SQL SERVER - Identify Disk Latency on SQL Server Box Using PowerShell

Couple of week back, I was playing around with using Powershell for some simple activities. The fall out of that was the ability to search the… 462 more words

SQL Authority

SQL SERVER - CREATE TABLE Failed Because Column 'C1024' in Table 'myTable' Exceeds the Maximum of 1024 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. 491 more words

SQL Authority

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

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. 244 more words

SQL Authority

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

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. 743 more words

SQL Authority

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

: This is a 81th episode of Notes from the Field series. Master Data Services is one of the most important, but very little explored feature of SQL Server.  830 more words

SQL Authority

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

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. 207 more words

SQL Authority