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

SQL SERVER – What is is_not_trusted in sys.foreign_keys?

January 9, 2015

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…

SQL SERVER – Filter In-Memory OLTP Tables in SSMS

January 5, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In-Memory OLTP, SQL Scripts, SQL Server Management Studio

Earlier I had written a blog about SQL SERVER – Beginning In-Memory OLTP with Sample Example which covers the basics of working with In-Memory OLTP. Though that post gets you started, one of my colleague asked me if there was an easier way to identify In-Memory Tables when working with SQL…

Interview Question of the Week #001 – Script to List Foreign Key Relationships and Constraint Name

January 4, 2015

Pinal Dave

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

SQL Constraint and Keys

Two years ago I wrote a book SQL Server Interview Questions and Answers with my very close friend Vinod Kumar. It is a very popular book of mine and has sold many thousands of copies so far. Every single day I still get quite a many different interview questions in…

SQL SERVER – UNION With TEXT DataType Returns Error but and UNION ALL Works – Reasons

January 3, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Union clause

Earlier I demonstrated a very interesting behavior in my blog post – UNION and UNION ALL with TEXT DataType – Observation, where we see that UNION clause with TEXT datatype returns Error but with UNION ALL it does not return an error. I did not know that earlier before I posted that blog…