khata,

This is my Q4 '06 fun project.  I'm just getting started with figuring out how to do HA with reporting services.  I'm going to have it figured out by the...

Buy some equipment off of eBay.  The constraints don't say anything about adding USED hardware.

heh

Did your question have any context that suggested what type of capability you needed to increase...

Try running this sometime when there is no other load on your server

use [master]

go

select *

from

sysobjects so1,

sysobjects so2,

sysobjects so3,

sysobjects so4

option (maxdop 1)

This query should be (almost) all CPU and little...

You have 16 cpu cores.  I'm not sure how things get scheduled on dual-core CPUs, but I would guess that they behave much like 2 single core CPUs.  Your 7%...

Hi Rob,

I'd suggest that you set the transaction log to a proper size and back it up regularly.  If, for some reason, it grows beyond what you thought it should be,...

You can back up to local drives on a clustered system, by running the backups from T-SQL

BACKUP DATABASE msdb

To Disk = 'c:\backups\msdb.bak'

will work, but you must remember that the physical...

You certainly can back up mdf,ndf,ldf files directly.  It is somewhat complicated, however.

Contemplate the fact that SQL server will accept this backup command:

backup database model

to disk = 'c:\model.bak'

with snapshot

Now, "snapshot'...

For ODBC, you'll have to get a driver.  Google is your friend on that.

Now, if your data transfer is a one-time thing, you might be able to use the "alternative...

Almost none of the above is more correct than the official word from Micros~1:

http://msdn2.microsoft.com/en-us/library/ms179314.aspx

press F1 inside QA or EM.

try SELECT CONVERT(real,'689,99')

and see if that works.

BOL has this to say:

"Every five minutes, DBCC INDEXDEFRAG will report to the user an estimated percentage completed. DBCC INDEXDEFRAG can be terminated at any point in the process, and...

The answer to this really depends on too many things to give a straight "do or don't do" type of answer.  I've had situations where it was beneficial to have...

Another option would be to give them the ability to update the xstatus column in master.dbo.sysxlogins

type

sp_helptext sp_addsrvrolemember

in QA with results to text turned on.  That is the code that...

Hello,

Nice idea, except that they can just grant themselves sa.

There are a few ways that you can work around this.  Probably the most simple would be to get an agent...