Showing posts with label SQL 2012. Show all posts
Showing posts with label SQL 2012. Show all posts
Sunday, 3 December 2017

Behaviour of IDENTITY Columns and SEQUENCES with TRANSACTIONS

›
Few days back, I was caught in a discussion with couple of my colleagues, regarding a problem they are facing with an IDENTITY column. The i...
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...
Tuesday, 16 February 2016

Index REBUILD vs. REORGANIZE in SQL SERVER

›
Couple of days back there was an interesting statement (or rather a question) was brought up by one of the colleagues in the company. Ultima...
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 ...
Wednesday, 3 June 2015

Error occurs when CTE Alias is ‘RESULT’ - Incorrect syntax near 'RESULT'

›
Few days back one of my colleague ran into a very strange issue when he was asked to do an alteration to an existing procedure. The procedur...