UMG Developer (3/22/2011)

---

GSquared (3/22/2011)

---

Calling third-party DLLs (address list validation and presorting)

Disk data (space available, used, etc.) on network resources

Disk operations (file archiving and compression, file encryption)

Running totals

SFTP upload/download (SSIS won't...

Hard-coding the table names instead of using a sys.objects driven cursor to do these deletes may save you 0.001% of the total execution time. I say it would be...

There are other DMVs you can use to see what is actually using buffer pool memory. You an also check out dbcc memorystatus.

In general though, unless you have less...

Jeff Moden (3/22/2011)

---

Gosh,...

Please don't reply to 3 year old threads. Start a new one.

http://www.solidq.com/squ/courses/Pages/Home.aspx

I prefer the CASE statement:

select . . .,

SUM(CASE WHEN DATEPART(wk, mydate) = 1 THEN myfield ELSE 0 END) as Week1Total,

SUM(CASE WHEN DATEPART(wk, mydate) = 2 THEN myfield ELSE 0 END)...

Your question is incomplete. The key piece of missing information is "how many rows of data in each table"? What is spiffy fast for 10 rows...

Simple solution: do ALL of your math in a SINGLE PASS over the table. Do not have umpteen hits on the table (views or no views).

1) ola.hallengren.com. Use the FREE goodness there.

2) remember to NOT update stats on indexes you rebuilt!! doing so gets you a) double work and b) WORSE statistics if...

Doesn't the FOR XML method blow up when certain characters are in place in the data??

Actually SP4 has been out for quite a while now . . .

Forums are for SIMPLE, straight-forward problems. This is NOT THAT!! People who answer questions here do so as unpaid volunteers and it isn't fair to ask them to...

I HIGHLY recommend you stop using maintenance plans to do your sql server maintenance. Go to ola.hallengren.com and use the suite of scripts and jobs (FREE) found there. ...

Assuming the sql server relational engine is the only thing running on the server I would try 7GB as max memory and monitor for significant paging and memory pressure indications....