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

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

January 2, 2015

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…

SQL SERVER – Puzzle – Why Divide by Zero Error

December 29, 2014

Pinal Dave

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

Earlier I asked a puzzle SQL SERVER – Puzzle – Why Decimal is Rounded Up? and it was very well received by all of you. You can read various comments posted in the blog post and they are indeed very enlightening. After posting that blog post, I received quite a lots of emails asking…

SQL SERVER – Microsoft Releases for December 2014

December 28, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

Earlier this month, Microsoft has released quite a few SQL Server related tools, add-ons, and upgrades. I have listed a few of them here for a quick reference. The descriptions are of each downloads are from Microsoft download pages. Microsoft Azure, Cloud and Enterprise Symbol / Icon Set for Visio, PowerPoint,…

Google Spreadsheet – Finding Last Value from Column

December 27, 2014

Pinal Dave

SQL Tips and Tricks

Google, SQL Server

I have previously written about how to find the top and bottom value of column in SQL Server but recently I got a very interesting question based on the same blog post. The question was how to find the last value from Column in Google Spreadsheet. I find it very interesting and attempted to find the solution in Google Spreadsheet.