Looks like a missing comma (,) after OtherTotal.

Which one you use (Simple or Full recovery mode) depends on your restore requirements. Using simple recovery mode, you can only complete full or differential backups. Using the...

Except for maintenance plans, yes you need to use BIDS. BIDS is nothing more than Visual Studio, and yes it is on the installation disks for SQL Server 2005.

And...

Which is why you sometimes end up with tables or columns, or whatever object that doesn't meet your naming conventions. All you can try for is consistancy, and most...

I will agree with consistancy. Unfortunately, I have seen where one can be consistant, but still end up with some exceptions. I personally would try and stay away...

DBA_Rob had a good suggestion for the physical placement of data using PRIMARY, DATA, and INDEX file groups. I would add one more if the plan is to store...

I actually think we get more than the players. One, they get substitutions, we don't. Two, we usually do three or more games in a day, they usually...

I'll agree that the company shouldn't dictate what type of exercise an employee should do, that should be between the employee and his/her doctor. As Stephenie indicated each of...

Years ago when I was in the military, we were authorized four hours a week for PT. The fun part of that was what they counted as PT. ...

Government Bureaucracy is incapable of providing effect healthcare to its citizens. Just look at most of our federal agencies; they are bloated, inefficient, and self-promoting. If government wants...

""We the People of the United States, in Order to form a more perfect Union, establish Justice, insure domestic Tranquility, provide for the common defence, promote the general Welfare..." -...

Between the PeopleSoft Administrator and myself, we think it has to do with PeopleSoft Finance 8.9 and SQL Server 2005. We moved to SQL Server 2005 because of our...

We have some control over our PeopleSoft system, and have created some custom indexes ourselves. Usually I will script the indexes and provide that to our PeopleSoft administrator who...

3.TERMS SPECIFIC TO THE PER PROCESSOR LICENSE MODEL.

a.Licensing a Server. The manufacturer or installer has determined the...

In a per processor license mode, you only need one license for each physical processor, not for each core. With a quad core processor, you need only 1 per...