How much data are you moving?

Loading data into temp tables is one thing, but combining them in a view isn't the way to go. A copy of the data inside...

2. If you mean multiple threads, yes. It's the same as multiple people inserting at one time. If it's a large load, however, the parallelism may not help you. You...

Some very interesting quotes in the discussion:

My advice? If you want to work hard and do the best job you can, do so for your own satisfaction. Don't

do so for...

LOL, lots of Ps there.

There is some strange caching for performance. We use the InstantForum code in a fairly stock manner. We've added some hooks in there, but not a...

Virtual Box would be good, though I'd like articles with VPC and VMWare as well as guides.

It's not intermediate pages, it's that a rebuild of the index creates a duplicate index. Because it's transactional, it builds a new one, uses space (hence db growth) and then...

I didn't exclude matching, but I was thinking along the lines of lottery or ping pong balls. I only have a list of numbers, so if I have 1, 2,...

Was thinking...

Strictly curiosity

In Management Studio, Object Explorer, you have a Management folder. Click that, and in there is the "SQL Server Logs" folder.

There are also logs under SQL Server Agent.

GilaMonster (5/18/2011)

---

*screams*

When will people stop recommending Emergency mode repair as the default action with a suspect DB. That's about the 4th time I've seen that garbage this week.

Forget shrink database,...

Any ideas? It's for me, and not critical, but I found it interesting:

http://www.sqlservercentral.com/Forums/Topic1111177-392-1.aspx

Thanks for the update. I was thinking that it was an unwieldy amount of data for even small sets of data. 550B. Wow.

not yet

I've set up notifications, not just for objects, but also sp_configure changes and agent jobs, just to try and catch any "undocumented" changes.