Using With(Nolock) can improve performance, at the cost of reliability and integrity.

The question to ask on that one is: If you were a manager, and had an employee who was...

Yes, Andre, what you posted seems okay. It's bordering on being a commercial, but I don't think it crosses the line.

If I were building a doc management system, I'd...

Personally, I've never seen any value to prefixing objects with their type. Lots of people use that practice, but I've never yet run into a situation where it actually...

If it were running something like Windows 95, I'd agree that frequent reboots are a good idea.

Anything on the NT kernel really doesn't need that.

Gianluca Sartori (10/21/2009)

---

GSquared (10/21/2009)

---

The Not Exists correlated sub-query will almost certainly end up with the same execution plan as the Left Outer Join. At least, that's what I've seen...

Get rid of the whole loop and use the Row_Number() function. Partition by PlantID and you'll have a numeric sequence for each plant ID.

Since ERP data is generally pretty crucial, I'd be inclined towards daily full backups and hourly or half-hourly log backups. Set that up in scheduled jobs in SQL Agent,...

I'm not familiar with doing this in ActiveX scripts, but in T-SQL's XQuery, I'm used to seeing nulls if I've got a mismatch in the column definition, or if I...

Check OpenDatasource in BOL.

You can schedule jobs in SQL Server by using SQL Agent. You can set a variety of intervals and rules on the jobs, and they can be multiple or...

Timex-Sinclair 1000

*Difference between delete and truncate

One starts with a "d" the other with a "t", and then the rest of the letters

*What is identity column?

It's where they check your age when...

There are a bunch of good discussions on this site about starting out as a DBA. Try searching for a few of those, they'll definitely help.

The best first point...

Silverfox (10/21/2009)

---

GSquared (10/21/2009)

---

Well, that certainly gives a good interview question to ask. We've evolved it to, "You have a database with a corrupted or lost page, and the backup chain...

Define a variable with type "bit" and assign the value to that. That's what I do.