Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
Friday, 10 May 2019

Strange behavior on JSON_VALUE when table contains blank and non-blank values (JSON text is not properly formatted. Unexpected character '.' is found at position 0.)

›
Few days back we had a requirement to search whether a certain value exists in one of the table fields where the values are stored as JSON ...
6 comments:
Monday, 10 September 2018

Applying database principal through out the server (for all databases) for a particular user

›
Ever come across a requirement which you required to give db_datareader access to a specific user across all the databases on a particular S...
Friday, 6 July 2018

Replacing sp_depends with sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities

›
sp_depends have been one of the most used system stored procedures in SQL Server. Infact many of us still use that even though Microsoft had...
Wednesday, 30 May 2018

Computed columns in SQL Server

›
Computed columns are type of columns which the values are derived based on one or more other columns. Hence the data type on the computed c...
Tuesday, 20 March 2018

Data Encryption in SQL Server using T-SQL Functions (ENCRYPTBYPASSPHRASE, DECRYPTBYPASSPHRASE & HASHBYTES)

›
Decade ago data was just an entity which helped business to operate smoothly. By then data was considered as some sort of business related i...
1 comment:
Saturday, 10 March 2018

Strange behaviour converting NVARCHAR(MAX) to BINARY

›
Few days back I was writing a CLR function to be used for hashing string values. The only option was the CLR functions since T-SQL doesn’t h...
1 comment:
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...
Sunday, 9 October 2016

Understanding JOINs in SQL Server

›
During my work I get the chance reviewing lots of T-SQL Procedures and Views and I often see that the SQL joins are mis-used in them. When 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...