Understanding Lockings in SQL Server

  Locking optimizer hints SQL Server 7.0/2000 supports the following Locking optimizer hints: NOLOCK HOLDLOCK UPDLOCK TABLOCK PAGLOCK TABLOCKX READCOMMITTED READUNCOMMITTED REPEATABLEREAD SERIALIZABLE READPAST ROWLOCK NOLOCK is also known as "dirty reads". This option directs SQL Server not to issue shared locks and not to honor exclusive...

0

Working with Batch or Command Files

Using batch files as a deployment scriptsBatch files or Command [.cmd] files are still used for deployment purpose in many organizations.Batch files are simple text files containing some lines with commands that get executed in sequence, one after the other. These files have the special extension BAT or CMD. Files of this type are recognized...

0

TSQL Queries Search for SQL Objects

Frequently used SQL Queries   There are many SQL Queries which are used frequently as a part of our SDLC, I am trying to consolidate all and keep at one place. Hope this helps! Search for a tablename in all SQL Objects: There are different ways of searching for a text in all SQL Objects, below are few methods: SELECT Name FROM sys.procedures ...

1

Could not load file or assembly '' or one of its dependencies. An attempt was made to load the program with an incorrect format.

      Could not load file or assembly '' or one of its dependencies. An attempt was made to load the program with an incorrect format. If you have any VC++ CLI components in your azure web role and you are facing the above error, then this post might be helpful for you to resolve your issue.   One of the most common...

1

You receive an “Explicit value must be specified for identity column” error message when you use the replication feature to run an INSERT statement on a table in SQL Server

If you are facing this error "You receive an “Explicit value must be specified for identity column” error message when you use the replication feature to run an INSERT statement on a table in SQL Server" when you are running transaction replications, here is the reason behind this. You are trying to insert a row in the secondary server where...

0

Identify Missing Sequence Numbers SQL Server

There are many scenarios where we may in need to identify the missing numbers in the provided range. Here is the quick query which help in identifying using CTE [Common Table Expression]: DECLARE @Test TABLE ( Num INT ) INSERT INTO @Test VALUES (1) INSERT INTO @Test VALUES (2) INSERT INTO @Test VALUES (4) INSERT INTO @Test VALUES...

0

Content within this application coming from the website listed is being blocked by internet explorer

This error seems like problem with Internet Explorer, but you will be getting this error due to the setting in the Outlook in most of the cases. To over come this error, you need to change the People Pane setting in the outlook. Follow the below steps: 1. Open outlook. 2. Goto to the View tab 3. Click on the People Pane and make it "Off". This...

0