Now that's just malicious and nasty. ... this is just vandalism. It serves no purpose. It's likely no one even knows it was "M@M@sB0Y" or some other hacker,...

Thanks for the reply.

I did set up a couple for testing, and since we have the Standard edition, I set up some queries with the hints. They worked great,...

Question:

I see the Pros of creating Indexed Views, but what are the Cons? Seems I read somewhere that the materialized view has to exist somewhere. Is that in...

Thanks for the tip! I am...

Thank you for...

Andrey (2/12/2009)

---

When floating ice melts, does the water level rise?

Water expands when it freezes, so you might think that when it melts and reduces in size, the water level will...

Sadly, I don't think we can "fix" the problem as long as there are people who choose to act dishonestly. Maybe the best we can do is to do...

Lynn Pettis (1/28/2009)

---

68% of both boys and girls surveyed admitted to cheating on tests in school.

56% of the boys and 45% of the girls felt that cheating is required to...

Lynn Pettis (1/28/2009)

---

68% of both boys and girls surveyed admitted to cheating on tests in school.

56% of the boys and 45% of the girls felt that cheating is required to...

R L Reid (1/28/2009)

---

. . . If I Google on a subject I know a great deal about, I will often find that 90% of the articles are largely...

Andy Leonard (1/20/2009)

---

Enterprise metadata is important. Unfortunately, you learn that (or you will) when something goes wrong. I wrote about using SSIS to collect enterprise metadata at http://sqlblog.com/blogs/andy_leonard/archive/2008/08/28/ssis-design-pattern-collect-enterprise-sql-server-database-metadata-with-ssis.aspx. That article...

I decided I wanted the Prevalence to be the percentage of all tables not of all columns, so I used James Goodwin's code and modified it to get the total...

Ha! Just last Friday, I discovered I could not define a foreign key because the datatype was different between two tables. The first thing on my To-Do list...

As much as I love to travel, my husband loves to travel even more. He has been talking for years about selling the house and just living in various...

I LOVE traveling. In 2003, I had...