Can't be done, the system database model is used as a model for new databases.

You can put small objects in model (small, not huge, model is the template for TempDB...

Creating any database uses model as the template.

Alexander Suprun (1/25/2013)

---

Very-very bad advice. 20% of 128GB is 25Gb, are you sure you want to allocate so much memory for...

42.

Table definitions. Index definitions.

Edit: and the actual plan please, not estimated.

John Carter (it's nothing like the book series, other than in general plot), the Avengers. Didn't watch too many movies last year though.

I didn't enjoy the Hobbit. Was stretched too...

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Since apparently I don't have an idea about partitioning, can someone help this poor person? 😉

http://www.sqlservercentral.com/Forums/Topic1411242-149-1.aspx

No, that's not very efficient (any conversions to varchar in a date function should be suspect).

DECLARE @CurrentDate DATETIME

DECLARE @StartDate DATETIME

DECLARE @EndDate DATETIME

SET @CurrentDate = GETDATE()

SELECT @StartDate = DATEADD(hh,18,DATEADD(dd,4,DATEADD(wk, DATEDIFF(wk,0,@CurrentDate)-1, 0)))

SELECT...

Not just indexes. A change in the data volume in the table could easily have the same effect. The query is non-deterministic.

Keep foreign keys (unless you like dealing with garbage data), partitioning is for management of data, not performance. Query and index hints are the very last resort for tuning queries...

and only in SQL 2005 above,...

Express can't use more than 1 GB of memory, so unless you want to set max memory below that for some reason, no.

Please run the following and post the full and complete, unedited output.

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

Gowthu (1/25/2013)

---

select m2.Acct1,m2.Amt

from

(select n1.Acct,n1.max_insert_no

from

(select Acct,MAX(last_insert)max_insert_no

from

(select Acct,ROW_NUMBER() over (partition by Acct order by Acct)last_insert from Table_1)n

group by Acct)n1

)n2

join

(select Acct Acct1,Amt,ROW_NUMBER() over (partition by Acct order...