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

SQL SERVER – DBCC CHECKDB errors – Msg 2520 during executions

August 21, 2015

Some of the simplest recommendations can lead you to some bizarre output that we never anticipated. I always recommend running DBCC CHECKDB on mission critical databases because we need to be 200% sure that the database disk system is healthy from time to time. During one of my sessions, I…

SQL SERVER – Rewriting Database History – Notes from the Field #094

August 20, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field

[Note from Pinal]: This is a 94th episode of Notes from the Field series. When I read the title of this article – I was extremely intrigued with it – Rewriting Database History! When I was a kid, history was my favorite subject and till today when I have to deal…

SQL SERVER – Login failed for user . Reason: Token-based server access validation failed

August 19, 2015

Pinal Dave

SQL

SQL Error Messages, , SQL Scripts, SQL Server

This is one of the most common error searched on my blog search https://blog.sqlauthority.com/search-sqlauthority/ and lately I realized that I have not written any blog about the cause of such error and fixing that. Let us learn about how to fix the error login failed.

SQL SERVER – How to Migrate Existing Database to Contained Databases

August 18, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Most of the queries that land into my inbox are based on something I have already written or something people want to explore more on. When it comes to learning and exploring the skills, there is no better way compared to people asking me some tough questions. This blog is…

SQL SERVER – PowerShell – Knowing SQL Server Information

August 17, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell

If you search this blog, there are a number of PowerShell scripts that I have shared in the recent past. Some of them include: Using PowerShell and Native Client to run queries in SQL Server Identify Disk Latency on SQL Server Box Using PowerShell How to Find Logical and Physical…

Interview Question of the Week #032 – Best Practices Around FileGroups

August 16, 2015

Pinal Dave

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

Here is another question I just heard during a recent interview in the multinational company. I have observed over 1000s of interview, but this is the first time I have heard this is being discussed and I was very much glad to hear it. I have listed the answer of…

SQL SERVER – How to Identify Locked Table in SQL Server?

August 15, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Here is a quick script which will help users to identify locked tables in the SQL Server. SELECT OBJECT_NAME(p.OBJECT_ID) AS TableName, resource_type, resource_description FROM sys.dm_tran_locks l JOIN sys.partitions p ON l.resource_associated_entity_id = p.hobt_id When you run above script, it will display table name and lock on it. I have written…