Just to pile on a bit, I find the DTA to be very problematic. I've given it substantial loads to see what it will do and it misses very obvious...

You have two things going on. First, you have data in the database. The more data, the bigger the files. To make the testing system smaller, remove unused data.

Second, as...

avhlasith (1/26/2009)

---

Hi all,

i need to use SQL lock into my sql quaries. but im not familiar with SQL lock if you can tell how i use it and...

Using COALESCE or ISNULL in the WHERE cluase usually prevents SQL Server from using an index on the query if one exists. Forcing the query to perform only table or...

Tweaking the disk, especially from RAID 10 to RAID 1, is only going to get you a marginal increase in performance. I'd concentrate on the queries, indexes (full text indexes...

Sure, it makes sense. It even works well a good percentage of the time. There's still that disconnect between Person & Employee that has to be documented and explained to...

Personally, I'd stick with RAID 10. The added safety is worth more than a small increase in speed.

You've collected performance data and the bottleneck is I/O and you've tuned the...

That's a very open ended question. I don't know what kind of work you need done.

I'd start them off writing TSQL queries so that they begin to understand how databases...

Yep, right there in the BOL. I had to look it up just to verify.

There are three ways you can do this easily. Use TOP, MAX or ROW_NUMBER. I'd recommend testing your system with TOP or ROW_NUMBER because, in my experience, MAX generally doesn't...

So did you try what I laid out in the post you put up yesterday?

http://www.sqlservercentral.com/Forums/Topic641528-149-1.aspx

If it didn't work, what went wrong?

timothyawiseman (1/22/2009)

---

I'll agree with Grant, though there are some cases where it makes sense to have a column named Id in the base table and then the foreign keys referencing...

We ask...

I'd want counts one those numbers too. Is the 254 an extreme outlier or just slightly high? I haven't run averages on my systems recently, but 20ms just for recompiles...

Instead of your usual high quality posts, put up a slip-shod one or two... you'll earn a pork chop.

:hehe: