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...

Books online has good info on both. Or, if you don't have books online, the online technet library

Join fundamentals: http://technet.microsoft.com/en-us/library/ms191517.aspx

Union: http://technet.microsoft.com/en-us/library/ms180026.aspx

Hot add memory? Don't think it should.

Did you change the SQL Server's max and min memory after doing that?

Stored procedures. DLinq is just more ad-hoc SQL code that I can't tweak to swell my proc cache.

From what little I know about Linq, I'd prefer to use stored procs...

Another vote for perfmon and profiler. Add in reporting services and a cuople of jobs and you can have a very nice automated data collection and reporting. You'll still need...