Category: SQL Server

Parallel.For vs BackgroundWorker

A number of jobs I get are fairly processor intensive so I decided to take a look at .Net’s new Parallel library, wondering how performant it’d be in my (not necessarly your) environment. Implementation is fairly straightforward, with a minor

Tagged with: , , ,

How to create an Autonumber field in SQL Server 2012

Same as it was in the last version. The task can either be performed through the Server Management Studio designer to code In the designer, select the field ensure it’s an int Set the Column Properties as IsIdentity   Or

Tagged with: , , ,

Make changes to SQL Server without dropping and recreating table

Allowing SQL Server to accept changes to tables through the designer is not recommended. Use Transact-SQL statements to make the changes to the metadata structure of a table. I you must: To change the Prevent saving changes that require the

Tagged with: , , , ,