June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – SQL Blog SQLAuthority.com Comment by Mr. Ben Forta

Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, DBA, SQL Scripts
Today is one of the most glorious day for SQLAuthority.com in history. Famous author of Sams Teach Yourself Microsoft SQL Server T-SQL In 10 Minutes, ColdFusion Guru, and well known evangelists Mr. Ben Forta has made comment on his blog about SQLAuthority.com. I encourage all my readers to visit comment…
Read More

SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Stored Procedure
I usually run following script to check if any stored procedure was deployed on live server without proper authorization in last 7 days. If SQL Server suddenly start behaving in un-expectable behavior and if stored procedure were changed recently, following script can be used to check recently modified stored procedure.…
Read More

SQL SERVER – Result of EXP (Exponential) to the POWER of PI – Functions Explained

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts
SQL Server can do some intense Mathematical calculations. Following are three very basic and very necessary functions. All the three function does not need explanation. I will not introduce their definition but will demonstrate the usage of function. SELECT PI() GO SELECT POWER(2,5) GO SELECT POWER(8,-2) GO SELECT EXP(99) GO…
Read More

SQL SERVER – FIX : Error : msg 8115, Level 16, State 2, Line 2 – Arithmetic overflow error converting expression to data type

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Error Messages
Following errors can happen when any field in the database is attempted to insert or update larger data of the same type or other data type. Msg 8115, LEVEL 16, State 2, Line 2 Arithmetic overflow error converting expression TO data type <ANY DataType> Example is if integer 111111 is…
Read More