Yes, I understand now.

Your SSMS options allows you to open Object Explorer and a New Query at start-up. You probably have it set to open...

Pot --> kettle --> black.

Excuse me for being defensive, but Microsoft products have been putting food on my table since 1996. I...

kk.86manu (7/11/2013)

---

Hi All,

Please let me know whether it is possible to use the same secondary filegroup for 2 different databases.

I tried manually and it did not allow.Just wanted to confirm...

bert.hooks (7/10/2013)

---

You are correct! Thank you. I took out the create table statement and the following alter statement and all of the red lines went away.

It's no less...

Minnu (7/11/2013)

---

On re-reading, I'm not sure that's what he's asking, anyway. Does he want to know how to have the folders automatically expanded when SSMS opens?

John

Yes John Exactly,

I've all...

There's loads of them....

Glad the thread helped you, but it is not necessary to say...

If salary is your number one priority then may I suggest getting into offshore drilling.

Both plans are timing out, but one in a second and one in 10 minutes.

<QueryPlan DegreeOfParallelism="0" MemoryGrant="5968" CachedPlanSize="1632" CompileTime="659453" CompileCPU="649780" CompileMemory="715616">

<QueryPlan DegreeOfParallelism="0" MemoryGrant="7296" CachedPlanSize="1720" CompileTime=" 1183" CompileCPU=" 1055"...

SQL Server 2012 uses blocks of 1000 in a cache. When you restart the SQL Server service the next block...

Hi,

Stats are stored in a binary large object called a statsblob. These are very small, even with very large tables, and you will not find any performance gains by cleaning...

Please supply the actual execution plans for both.

dwain.c (7/4/2013)

---

I don't suppose you'd...

You can use a DMV on your dev databases to check if Enterprise features are in use.

SELECT * FROM sys.dm_db_persisted_sku_features

Code To Simulate OP's Table:

CREATE TABLE customer (C_recid INT);

INSERT INTO customer VALUES (50200),(50194),(50430),(50191),(1);

Here is my solution:

DECLARE @Lookup TABLE (C_recid INT, OrderSeq SMALLINT);

INSERT INTO @Lookup VALUES (50200, 1), (50194, 2), (50430,...