Two possible answers, both will work:

TOP

ROW_NUMBER

DBA just doesn't really have "entry level" positions as such. Most of the people I know that are DBA's came out of a different discipline, usually development or systems. So...

Good or bad, as long as stuff isn't plagiarized.

In my experience, it depends on the number of rows. Opening XML is somewhat expensive inside SQL Server. I've found that if I'm moving fewer than ~100 rows (and yes,...

Risking a pork chop, I'm going to disagree with Jeff on this.

You should look at option 1, but as was mentioned before, create a schema for the views. Also, I'd...

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