Katherine Fraser (7/30/2010)

---

I work at a company whose clients include pharmacies so several of our applications store PHI (protected health information) and must be "treated with special care" according to...

philcart (7/29/2010)

---

Would have thought that this is part of an investigation/monitoring phase. Once you've identified a query that needs attention, you run though the great list provided by Brian.

It's amazing...

I didn't see a very important one:

Pull up SQL Server Profiler, and watch the SQL:BatchCompleted and/or RPC:Completed numbers for CPU, Reads, Writes, and Duration. Know which is most important...

'Will definately use more resources', as everyone else has said, is just wrong. CPU resources? Disk resources? Bandwidth, memory, or network resources? At design time, at...

+1 to SQLIO, but without a fuller understanding of the true physical level, it's insufficient.

Forgive me if I missed it, but I didn't see any information at all on the...

It's also not that easy; personally, I'd look at the MB/s throughput as well. The IO queue can be as high as it likes; if you're getting a throughput...

Joe Celko (7/12/2010)

---

Both of these are VERY weak. Look up

Levenshtein distance

Metaphone

Daitch-Mokotoff

WagnerFischer

and always check out

http://en.wikipedia.org/wiki/Soundex%5B/quote%5D

+1 - Soundex is, for all business intents and purposes...

Very seriously, you should contact the appropriate Accounting or Finance group or person; taxation can get very complex, and governments get... upset... when it's not paid properly.

Note that rates change;...

Are the Register to tax relationships based on something like Register Region (or perhaps based on Country, Smaller Region, Even Smaller Region, Tiny Region, Little Tiny Region, and so on?...

jay holovacs (7/7/2010)

---

TravisDBA (7/6/2010)

---

Thanks, but I already know about backing up a encrypted database with compression has no effect on the compression, and that is in BOL, hence my first...

As far as convenience, that's a personal and organizational preference.

As far as performance, benchmark all three kinds of functions, pure repeated inline code, stored procedures returning a row, stored procedures...

niall.baird (6/30/2010)

---

Ah yes, but you can set sql refactor up to format however you like. Mine is set to leading commas, 'on' clauses on a separate line, 2 spaces...

First: ensure that the developers, and the tools they use, are generating SQL that uses explicit parameters/bind variables/.CreateParameter, and are not concatenating variables into a string, regardless of whether they're...

Can the "Yesterday's question" and associated answer be edited prior to it being sent out?

The benefits and challenges are all very similar to timesharing a mainframe; replace "timesharing" with "scaling usage" and "mainframe" with "cloud of x86 hardware".

Challenges include, as others have mentioned

Regulatory compliance

Security

Mass...