Viewing 15 posts - 3,526 through 3,540 (of 5,841 total)
UMG Developer (3/22/2011)
GSquared (3/22/2011)
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...
March 23, 2011 at 6:53 am
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...
March 23, 2011 at 6:50 am
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...
March 23, 2011 at 6:47 am
Jeff Moden (3/22/2011)
TheSQLGuru (3/21/2011)
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).
Gosh,...
March 23, 2011 at 6:44 am
Please don't reply to 3 year old threads. Start a new one.
March 23, 2011 at 6:40 am
March 21, 2011 at 1:37 pm
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)...
March 21, 2011 at 12:23 pm
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...
March 21, 2011 at 12:16 pm
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).
March 21, 2011 at 12:02 pm
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...
March 21, 2011 at 12:01 pm
Doesn't the FOR XML method blow up when certain characters are in place in the data??
March 21, 2011 at 11:58 am
homebrew01 (3/17/2011)
annasql (3/16/2011)
My server is 2005 SP2SP3 has been out for a loooooooong time ....
Actually SP4 has been out for quite a while now . . .
March 17, 2011 at 1:54 pm
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...
March 17, 2011 at 7:38 am
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. ...
March 17, 2011 at 7:34 am
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....
March 17, 2011 at 7:32 am
Viewing 15 posts - 3,526 through 3,540 (of 5,841 total)