Just use sp_msforeachdb. That's what it's for. But, if you really, really don't want to use it, set up a cursor to cycle through the databases (that's all that query...

Or use INIT and FORMAT with the backup command to make it always be a single file instead of a series of files stacked together.

Since you're posting this in the 2008 forum, I'm going to assume you're on a 2008 or better server. You can look at they system_health extended event session. It's running...

Please supply a bunch more detail, especially the code you wrote and what you expected it to do for you.

A full backup includes the part of the transaction log that hasn't been marked as getting removed, so if you had a huge jump in the size of the log...

Yes.

Or if the data is less than an extent in size (8 pages), then it won't fragment either. Generally you shouldn't even bother defragmenting an index until it's at least...

Same here. One database backup on an individual file. No devices. I have done log backups to a single file, but that's still a single file for each database, just...

You'd have to search each database on the server. You can look for the table name in the system view INFORMATION_SCHEMA.Tables.

Or, you could go to Red Gate Software and get...

Using the sys.dm_exec_query_stats DMV, all you can do is what you've done. Take the average and split it up by execution count. If you want a precise measure, you'll need...

I'd prefer querying the information schema too, but there is always sp_help

EXEC sys.sp_help 'sales.salesorderheader'

To a very large degree, a query is a query. As Gail says, it will be the same. The main thing would be how the query is put together. Let's...

ramana3327 (1/19/2014)

Thanks to everyone.

I read that update is faster. Why because already table space is fixed, and you are just changing the value but for the insertion it...

Availability Groups are not in any way like clustering. You're defining various systems that share no hardware at all to belong to an Availability Group. Then, you can define a...

I'm right there with Gail. Not seeing the code, there's just not enough to go on. Heck, you may have just had contention the first time you ran the query.