@Marc: Sorry about the delayed response as I was on travel for last couple days. Your points are valid and focus on the real world scenarios. The definitions that I have provided are more from an ideal scenario, but if we see, in real world, often thing...

@Paras: Thanks Paras! I am glad you liked it. And thanks for the additional information, it's helpful :-)...

From a disconnected query window, we can connect back to the SQL Server instance from the **Query > Connection > Connect** menu option. This may sound simple, but I found this interesting. I usually press F5 (or execute button) twice to get connecte...

From a disconnected query window, we can connect back to the SQL Server instance from the **Query > Connection > Connect** menu option. This may sound simple, but I found this interesting. I usually press F5 (or execute button) twice to get connecte...

ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($) after getting one bug i learn this from bol...

ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($) after getting one bug i learn this from bol...

I just learnt that, based on the frequency of data access and type of storage, there are three different categories of data. **Hot Data**: Data that is frequently accessed and stored on high speed storage/disks.
**Warm Data**: Data that is moderat...

Was trying to install HDInsight on Windows 7 machine but when I tried running the [Microsoft Web Platform Installer][1] and searched for [Hadoop or HDInsight][2], the search was failing. After some search online, I found that, HDInsight for Windows is a...

@Alpesh - That's another way of doing it. Thanks for posting one more way of doing it. However, if you see, dragging the columns folder from Object Explorer to SSMS Select Query is the fastest as far as I know....

Good one, Manas! It does not copy even the Foreign Keys, Indexes, & Constraints etc. More on this topic here: [Copy Table Structure With Or Without Data in SQL Server][1] [1]: http://dattatreysindol.com/2010/02/06/copy-table-structure-with-or-wi...