Tag Archives: SQL Scripts

Conversion functions in SQL Server 2012

Conversion functions  in SQL Server 2012   Before starting with “Conversion functions in SQL Server 2012” we’ll have a look into “Why data conversion needed?” Does SQL Server can’t do it automatically? Yes! SQL server can do data conversion internally … Continue reading

Posted in SQL Development | Tagged , , , , , , , , , | Leave a comment

What is the Difference between NUMERIC / DECIMAL and FLOAT / REAL in SQL Server 2012?

What is the Difference between NUMERIC / DECIMAL and FLOAT / REAL Q. What is the Difference between NUMERIC / DECIMAL and FLOAT / REAL in SQL Server 2012? Ans: Before dig into these data types we must have a … Continue reading

Posted in SQL Development | Tagged , , , , , , , | 3 Comments

SQL Server database backup automation using T-SQL

SQL Server database backup automation using T-SQL I have gone through a request as a part of daily maintenance. Found a backup maintenance plan has been failed due to low disk space.  “SQL Task     Description: Executing the query “BACKUP DATABASE … Continue reading

Posted in SQL Server DBA | Tagged , , , , , , , | 1 Comment