SQL Server Archives - Page 43 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Visibility into the Overall Health of Your SQL Server Environment – You Can’t Fix What You Can’t See

January 13, 2015

I am sure most of us have experienced driving a four wheeler. The first time I went behind the wheels, it was an amazing experience. My excitement was multiplied by tension in the face of my father. After a while, I could see a sigh of relief and confidence even…

Interview Question of the Week #002 – Script to Find Byte Size of a Row for All the Tables in Database

January 11, 2015

Pinal Dave

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

In recent times I was part of the interview panel where I was stunned to see that following question was asked to interviewee. I personally believed that this question is no longer relevant as we are in the age where database are capable to handle large amount of data and the…

SQL SERVER – What is the query used in sp_cursorfetch and FETCH API_CURSOR?

January 10, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Cursor

In a recent debugging exercise for performance, one of my friend recently posted a question to me: “When I view activity monitor, under the recent expensive queries and under query column, there I see a “fetch api_cursor0000000000000003”. What is this? How can I know what was running behind this query?…

SQL SERVER – What is is_not_trusted in sys.foreign_keys?

January 9, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table

My greatest source of learning is via my blog. Many of you take time in asking your toughest questions and sometimes basic questions that make me think. This interaction creates a source of exploration for me and ultimately translates into my knowledge sharing. All questions asked by DBAs are not…

SQL SERVER – Iterating over Metadata with BimlScript – Notes from the Field #061

January 8, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

BIML, Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 61st episode of Notes from the Field series. One of the common question I receive every other day is – I have learned BI but I feel that there is no automation in the BI field, what should I do? How do I go beyond learning…

SQL SERVER – Schema Change Reports – SQL in Sixty Seconds #078

January 6, 2015

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks, SQL Video

SQL Error Messages, SQL Function

Earlier, I wrote a blog post about Schema Change Reports and Finding Tables Created Last Week – DBA Tip. I received quite a few emails about the same. It seems like a quite a popular topic. As per few requests I have created a very short 60 second video on this…

SQL SERVER – Finding Tables Created Last Week – DBA Tip

January 6, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

My conversations with my DBA friends are always interesting. They have unique ways to solve problems and organizations take them for granted. Most of the DBA’s want to be in control of their environment. There is no second thought on it when it comes to delivery from their side. In…