You could run a query using sp_who2 to see who's connected. You can also click on the Activity Monitor icon, which will open the activity monitor and show who's connected.

You...

Gail has explained, at length, many of the behaviors of COUNT(*) over at her blog[/url]. In a nutshell, SQL Server is smart enough to figure out which index, table, statistic,...

Main stream support for 2000 ends in June of next year, 2010. Which, is less than a year away... Yikes!

I'd suspect pretty strongly you're getting blocking. If you have a blocking script, I'd run it (if not search for one in the SSC scripts over on the left), or...

Assuming a reasonable distribution of data, I would have expected to see a seek on this...

You're only accessing a few columns on the Pupil table, you might try using...

Whew! That makes me feel better. I'm digging through this trying to spot something. I figured you were going...

Thanks. I'm glad the book was useful. Post a review on Amazon!

😀

As to this, it does look like the statistics are up to date. I'm not sure what's happening precisely....

There's only been a few posts this weekend. 4-6 at most.

I can't see the .sqlplan file. Can you post it again?

It sounds like you might be seeing parameter sniffing.

Yes, the Profiler gui is great for browsing already captured data, but it is a dangerous place to try to capture original data. Here's an explanation of why[/url].

MAX works well in that situation, but depending on your indexes, TOP 1 with an ORDER BY can work consistently better. You might try that too.

Another option as opposed to traveling to your training is to bring a trainer to you. My company has worked for several years with Solid Quality Mentors. They have some...

And, if you're backing up a production system, if that system is using differential backups, you should backup using the COPY ONLY option so that you're not interferring with the...

erictyrrell (7/17/2009)

---

Often times tables will contain common columns such as People and Events both have columns for location (latitude, longitude) or a photo (blob column). Is it best to leave...

GilaMonster (7/20/2009)

---

Nope, not at all.

Some people want to be spoon-fed and not have to (horror) actually...