And this one too.[/url]

You can use the RESTORE VERIFYONLY command to validate that a backup is available and accessible.

I don't understand what you mean by this: "know what is spend if used it"

Just turn that same query into an INSERT ... SELECT... statement and save the data into a table along with the date and time that you collected the information. Then...

opc.three (3/27/2013)

---

Grant Fritchey (3/27/2013)

---

Actually, if you use extended events you can filter by batch_text in sql_batch_completed or by statement in rpc_completed and then use the like_i_sql_unicode_string to do a...

Throw money, uh, I mean, hardware at the problem. That's your only option.

That value changes a lot over time. You can't look at it once and interpret anything from it. You must capture it continually. And, just because it changes doesn't mean...

Just remember that the clustered index is both an index and the data. So if a query can use the index part of the cluster to satisfy the operations, the...

Actually, if you use extended events you can filter by batch_text in sql_batch_completed or by statement in rpc_completed and then use the like_i_sql_unicode_string to do a like statement looking...

Ed Wagner (3/26/2013)

---

I think that's a good policy...don't ever publish real data. There are privacy, PII, HIPPA, etc. concerns that should never be overlooked unless you want a sudden...

And then, if your databases are in FULL recovery, you need to set up regular log backups. I'd suggest at least once an hour.

Sqlraider (3/25/2013)

---

Grant Fritchey (3/23/2013)

---

In addition to backups, if you're developing the databases, I'd get the source for the structures and code into a source control management system. I'm pretty sure...

By default, all things being equal, it shouldn't be taking longer with 2008 SSMS. So, you have to figure out what's not equal. Again, are you capturing an execution plan?...

Are you capturing the execution plan in the 2008 version of SSMS? Make sure you have the latest service packs installed on your server and on your client machine. Check...

As Gail says, they'll be backed up. Then, when you go to restore, the part of the restore process known as recovery deals with uncommitted transactions, rolling them back as...

In addition to backups, if you're developing the databases, I'd get the source for the structures and code into a source control management system. I'm pretty sure there ways to...