Viewing 15 posts - 3,526 through 3,540 (of 5,843 total)
If you are responsible for your company's database server HA you REALLY shouldn't be asking the types of questions you are asking! PLEASE do yourself and your company a...
March 24, 2011 at 7:44 am
heavy-duty string manipulations are a good example (especially delimited-string stuff)
heavy-duty or complex math
running totals
March 23, 2011 at 6:54 am
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
Viewing 15 posts - 3,526 through 3,540 (of 5,843 total)