venoym (6/14/2012)Then we are assuming that the author didn't intend to test us the default of the Primary Key?

From the description, emphasis mine. If you want a technicality, both...

Thanks, everyone, for the feedback! Both the compliments and the constructive feedback are all very welcome.

venoym (6/14/2012)

---

If I may. I answered Clustered. The reason is that I was...

Thanks for the question, Ron. And thanks Koen for the extra link.

In case someone is wondering why the different data types have no effect - Ron included the relevant link,...

Jonathan AC Roberts (6/1/2012)

---

Hugo Kornelis (6/1/2012)

---

Jonathan AC Roberts (6/1/2012)

---

I didn't realise that, I thought it was open source and anyone could use it.

Where does it say that you can't...

Here:...

michael vessey (6/1/2012)

---

+1 hugo

it's also a complete re-hash of an article posted 30 days ago

http://www.sqlservercentral.com/articles/MySQL/88971/

both referencing the website convert-in.com

perhaps they should pay for an advert rather than posting articles with...

Jonathan AC Roberts (6/1/2012)

---

IceDread (6/1/2012)

---

I see no valid reason to why you'd want to do this.

If you want to go from MS Sql server, you certainly do not want to...

I don't really like this article, as a lot of the tips are lacking background information or giving less than optimal advise.

Note that I have no hands-on experience with MySQL;...

SQL Kiwi (5/31/2012)

---

I understand this behaviour, really I do, but it will never be fully intuitive; especially since SQL Server has such bizarre rules concerning which errors do what (terminate...

george sibbald (5/31/2012)

---

I think we should clarify that you should not remove a service pack simply by replacing the resource database with a previous version of it. I'm sure there...

Nakul Vachhrajani (5/30/2012)

---

It is my understanding that the service packs/upgrades have the potential to modify all databases on the SQL Server instance, therefore, simply replacing the resource database to rollback...

Good question! One minor nag (isn't there always one?) - I don't like the wording "System objects such as sys.objects are physically persisted in the Resource database" (and yes, I...

John Mitchell-245523 (5/30/2012)

---

Hugo Kornelis (5/30/2012)

---

I am not. I prefer to be able to handle my errors myself; SET XACT_ABORT ON does not allow that; it thrusts one standard error handling...

Replace the COMMIT with ROLLBACK - sufficient proof...

davoscollective (5/29/2012)

---

I'm not sure if a page at simple-talk from 2006 qualifies as a good reference, although BOL has its fair share of errors anyway so probably not worth worrying...