Thanks for the feedback from everyone.:-)

I do not like GUI generated code.

I do not use...

Grant Fritchey (6/25/2014)

---

There are some minor improvements to code completion in the query window if that's the kind of thing you're looking for. They've also added some typing functionality that's...

Jack Corbett (6/25/2014)

---

I'd rebuild the indexes before I did a shrink as you might shrink below what you need for the rebuild and then the rebuild will take...

Sean Lange (6/25/2014)

---

Welsh Corgi (6/25/2014)

---

How much easier would it be for someone that uses the GUI to generate code using 2012 over 2008R2?

They tell me know that they do not...

How much easier would it be for someone that uses the GUI to generate code using 2012 over 2008R2?

They tell me know that they do not use the query designer...

Sean Lange (6/25/2014)

---

Faster coding would be achieved by not using the...

I ended up renaming the table and recreating it with the proper Indexes and loading the table.

Sorry for not providing better details.

After dropping...

ok, thanks.

I should have made a post earlier but I had a production issue.

I was able to Delete all Indexes and the Primary Key.

Now I'm having problems creating a Non...

How about when you create the Indexes, what order do you use?

I'm changing the primary key from CLUSTERED to Non-Clustered.

I'm going to create a Clustered Index on columns that are...

I dropped the Non Clustered Index and it is in a suspended State and a PAGEIOLATCH_EX Wait Type.

Percent Complete steady at zero percent.

No, I've been bad.:-)

Thanks.

I got myself in a bind.

I performed a rebuild of Indexes on all tables in a Database.

The Database grew in size from 406 GB to .9 TB.

I shank it as...

I made a Decision to rebuild indexes to reduce fragmentation.

I caused the Database to grow big time.

So I set all of the indexes gill factor to 100 percent.

The Database is...