Have a good resume on the web :w00t:

That's a great point, and I have no idea. Guess stuff is gone. However with the volume I have around here, none of...

RAID isn't a substitute for backup, and I didn't mean to imply that. I was curious how many people wanted to deal with that at home, monitoring failed drives, etc.

My...

You'd have to provide more information about what you mean. If you can show a few tables and some sample data, showing how it's inserted, we can help you.

The thing...

I do agree that often things aren't "new" in terms of a revolutionary idea. But I do see things repackaged in new ways, which can make them much easier to...

You might need to if the tables in the article might have changed.

When you set up the subscriber, it ought to ask to initialize the subscriber.

You are welcome, and please feel free to ask more questions. If you find specific items, be sure to track the code and DDL for the tables if you post...

It doesn't seem like you have a lot of free space in there. 59GB data with 65GB data file. You want to keep free space in your database to allow...

Did you apply a snapshop to initialize the new subscriber?

Yes, you can get more info by using trace/profiler to grab the data of what is happening with these spids at that time.

http://www.sqlservercentral.com/articles/deadlock/65658/

http://www.sqlservercentral.com/articles/deadlock/65614/

Read this: http://msdn.microsoft.com/en-us/library/ms187445.aspx

However the big factor is how much growth you are going to have from new data. If you have no idea what load you'll have, however people will...

I tend to agree with Jason here. What you do on your time off, really isn't the business of your employer, provided you are not representing them. You shouldn't...

What you probably want to do is combine this logic into your select. As you look to insert data, add the "logic" check into the WHERE clause.

insert TransferTable

select Product, AmountToReorder

...

I'm not a big Access guy, so I'm not sure what you do there. You need to be able to open it. I might open Access and then see if...

These folders are where the error log files are stored for SQL Server. What you can do is check how many you have and decide if you can delete old...

The Access upsizing wizard should move the data. That's what I'd do, that way things will continue to work as they are. I'd use this as a backup, and then...