http://www.sqlservercentral.com/scripts/Maintenance+and+Management/30922/

What is the error?

Do you have free space in the log or the data files? If the log, it might be that there are virtual log files within your log that are near...

1) The only effect is that the processor is shared among the instances.

2. Yes, the instances are serarate. They both have a master db, and they can both have a...

If you are looking for information on all tasks in SSIS, why not go to Books Online?

Easy to say all of it, but sometimes you need to make choices, especially with encryption. Doing the whole database can have a detrimental effect on performance.

You are not making sense in what you're describing.

Which user? The way you wrote it doesn't let me know what exactly you are doing. You need to provide more...

I have heard a few times that SQL Serer is really lacking. Yet is sells amazingly well and has met almost every need that I've ever had. Can it be...

You can set the identity to increment by 2. Then you can have it compute a column with the EMP and the numerical value. That will give you what you...

And post them here, call for votes. Those votes matter to the dev team.

I'd second Gail's suggestion of using an identity. It is easy to read and handles the concurrency.

You can use a GUID as well if you like, but those, IMHO, are...

I reinstalled Win 7 on my desktop and things appear to be working, so I'll likely be putting WHS on the old desktop in a week or so and I'll...

You can view the execution plan yourself in SSMS to see which indexes are used for the queries.

Read Gail's entries, and then test your queries. Look at the execution plans and see if the indexes are used.

You need to answer Brian's questions, but basically if you want to prevent someone from inserting,

- create a database role

- DENY insert on the table for the role

- add...

There are a few good presentations on MySpace. I bet their DBAs have an interesting job, but not much sleep.