Nope. Should be hanlded based on what's actually needed, not on some blanket expectation that weekly...

According to the error message, the filename is invalid. Have you made sure the file is where the package expects it to be?

Something else is accessing the index at the same time, and it can't just wait for it to finish.

Dropping a clustered index in a production database is usually something you'd...

The way most RDBMSs do this is with a sub-query, or Merge.

UPDATE dbo.MyTable

SET MyColumn1 =

(SELECT MyColumnA

FROM dbo.MyOtherTable

...

Your maximum rowsize with that set up is 35,000 characters. SQL Server really doesn't support that.

Why such a huge table? What possible use is 350 columns of 100...

Rebuild redoes the stats. Reorganize doesn't. That's documented behavior.

So, if you rebuild, you already have a stat update, and doing another one (which a lot of people do)...

First, permissions. Does the SQL service account have access to the UNC path?

Second, is the file open in another process? I've seen that error when I accidentally left...

The only way I can think of to do it would be to insert the value into a table column defined in such a way that it would give a...

I have virtual junk drawers full of database scripts and notes from old projects, but when it comes to hardware, I tend to throw things away pretty aggressively.

No, the other query formats were just to see what the SQL engine is doing behind the scenes in building it's execution plans. No need to do anything more...

Elliott Berkihiser (9/28/2011)

---

I don't want to be too harsh on these folks. Their business does not include the typical transactional database. Most of their input comes from 3rd...

Awesome!

select *

from dbo.MyTable

order by case Users when 'ALL' then 1 else 2 end, Users ;

That avoids even things like entries that begin with low-ASCII-value punctuation coming before "ALL".

Simply put, we as a society put too much value on money.

Try master.dbo.sysdatabases. I think that's what it was called in SQL 2000. It's sys.databases in 2005 and beyond.

You can query that, and it has the recovery model in...