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

SQL SERVER – Filter In-Memory OLTP Tables in SSMS

January 5, 2015

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…

SQL SERVER – Fix – Missing “Mirroring” and “Transaction Log Shipping” option in the Database Properties

January 2, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

If you are a SQL Server developer or DBA, the chances are you are quite familiar working with SQL Server Management Studio. The longer you have been in the industry, more likely are you to take these tools for granted. Sometimes, the tool or our basic mistakes in understanding the…

SQL SERVER – Year 2014 Reflections by Tim Radney – Notes from the Field #060

January 1, 2015

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Notes from the Field, Shrinking Database

[Notes from Pinal]: New Year’s Resolutions is a funny word. Everybody makes it on January 1st but breaks it in very few days. I used to make resolutions too, but for a while, I have stopped this practice. Tim Radney is my great friend and I asked him that what…

SQLAuthority News – Thank You for Amazing Year! – Five Sixty Seconds Video

December 31, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

The year 2014 was amazing and I had a great time learning and sharing knowledge. I must thank you my dear readers for your constant support and motivation. I have been blogging every single day for over 8 years and this is only possible because of your help. Today is…

SQL SERVER – UNION and UNION ALL with TEXT DataType – Observation

December 30, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Union clause

You can find the difference between UNION and UNION ALL in the following posts Union vs. Union All – Which is better for performance? There is one more difference between the two when a column of TEXT datatype is involved. When you use UNION for a TEXT column you will get…