All of us like Keyboard Shortcuts and use it frequently but memorizing them might be painful and we get to remember them after we use it over a period of time. I just found a very easy way to learn and remember the Keyboard Shortcuts in SQL Server Ma...

All of us like Keyboard Shortcuts and use it frequently but memorizing them might be painful and we get to remember them after we use it over a period of time. I just found a very easy way to learn and remember the Keyboard Shortcuts in SQL Server Ma...

I learned about this from Pinal Dave's blog(You can see the original article in references.) In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...

I learned about this from Pinal Dave's blog(You can see the original article in references.) In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...

Learn...

Learn...

Learn...

I would like to brush up one of the basic concept. We can use SELECT column alias in ORDER BY clause. But we can't use in GROUP BY clause. The reason is, ORDER BY clause is processed after the SELECT statement; GROUP BY clause is processed before the ...

I would like to brush up one of the basic concept. We can use SELECT column alias in ORDER BY clause. But we can't use in GROUP BY clause. The reason is, ORDER BY clause is processed after the SELECT statement; GROUP BY clause is processed before the ...

During working for script to send mail alerts, i just learned as we can change display name for the mail at runtime. It will normally use profile name or display name which configured in database mail profile for mail. Below query will use display name ...