Alexander Karmanov (10/16/2008)

---

(snip)

There are few more moments one should consider, especially if you plan to free and remove the original filegroup:

1. BLOB data is not moved this way, it resides...

When moving a table to a new filegroup by dropping the...

Drammy (11/20/2013)

---

Thanks, perhaps a bit more background is in order.

(snip)

I'd like an idea for what kind of impact having no primary, clustered keys at all would have on your typical...

Questions:

1. Are there any clustered indexes on the tables? Without them, indexing will be inefficient since each table without a clustered index will be a heap.

2. Are...

We reproduced the problem in part with the latest backup from production.

Updating stats on all of the affected tables with FULLSCAN solved the problem.

We will run this tonight in production....

Hi Gail...

Apologies for not making it easy. I am inexperienced at posting XML based query plans online. I can rerun the bad query in production but it impacts...

GOOD QUERY XML:

<?xml version="1.0" encoding="utf-16"?>

<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.2500.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

<BatchSequence>

<Batch>

<Statements>

<StmtSimple...

Bad Query XML:

<?xml version="1.0" encoding="utf-16"?>

<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1.1" Build="10.0.5500.0" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

<BatchSequence>

<Batch>

<Statements>

<StmtSimple...

In test, nothing. It flies.

In production, I see...

johntam (9/26/2013)

---

Hi. I freed the entire procedure cache -- twice. I also compared the schema of test and production using SQL Compare, including indexes, which are identical for...

Hi. I freed the entire procedure cache -- twice. I also compared the schema of test and production using SQL Compare, including indexes, which are identical for all...

Checked...

I agree. I would also check sp_configure and ensure that the MAXDOP is the same for each instance. It's unwise to set to to 0 (unlimited). Pick a solid number...

I would check the driver software versions on the HBA adapters. Also, if this is an active-active situation where two instances reside on any one node in the event...

Andreas.Wolter (9/24/2013)

---

Ok

I guess instead of Tables you want to give permissions on the views that you mentioned.

You might just as well put them into 2 different schemas.. keeps the permissions...