WAL (3/29/2015)

---

stacylaray (3/25/2015)

---

This is not supported as the code is updating the replication metadata tables. If the distributor server name changes from S1 to S2, the only supported way is...

Agreed - and cynicism that, I believe,...

GilaMonster (5/7/2014)

---

humbleDBA (5/7/2014)

---

but there are enough myths and misconceptions in the SQL Server community...with 'incremental' being one I've heard before (in relation to backups) and they are not, they are...

Wow :w00t: ...missed this set of guides. At first glance, looks great - and I've used Starwind's...

GilaMonster (5/7/2014)

---

humbleDBA (5/7/2014)

---

Ok, I'd hate to think I've missed something with regard to SQL Server, but my understanding is that there is no such thing as 'Incremental' backups, as in...

I've since found the following...

sqlservercentral - licensing-sql-server-devtest-environments[/url]

...and...

directionsonmicrosoft.com - licensing-sql-server-development-and-test

...and all I can say is YUCK! MS you SUCK! :crazy:

If I have a SQL2008 R2 Standard Ed, clustered, in...

I guess my question is why do you have to down-grade if this is a Test box?

My understanding is that you licence Production Servers and as part of your systems...

Ok, I'd hate to think I've missed something...

Ok, that's proof - tho I rarely come across the ia64 version. Thanks for clarification.

david.dartnell (4/27/2014)

---

Yes, definitely the Enterprise Edition (x64)! I am a part time student and got my hands on the EE through Microsoft DreamSpark. I wanted to make sure that I...

https://www.simple-talk.com/sql/database-administration/the-sql-server-sqliosim-utility/[/url]

http://www.brentozar.com/archive/2012/06/load-test-sqlserver/[/url]

Also, look for Dell's DVDStore tool. It can be a bit fiddly to set up but I found it good to simulate different workloads on different size databases.

Sure I can...

yuvipoy (4/25/2014)

---

Is it a good practise to have my tables in different files.

Say i am having 10 master tables.

Can i create tables each one on 10 secondary files(.ndf) in a...

Hi David,

I was hoping you would come back on this and confirm if you managed to install the SQL2008 R2 Enterprise Database Engine on your Windows 7 OS-based PC.

If this...

My opinion...

I agree with Mike John, patrickmcginnis59 10839, andrew gothard, Jeff Moden.

Just my opinion 😀

OK, I'm confused here. The yt vid shows the person installing SQL 2008 R2 Developer ed, which is possible as Developer ed can be installed on a wide variety of...