|
|
-
|
|
How do you extract Day of the Year, Day of the Week and Week Number values from a given date using nothing but T-SQL? In this post, we look at how the DATEPART function can be of help in achieving this requirement....
|
|
-
|
|
Working with the Profiler helps one learn SQL Server internals in a much better way. This post is based on a question I received in the ASK module of BeyondRelational.com regarding why we don't generally see parameter values in the "SQL:StmtCompleted" events....
|
|
-
|
|
Avoid the hassle of going to the Query menu and choosing the SQLCMD mode if most of your queries are designed for SQLCMD. Set the "Open new queries in SQLCMD mode" switch in SSMS options for a productive day!...
|
|
-
|
|
There are multiple ways in which column aliases can be defined in a T-SQL query depending upon the developer''''s preference. However, not all are recommended for new code being developed, because they will be discontinued in a future release of Microsoft SQL Server. Today, I look at the various methods used to define column aliases....
|
|
-
|
|
Today’s post is a short and simple one. No system is error free. The key is in providing easy and efficient mechanisms to capture these errors and enabling the users of the system to extract meaningful information from these error logs. Microsoft SQL S...
|
|
-
|
|
A lot changed on the technology space this month. Today, I would write about a couple of these announcements that are bound to dominate the technology space in 2012. There are a lot of new announcements coming through, but below are the products that I would be watching out for. New Server Systems!......
|
|
-
|
|
One of the reasons I enjoy working with Microsoft SQL Server because often I find that its behaviour is a classic case of GIGO (Garbage In Garbage Out). Jacob Sebastian (blog) always makes it a point to mention in his TechEd and Community Tech Days sessions that one must also treat SQL Server with r......
|
|
-
|
|
As most of the readers of my post know, I have always tried to find features of the SQL Server Management Studio (SSMS) that boost productivity & allow for efficient administration. One such feature is that SSMS allows us to customize the query options for any particular query window (Refer Appe......
|
|
-
|
|
Today’s post takes me back to the days when I was learning SQL Server at the engineering school about 8 years ago. I learnt SQL 7 and SQL 2000 and then as I joined my present employer, SQL 2005 came along. While SQL 7/2000 had the Enterprise Manager, SQL 2005 onwards we have the SSMS – S......
|
|
-
|
|
Microsoft SQL Server is home to many myths and legends, and I have developed an interest in knowing about them. It is really a very interesting exercise to know about these myths, and prove them incorrect if the situation permits. The Myth One such myth is that a table name in a Microsoft SQL Serv......
|
|