Unfortunately - yes. I think you're asking for the cake, the cake PAN, and the cake knife, all of which would have to be edible:)

Reporting services is not the...

Keep...

Keep in mind that you're not "in Access". The objects for the ADP are SQL...

Instead of clustering, you might care to look at database partitioning, and/or Federated databases. Those are more performance-oriented concept for scaling out on databases.

That being said - 10M rows...

Why not use an INSTEAD OF TRIGGER? That way, you can validate the data, and if it PASSES, then you actually insert the data. If it doesn't then...

Sunshine -

ditch the ~. That's an instruction telling DTSrun that you're passing an encrypted/hex value for a parameter. Plain-text parameters should be passed without the ~.

Michael Valentine Jones (5/8/2008)

---

So how long will it be before Homeland Security requires all air travelers to have an RFID in their ear?

http://www.sciam.com/article.cfm?id=rfid-power

"Now Hitachi, the maker of that chip, is...

I guess I find myself weird in the OTHER direction:). I have yet to go for the certs, but I...

You could simply go

Delete from Mytable

It doesn't have the same limitations as TRUNCATE TABLE, although you will have to empty the tables in the "right order" (delete the rows from...

I think the only one that has differences in the client tools is the Express Edition (which has a customized version of SSMS). Otherwise - I believe the tools...

leonp (5/8/2008)

---

I am inclined to believe so too .. Is there any reason why the sql server will be responsible for this slowdown? I want to make sure we (SQL...

Marios Philippopoulos (5/8/2008)

---

I'm running a resource-intensive job.

I've noticed in the sp_who2 output that multiple threads/rows (10 or more) are spawned for that same SPID (most of those threads are sleeping).

What...

The actual shape of...

Charles Kincaid (5/8/2008)

---

I want to take a shot at heading off the folks who are going to bi... er .. complain about RFID being invasive to personal privacy. Right...

7. Table-valued functions return table VARIABLES, which don't generate statistics in the same way "regular" tables (even temporary ones) do (a single primary key index is possible, although damn near...