Jeff Moden (6/21/2008)

---

Matt Miller (6/21/2008)

---

I'm looking at this now - and I'm not so sure at all about this. I don't get the same results out of Count(*) as...

Jeff Moden (6/20/2008)

---

And, apparently, another myth dies...

The old myth was that COUNT(*) and SELECT * performed better than anything else because it would look for the best index to use....

GSquared (6/20/2008)

---

I just did a test on a 1-million row table with 7 columns of random data (Jeff's usual test table).

Without an index on the column I had in the...

hmm...looks to me that someone is storing 'null' as a string, and not NULL (the lack of value or the undefined state that is NULL).

GSquared (6/20/2008)

---

Select count(0) doesn't have to get any column metadata. Select count(*) does have to gather column names. It's a very minor difference and won't matter in almost...

No - it sounds like profiler is fine - you just have to find which row actually talks about the UPDATE operation you're trying to perform. Might not be...

That's a SELECT. The message is about an UPDATE operation. You don't think you're looking at the right operation.

Well - the error message is implying that whatever the new value for em_ID is. - it doesn't exist in the employee table. Meaning - the employeeID doesn't exist...

You may be able to do something with the Default trace. The default trace tracks schema changes (it's the basis for the Schema Change History report, which might also...

I'd pick a good time, and grow the files myself. In other words - don't wait for it to auto-grow. auto-grow usually happens at the worse possible time...

Mauri (6/20/2008)

---

Thanks a lot for your answer,

The recovery model is the FULL one, and you are right I should think about changing the backup planning, so I am going to...

Automation-wise - it might be easiest to allow them to pick one date (say - the startdate), and an integer replresenting the day of the other "side", and set up...

You can get there using a variety of methods. The first one that comes to mind would be to go read up on Common Table Expressions, which kind of...

You haven't supplied a critical piece of info to fully answer your question (your recovery model). that being said, given your scenario, it sounds like your transaction log needs...

and don't forget the hardest of them all:

How do you spell SSRS?