There are many methods to store date values. One of them is Julian date. It is a seven digit number where first four is the year part and the next three digits are the number of days from Jan 01.
Interview Question of the Week #009 – Is GO T-SQL Statement?
I often get this question in the email – more frequently than I would like to get.
Question: “Is GO T-SQL statement?”
SQL SERVER – ReadOnly Databases and Notes Using Snapshots
This seems to be the third week that I am writing about ReadOnly databases, this blog is in continuation of last weeks notes. When I wrote the notes from last week, one of my blog reader said if it is possible to get the ReadOnly error without making the database into a ReadOnly database. This got me thinking and I couldn’t sleep that day. And a quick call to my friend to get some ideas – the answer was simple – using Snapshots.
Interview Question of the Week #008 – Write Scripts to Convert String to Title Case or Proper Case
Just received a question in an email asking questions about how to Convert String:
“I just got out of the interview and I was asked to write scripts to convert a string to Title Case. I was also asked to refer to the website over here to validate my answer after I complete writing script.
Do you think it is not fair to ask such questions in an interview?”
SQL SERVER – Quiz with DATEADD Function – SQL Puzzle
How many of us use some sort of date or datetime function when working with SQL Server? I cannot think of a single developer who would ever say they don’t work with datetime conversions in their application. Almost every application needs some manipulation of datetime datatypes. There are a number of pitfalls that can get into which we might not be aware. Here is a simple blog: Quiz with DATEADD Function that I would love to hear your views on what the output would be:
Interview Question of the Week #007 – How to Reindex Every Table of the Database?
Some questions are extremely popular questions and they never get old. Here is one such question which I see very often asked to DBAs in their early career. Question: How to re-index every table of the database? Answer: Well, The answer of this question can be only given in the form of the…
Read More
SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated
Earlier this week, I have blogged about how to suppress Warning: Null value is eliminated by an aggregate or other SET operation SQL SERVER – Warning: Null value is Eliminated by an Aggregate or Other SET Operation. Let us learn about the error STring or Binary Data would be truncated.