Showing posts with label SQL 2008. Show all posts
Showing posts with label SQL 2008. Show all posts
Wednesday, 9 March 2016

String or binary data would be truncated / Arithmetic overflow error converting numeric to data type numeric – Workaround

›
  There’s nothing more annoying than getting the error ‘String or binary data would be truncated’ or ‘Arithmetic overflow error converting ...
Thursday, 3 March 2016

Extracting Date (Excluding Time) from a DateTime value in SQL Server

›
  SQL Server supports many data types where we can store the Date along with the time, such as DateTime SmallDateTime DateTimeOffset D...
Thursday, 19 November 2015

Capturing and Analyzing deadlocks in SQL Server

›
Technorati Tags: SQL Server , SQL Deadlocks , Capture SQL Server Deadlocks No matter how perfect your code and how optimized the way you ha...
Monday, 26 October 2015

Elevate permission on a SQL login having read only access to Execute Stored Procedures and to View Database Schemas

›
Due to an unavoidable situation, it was decided that all the write access to a particular server (SQL Server) was required to be removed imm...
Saturday, 17 October 2015

Elevate permission on a SQL login having read access to run the SQL Profiler

›
Sometime it’s necessary to allow SQL logins only to have read access to the respective SQL Servers. But it becomes a necessity to allow the ...
Monday, 5 November 2012

Create a Cursor using Dynamic SQL Query

›
Even though we are advised not to use or to minimize the usage of cursors in SQL, there are times which, it’s the only available option, dep...
4 comments: