Technical Guru (goor-oo, goo-roo)- A person who reads the manual. :w00t:

Jack Corbett (8/6/2010)

---

I agree that there is a place for Access, but the issue is that typically Access databases become mission critical and IT doesn't even know about it until...

A marshmallow-like lump of sugar shaped into a peanut shape.

Here are links to some images.

Wikipedia

Google Images

DBCC INPUTBUFFER is such a limited command and doesn't give the full...

You're not running the rebuilds during the day or while other tasks...

The first thing I notice is that your SELECT statement and your error message don't use the same temp table name. Is this how it is in your code? Or...

In a total change of topic.

Out of the blue this a.m., I suddenly wanted Circus Peanuts. So, what is the one candy that you want right now?

Really? How odd. I wonder if the forum is blocked from your internet connection.

The actual link is here http://forums.asp.net/t/951690.aspx.

If you still can't see it, the advice is:

Login into SQL Server...

I'm curious. What recovery mode is your database in? FULL or Bulk-Logged?

If it's in FULL and you have a bunch of Bulk Inserts for your data, that could be the...

free_mascot (8/4/2010)

---

Andreea

I would like to drow your attention that when you restart the server tempdb will shrink and when the space is required it has to expand. Now expanding the...

Your comments make me wonder who it is that's saying you're too old for this. Are they peers of yours? Are they older? Or are they the "younger men" who...

If I'm understanding your question correctly, all Service Packs have previous fixes inclusive up to the current version #. So if you've never installed SP1 or SP2, you should be...

Have you tried looking it up in Books Online?

Here's a link with a similar issue. Does it help?

One thing I'm suddenly confused about. 1) Why is a performance issue question in the Security forum?

Back to the point, Doesn't the data being in different places, pointers or...