Category: SQL Server

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 …

Parallel.For vs BackgroundWorker Read More »

Tagged with: , , ,

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 …

How to create an Autonumber field in SQL Server 2012 Read More »

Tagged with: , , ,

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 …

Make changes to SQL Server without dropping and recreating table Read More »

Tagged with: , , , ,