A very strange question I received the other day in an email about how to convert decimal to time format string.
What is the Default Datatype of NULL? – Interview Question of the Week #131
Question: What is the Default Datatype of NULL?
SQL SERVER – ALTER Column from INT to BIGINT – Error and Solutions
Sometime ago I wrote a blog on identity column value jump issue, you can read it from here SQL SERVER – Jump in Identity column after restart! In this blog post we will learn how to resolve the error when we alter column from int to bigint.
SQL SERVER – Puzzle – Incorrect Results with Decimal
It has been a while we have seen a puzzle on this blog and I keep on receiving emails and comments that you all would love to see one more puzzle. Let us see a new puzzle “Incorrect Results with Decimal”.
How to Round Up or Round Down Number in SQL Server? – Interview Question of the Week #125
Question: How to Round Up or Round Down Number in SQL Server?
SQL SERVER – Observation – Adding a NULL Column and Table Space
It is always fun to receive a follow up comments when I write a blog post. Yesterday I wrote about SQL SERVER – Simple Query to List Size of the Table with Row Counts and here is the follow up question which I received about adding a NULL column.
SQL SERVER – FIX : Msg 8115, Level 16, Arithmetic Overflow Error Converting IDENTITY to Data Type INT
One of my friends who is a SharePoint expert told that he is getting overflow error while doing check-in on the document. He was confident that the error is related to SQL and that’s why he contacted me. I used profiler and found the table which had the problem and fixed that as well. This blog is an outcome of that work done. Let us see the error related to Arithmetic Overflow Error.