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

SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name

July 15, 2012

Place: Any Developer Shop Scenario: A developer wants to drop a column from a table Time: Any Day – usually right before developer wants to go home The developer rushes to the manager and following conversation begins: Developer: I want to drop a column from one of the tables. Manager:…

SQL SERVER – Example of Width Sensitive and Width Insensitive Collation

July 14, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I had a great time writing blog post SQL SERVER – Effect of Case Sensitive Collation on Resultset. It was interesting to see lots of questions related to collation based on this blog post. However, one of the question, I find very interesting and though to share today here. Question: What is…

SQL SERVER – Switch Between Two Parenthesis using Shortcut CTRL+]

July 13, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Shortcut

Earlier this week I wrote a blog post about SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis, I received quite a lot of positive feedback from readers. If you are a regular reader of the blog post, you must be aware that I appreciate the learning shared by…

SQL SERVER – Effect of Case Sensitive Collation on Resultset

July 12, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Collation is a very interesting concept but I quite often see it is heavily neglected. I have seen developer and DBA looking for a workaround to fix collation error rather than understanding if the side effect of the workaround. Collation is a very deep subject. Earlier I wrote an article…

SQL SERVER – Remove Debug Button in SSMS – SQL in Sixty Seconds #020 – Video

July 11, 2012

Pinal Dave

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

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

SQL in Sixty Seconds is indeed tremendous fun to do. Every week, we try to come up with some new learning which we can share in Sixty Seconds. In this busy world, we all have sixty seconds to learn something new – no matter how much busy we are. In…

SQL SERVER – Monday Morning Puzzle – Query Returns Results Sometimes but Not Always

July 9, 2012

Pinal Dave

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

The amount of email I receive sometime it is impossible for me to answer every email. Nonetheless I try to answer pretty much every email I receive. However, quite often I receive such questions in email that I have no answer to them because either emails are not complete or they…

SQLAuthority News – 2 Whitepapers Announced – AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution

July 8, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

AlwaysOn, SQL Documentation, SQL Download, SQL White Papers

Understanding AlwaysOn Architecture is extremely important when building a solution with failover clusters and availability groups. Microsoft has just released two very important white papers related to this subject. Both the white papers are written by top experts in industry and have been reviewed by excellent panel of experts. Every…