No such thing as a nested schema. What are you trying to do here?

sp_updatestats calls UPDATE STATISTICS. It'll only call it for a stats set if at least one row has changed and by default it does a sampled update.

SELECT

SUM(CASE Status WHEN 'Active' THEN 1 ELSE 0 END) AS SumActive,

SUM(CASE Status WHEN 'Inactive' THEN 1 ELSE 0 END) AS SumInactive

Count(*) AS Total

FROM...

Is there a drive named 'S:'?

Does the SQL Server service account have full access to that drive?

If this is a clustered SQL Server, is that drive a dependency of the...

Elliott W (11/17/2009)

---

You could try this:

SELECT *

FROM dbo.SomeTable

WHERE ( @Field1 IS NULL OR Field1 = @Field1 )

AND ( @Field2 IS NULL OR Field2...

unixbomer (11/11/2009)

---

Well I would say that your biggest selling point would be that Microsoft dropped support for SQL 2000 last year. There is still extended support until 2013, but that...

Go to the services on the server and take a look at each service. If you get the properties of each one, there's a tab 'dependencies'. A service with no...

Execution plan?

You're backing up across the network. Any other network traffic will slow the backup down. Usual recommendation: Backup local, copy remote.

Wow, and you rebuilt that with no change happening to anything? Sure the rebuild succeeded?

ryan.mcatee (11/16/2009)

---

I guess the takeaway message from my little experiment is you can't restore a database under the full restore model with only data file backups, you must have at...

I find that condescending and insulting. I've used it once only, after someone repeatedly demonstrated that they were not going to search themselves, and...

The accepted practice is to size them for the workload (regardless of recovery model) and leave them alone.

Shrinking a log is a bad idea unless it's after an unusual...

Do you have auto_shrink on?

Can you run the query with the detailed option and post it so that it's easily readable. If you look at the earlier posts, it's hard...

There's nothing wrong with asking questions. That's what the forum is here for. The problem is that there are...