Yes, I've seen too many instances where the accidental DBA was shrinking data files every night.

Always fun to see their faces when you come in, see that, rebuild all indexes...

No, of course not. This information is part of my daily run of checks on 50+ SQL Instances, goes into a dashboard and triggers proactive growth of data files when...

Jeff, i tend to disagree.
If you want to get the actual usage information (via fileproperty or sp_spaceused) is only available for the current database. So you need to loop...

The last query posted by SQL_Elvis is actually wrong:
CAST(FILEPROPERTY(name,''SpaceUsed'') AS INT) UsedSpaceMB,
 should be

CAST(FILEPROPERTY(name,''SpaceUsed'')/128 AS INT) UsedSpaceMB,

hmm, can't believe noone has answered at all.

Come on folks, I am just asking about your experiences with this. Is a simple fulltext query really that much slower than a...

Hi SQLBuddy,

thanks for the answer. Yes, I realized that by now.

Only leaves me with one small problem.

I know how to move a normal index with Create index... DROP_EXISTING.

And I realize...

ok, even if I am talking to myself, maybe it helps others.

I was mislead from my SQL 2005 experience where the catalog was a real object.

Starting from SQL 2008, the...

allright, I played around a bit more and now I am even more unsure as to what's going on.

My fulltext index was based on 3 different tables.

I manually moved the...

xp_readerrorlog only queries the SQL server log(s), not the windows event log

sorry, posted to the wrong forum. could an admin please remove this thread?

I now posted to the correct forum

Thanks

/usenet

Hi Steve,

yes. But that requires to create them on the remote server. I ended up using linkedServers and local stored procedures to encapsulate the complex logic. The sample I posted...

yes, thanks. that solved the immediate problem - I was slapping my head tonight when i realized that i just didn't think about this solution 🙂

But the more general problem...