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

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

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

Tagged with: , , , ,
Top