Assume you have vendorid and vendorname:

AB Abner

A Babner

Because you're converting to varchar, these both collapse to

ABABNER, so they look the same, while they clearly...

I would suggest you also consider exactly how to meet the implicit requirement of "if the traces fail, SQL Server logins need to fail"; i.e. if your logging is down,...

Look up whether you're in a one person taping state or not (can you lawfully record a conversation you have a speaking part in without informing the other person, or...

A SAN is one thing; how the spindles are grouped is a completely different thing.

Are the backups sharing any of the same spindles (EMC Raidgroups) as the main...

rjv_rnjn (5/6/2010)

---

I re-read the MSDN article as to why I thought it's physical order of arrangement.

MSDN: http://msdn.microsoft.com/en-us/library/aa933131(SQL.80).aspx

Because the clustered index dictates the physical storage order of the data...

From what I'm hearing, that would mean that requests travel as follows, whether it's 2007 or 2010 using blobs or 2010 using Filestream:

Client sends a request to Sharepoint Server.

Sharepoint Server...

Mike C (4/19/2010)

---

Nadrek (4/19/2010)

---

Mike C (4/17/2010)

---

Not sure how you calculated the probability of collision at 2^40 off the top of your head... You can engineer an MD5 collision in...

Mike C (4/17/2010)

---

Not sure how you calculated the probability of collision at 2^40 off the top of your head... You can engineer an MD5 collision in 2^39 or less,...

Basically, you're choosing your long term maintenance strategy now.

Do you want to maintain .NET code as the .NET framework changes and is eventually replaced (as old VB6 and...

Basic setup:

SET STATISTICS PROFILE ON

(or your favorite execution plan viewing tool)

AND

Watch it in Profiler (Reads, CPU, Duration, Writes)

Have a sample of various execution steps just before the CREATE PROCEDURE, commented...

Mike C (4/14/2010)

---

For instance, you might explicitly convert an INT to a VARCHAR to concatenate it with a VARCHAR column, then HASHBYTES will still perform the implicit conversion...

A few comments with the underlying assumption that the desired result is a (potentially) more efficient method that is guaranteed to return the same results as the "long way".

For...

Did you know that...

Ivanna Noh (4/12/2010)

---

I've posted about this before, but it's relevant to this discussion too...

We have a mirrored database in production which is reindexed once a week - the reindexing causes...

For a question about NULL to make any sense, the context and/or the operational definition must be set.

NULL has different results in the same operations based on other settings, therefore,...