I'm not sure what DEcode does. From what you said, perhaps REPLACE?

Firstly, I will suggest that you read Books Online (SQL help file) as there's a lot of very good info in there.

Foreign keys are used to enforce referential integrity between...

Blocking will eventually resolve itself. A deadlock, however, will never clear up by itself. That's why SQL Server has a deadlock monitor that, when it finds a deadlock, will roll...

Jenny Zhou (1/16/2008)

---

Most of them don't, I guess that's probably the reason; but I saw t-sqls which do not do inserts, updates or deletes and they still have 35 Writes...

Ah. That's useful to know. I was assuming it was a straight join between two...

There are three certs that you may be interested in. There's the Technical Specialist SQL 2005. It's a single exam. Then there's the IT Professional: Database administrator and IT...

You said that

http://computername/HRHSKeyContact/HRHSKeyContact.aspx

works, but

http://computername/HRHSKeyContact/HRHSKeyContact.aspx?hid=2

doesn't.

If you look at the aspx page, what's done differently if the querystring is passed, compared to not passed. Can you post the relevant portions of...

Try UNPIVOT.

Pivot is for turning values into column headers, unpivot is for turning column names into values.

Edit: Beaten to it. 😀

There are examples in books online. The main thing...

Unless you have a column that stores the date inserted, or an audit trail that records data changes and dates, there is no way to identify when records were inserted...

A full backup cntains the trans log info, but it does not truncate inactive portions of the log. Only a log backup does that.

Each time a transaction log backup occurs,...

32 bit? 64 bit?

What about the other perfmon counters? Are you seeing higher than normal disk usage or disk times? More transactions/sec than normal? More logins/sec than normal?

Also look...

Rebuild the indexes on the tables involved, see if that makes a difference. If not, please save the two estimated plans (as .sqlplan), zip them and attach to a post...

What did the perfmon counters show?

Did profiler pick up any queries with unusually high CPU values?

What's your server spec? 64bit? How much memory?

You can use profiler to identfy the poorly performing queries.

Once you've identified them, you can optimise the queries (if they're written badly) or tune the indexes (if the queries...

Then it would not have been the cause.

A cache flush message happend when some operation, while SQL is running, forced the cache to be emptied.

If none of your databases are...