jude.pieries (7/8/2010)

---

Using XML as a input parameter

-I wouldn’t use a XML as a input parameter to update a table; mainly to avoid the XML reader operation.

-This approach will...

There extended so there married to languages that may not want to continue along into future releases.

Boo Birds are out for the posters bashing the author's article being to simplistic. We have to remember as SQL keeps stealing marketshare there are thousands of new DBA's...

What are the deltas between qa and prod? (Proc, data, views)?

Native + 3rd party compression meets every requirement a DR scenario can present. SQL 2008 also now includes the compression, unsure how well it performs compared to red gate or...

Index scans will never scale, performance will always be directly related to table size, and there is no way I have found not to scan when using forward and backwards...

From the article:

The builtin\administrators account has been removed for security reasons

??

I really do not think you can make a blanket call about this question with out knowing how the application will touch the entity. If you know your going...

Automatic kill can be a death sentence especially when the rollback kicks in. I would personally go a different route to figure out why this spid is staying...

Watch updating stats right after an index rebuild. An index rebuild looks at all the data to create statistics, where as the update stats out of the box uses...

I still do not understand how you can use integrated security to connect to an instance that the user your logged into the machine with does not have permission to?...

Nice content author, keep up the good work.

Would like to bring up a dissenting opinion though. I struggle with the auto creation of indexes. I have used the...

Great stuff here, good work!!!

Mike C (7/4/2009)

---

If you're...

tymberwyld (7/3/2009)

---

I don't see how performance could be improved by using an application solution. SQL is already set-based as can insert, update, and delete anything from the Xml you...