patrickmcginnis59 10839 (12/15/2014)

---

Grant Fritchey (12/15/2014)

---

The one thing that always validates whether or not any backup mechanism is any good is to run a restore.

So, use your bosses approach on...

Yes, Intellisense within SSMS is extremely flaky.

More memory.

2gb is extremely low for a SQL Server instance (assuming we're not talking about SQL Server Express). The minimum requirement is 500mb, so you're just barely beyond that, and,...

I would add the schema to the tables in all the code you're referencing. Even if it's just the default and the default is 'dbo' you'll have more accurate scripts...

Not only can you not restore just specific columns, but you can't restore just specific tables. A restore operation restores the whole database (well, there is such a thing as...

The one thing that always validates whether or not any backup mechanism is any good is to run a restore.

So, use your bosses approach on 3-5 different databases, preferably...

It really depends on what you are attempting to collect in this information you're gathering. I've always set up monitoring on a server-by-server basis, not on a database-by-database basis. If...

Check the security settings to see how you're connecting to the database and how the view is connecting to the linked server. It sounds like a disconnect is occurring between...

You need to gather more data. Run a query against sys.dm_exec_requests to see if there are blocked or blocking processes on your server. Also look at sys.dm_os_wait_stats to see what...

Most especially get the wait statistics while the backup is running in order to understand exactly what is causing things to slow down. sys.dm_os_waits_stats will show you a cumulative view....

You're still stuck with third party tools for doing this type of thing.

You can't really undo an in-place upgrade. You would have to uninstall everything and then restore your databases from a backup. You're pretty much making a commitment by doing your...

Jeff Moden (12/11/2014)

---

Grant Fritchey (12/2/2014)

---

npranj (12/1/2014)

---

Thanks Grant.

The 42% cost is Clustered Index insert cost. There is one CI and 4 NCI on this table.

All the other costs are from...

Have you tried clicking on that link? It will open a graphical plan within SSMS.

But, if not, you can always query sys.dm_exec_text_query_plan. That will output just a raw varchar(max) column...

That's news to me. I'm not a backupexec expert, but I've worked around it for years. We were able to have it run all sorts of things without automatically running...