Lab Sql

I'm using LINQ, but my database tables do not have an IDENTITY column (although they are using … Read more Linq Inserts Without Identity Column

My two questions are: Can I use clustered indexes to speed up bulk inserts in big tables? Can I th… Read more Clustered Indexes On Non-identity Columns To Speed Up Bulk Inserts?

How can I reset my IDENTITY column in my already populated table? I tried something like this, but … Read more How Can I Reset Identity Column Of My Table In Sql Server?

I am using LINQ to SQL to insert simple data into a table WITHOUT a stored procedure. The table ha… Read more Linq To Sql - How To Find The Value Of The Identity Column After Insertonsubmit()

My question is if I have two batch inserts into one table in parallel, how does SQL Server create i… Read more How Does SQL Server Generate Values In An Identity Column?

How can I reset my IDENTITY column in my already populated table? I tried something like this, but … Read more How Can I Reset IDENTITY Column Of My Table In SQL Server?