If you offload it to another server, you'll still want to run a PHYSICAL_ONLY check on the first server.

Create a temporary table or a table variable to put the results into. Run the query, do a JOIN to compare the results. You can use

INSERT INTO #X -- or...

kanuto.tapon (5/13/2015)

---

GilaMonster (5/13/2015)

---

kanuto.tapon (5/13/2015)

---

The 2008 database will be updated everyday so what will happen is that there's a scheduled task that will run a certain SSIS/package to copy/backup it to...

If you're going to maintain the 2000 system for the long term, then I'd treat it like it's a full part of your development and deployment system. Changes to your...

So you're connecting from the older version of SSMS to the newer SQL Server instance? Yeah, that's going to fail because the software isn't forward compatible. Structures and internals change...

Your best bet with the current product is probably option #2. If you can move your database to Azure, there is dynamic data masking[/url] that will do exactly what you...

sys.dm_db_index_usage_stats is the way to go for this information. However, it's worth noting that this will only be good information back to the last time the server was restarted or...

Some procedure or view or something in the database is referencing the MostFavoredGenerics, but it's gone, so when you script out the objects and try to recreate it, it's failing....

Joy Smith San (5/11/2015)

---

Thanks Grant & Perry

If you're in the extremely large database sphere, you may find that backups running for 26 hours just doesn't work. Especially when restores can...

Since the only error you have found is "Terminated Abnormally" it's really hard to say. As I said, the most common error there is permissions, but I believe you. Second...

First, when examining whether or not a missing index suggestion is good, please, change the name from [<Name of Missing Index, sysname, >] to anything else.

Next, while that may have...

Both approaches sound like excessive locking to me. Why are they putting such stringent locks on the system to begin with? Most people are trying to avoid locks and the...

Durations suggest that the other backup is failing same as the native backup. It sure looks like a permissions issue. Running it as yourself is going to be different than...

Charles Kincaid (5/9/2015)

---

Stored procedures cache the execution plan at the time the procedure is compiled. On the other hand a query may get a new execution plan every time...

I have not seen this, but would be very interested if such a thing existed.

One small measure that you can use is the estimated cost within the execution plan. It...