Dinesh's Blog :::: Being Compiled ::::

SQL Server offers many number of built-in functions for getting commonly required operations done, minimizing the time and resources need to...

Cumulative update #8 is available for SQL Server 2012 SP1. Refer the following link for downloading it and understanding the fixes done. h...

For implementing explicit conversion from one type to another, we have been using either CAST or CONVERT functions given by Microsoft SQL Se...

SQL Server offers different useful datetime data types for different purposes. Knowing all and their capabilities would definitely help you ...

What is the usual way of getting current date and time from SQL Server? Obviously, the answer is GETDATE function. Do you know that there ar...

SQL Server 2012 introduces many new string functions including CLR based functions. FORMAT is one of them which can be used for formatting d...

If your database is multilingual, you are familiar with “N” prefix. Basically, we use “N” character as a prefix for string values when passi...

NULLs in databases are considered as unknown values and can never be compared with another. This behavior (or the known fact) is common to M...

We have been using plus sign (+) operator for concatenating string values for years with its limitations (or more precisely, its standard be...

Business User: I need the product code as product name, whenever I use product dimension, system should default to the code, not the name, ...

Here is the video recorded of SS SLUG. You can watch the session SQL Brain Bashers again and see all we discussed. Demo links: http://dine...

Assume that an index has been created using three columns. Will SQL Server use the index if the 2nd column is used for filtering? I asked ...

Column aliases are commonly used for relabeling columns for increasing the readability of SQL statements. However aliases cannot be referred...

How many ways you have used for executing a T-SQL code in Management Studio? I am sure you have used two well-known options but other three ...

There could be many reasons for this but in most cases, this misleads us, specifically if the MDX is running with Management Studio. You see...

Have you installed all service packs and necessary patches for all your SQL Server instances? Check the version with this table, if not, get...

Demo 1: Filtering DateTime values – SS SLUG Dec 2013 – SQL Brain Bashers - Demo I Demo 2: How SQL Server interprets two-digit years as f...

If someone asks “Why SQL Server splits pages”, I know that all of you say “If an insert or update requires more space, SQL Server splits the...

First of all, Happy New Year 2014! May your all dreams come true in 2014! This post is related to the presentation “SQL Brain Bashers” I d...