A deployment matrix could mean many different things and even when in the same context it could mean different things to different people. To my knowledge it's not a standard...

It will create fragmentation as well but the severity can be greatly reduced if your autogrow settings are sensibly set. The serious problems with physical fragmentation arrive when you have...

Thanks for posting your experience. I am sure it will be useful for someone.

happenchance

Too subjective, really. I was lucky to have guessed correctly. More details were required to make an informed decision. Where was the "It depends" option? 😛

BIDS from the Express Edition media is just one variation of a program built on the Visual Studio Shell. Beyond that you are just adding Project Templates to your machine...

escargot

fearless

If I had to pick a poison I would implement a SQLCLR method (of my own) before I would use xp_cmdshell for this. That said, at the end of the...

jeetsingh.cs (1/22/2013)

---

To set the value of the next ID to be 1000, I can use this command:

DBCC CHECKIDENT (orders, RESEED, 999)

Note that the next value will be whatever you reseed...

Jpotucek (1/22/2013)

---

We are looking at Standing up a new SQL Server 2012 Enterprise Edition Standalone install as part of a Proof of Technology test for a new product.

Can someone...

You're quite welcome. Thanks for posting back.

I thought of that too, but it's SQL 2005.

I guess I do not understand what is wrong with Books Online.

M_E_K (1/22/2013)

---

Hi opc.three,

Thanks for the feedback so far. Really appreciate your time.

Actual execution plan of a currently running query is what I'm looking to get, I'll take a look...