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

SQL SERVER – Error: Fix: Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file failed with the operating system error 2(The system cannot find the file specified.) – Part 2

January 27, 2015

Errors are a great starting point for learning. Especially, my inbox is always flooded with atleast 2-3 error messages almost every other day. People keep asking me how to solve them, what to do when we encounter an error and so on. Long time back I wrote a simple blog…

Interview Question of the Week #004 – List All Columns and Their Data Type for a View

January 25, 2015

Pinal Dave

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

SQL Scripts

Earlier this week I wrote a blog about finding stored procedure parameters and their data types. After that blog I received few emails from my blog readers asking for similar script for a view. I asked them what did they like about the script and they said that it gives us…

SQL SERVER – How to Bind Resource Governor for InMemory Enabled Databases?

January 24, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Resource Governor

I have done a number of courses for Pluralsight. Last year when SQL Server 2014 was released, I planned to do a session on the same. The course SQL Server 2014 Administration New Features was a lot of hardwork but it did give me a chance to learn something new…

SQL SERVER – Who is Consuming my TempDB Now?

January 23, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL TempDB

Off late my love for TempDB and writing on topics of tempDB has been a great learning experience. The more I work with tempDB, the more fascinated I am. TempDb is being used by a number of operations inside SQL Server, let me list some of them here: Temporary user…

SQL SERVER – The DBA goes to MARS – Maintenance, Architecture, Research and Support – Notes from the Field #063

January 22, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 63rdth episode of Notes from the Field series. Storytelling is an art very few have mastered in their life. When I requested Stuart to share his ideas about his famous blog about MARS, I really had not expected the response which I have received in…

SQL SERVER – Backups are Non-negotiable Lifeline for DBAs

January 21, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Idera

I have had my share of DBA friends who have told me a number of horror stories from their experiences. Thinking back, these look like moments to laugh away but there are some serious learnings we get from these experiences. I am a personal believer of learning something in everything…

SQL SERVER – How DBAs Have to be Proactive in Identifying and Fixing Problems Before They Happen

January 20, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Dell

In real life our dear ones always love to have surprises. If we do things even before they can think, we are in for some fun for rest of the days/weeks. I vividly remember a conversation with my daughter in recent past. I had made a deal to get her…