What little I know of SQL Memory Allocation is this:

1) SQL tries to steal as much memory as possible from the operating system. If you don't throttle it in some...

There are a lot third party tools for sale that will monitor multiple servers, also. I believe both Imceda and Red Gate have software, along with several other companies.

Otherwise, as...

You can kill the process by using the KILL <SPID> command. And do what Pradeep suggested. Look at the command in a command line utility to make sure what sorts...

1) How do you know it's not returning all records? (I'll explain why I asked as soon as you answer.)

2) Production database or dev database?

3) What security settings do you...

Once you've read the suggested material, if you still have questions, post the part of the...

I believe SQL uses the same logic as it uses for Excel worksheets. It checks the first 10 rows of data and assigns nullability (as well as data type) based...

I would go with John's suggestion with one suggestion. If you are using a third party backup & restore tool, like Litespeed, you can do object restores. Which means you...

Can you add another file to your transaction log on a different drive and make it the Primary? Given enough space, trying to shrink your database or your data file...

EDIT: Erasing what I just said because it's not related to the question. DOH.

If your growth occurs at a certain point in the day, can't you use profiler to identify...

Craig Farrell (3/15/2011)

---

Folks, if you ever get the chance to let Brandie do a review of one of your pieces, do so. I'm afraid to see what she'd do...

Omens

Also glad you got it working and thanks for posting the solution. That will help others with the same problems.

GSquared (3/15/2011)

---

Brandie Tarvin (3/11/2011)

---

Now that's an interesting solution I never would have thought of.

But Parsename() only works because it's treating the IPAddress as a Server.Database.Schema.Object item (because of the...

Wow. Just finished beta-reading for Craig.

Wow.

Aren't you guys sad you can't see that article yet and jealous that I got to read it before you did! @=)

WOTD: Disaster