Viewing 15 posts - 46 through 60 (of 7,635 total)
greg.bull (9/24/2013)
...If CPU idles at 3 or 4% whilst the delete is running.
And RAM use is 13GB of 128GB
And Disk is idling at a few K per second
...
How many cores...
September 24, 2013 at 12:58 pm
NOTE: Cross-posted at Stackoverflow: http://stackoverflow.com/questions/18988246/trimming-empty-spaces-in-large-table-sql-serever
September 24, 2013 at 12:07 pm
You should use the SQL Profiler to see what's really happening on your SQL server when it's called from C#. In all likelihood, there's some unexpected difference at that...
September 24, 2013 at 11:55 am
Jeff Moden (9/19/2013)
I don't have 2k12 to confirm but try dbo.spt_values instead of sys.spt_values.
I just tried and that works as long as you're in [master]. (If not, you just...
September 19, 2013 at 9:53 pm
Yep, my bad. The SIDs were not in fact the same, they differed by a single letter somewhere around character 38.
Sorry, and thanks for the responses.
September 16, 2013 at 3:22 pm
todd.ayers (9/16/2013)
I have tried both double and single quotes in the authorization owner_name but continually getting message...
September 16, 2013 at 2:46 pm
RBAR = "Row-By-Agonizing-Row".
It's something we try to avoid in databases. Rather we try to do all of the rows at once.
September 16, 2013 at 2:40 pm
Sorry, this is really me (dang browser cached an old obsolete account I had from 12 years ago...)
September 16, 2013 at 2:03 pm
L' Eomot Inversé (2/8/2013)
Brandie Tarvin (2/8/2013)
It is morning and my muscles want exercise. Walking, running, jumping jacks, whatever.
You may not be aware what a jumping jack is on this side...
February 8, 2013 at 11:58 am
Revenant (2/8/2013)
Lynn, remember the bell curve: in any situation 50 percent of the involved are below the average, and 5 percent are on the tail end. That's how normal distribution...
February 8, 2013 at 11:51 am
Hey Folks, long time no see. 🙂
So, I after trying to help a poster at StackOverflow, I suggested that they re-post their question to here, because I couldn't figure...
February 8, 2013 at 11:48 am
Is case it wasn't obvious, I am the person at StackOverflow who suggested that Craig post this problem over here (extended interactive diagnosis doesn't really work back there).
A couple of...
February 8, 2013 at 11:35 am
Sweet. Really nice find, Jeff. This goes in my Favorites list... 🙂
November 5, 2012 at 11:53 am
Adam Machanic (10/3/2012)
RBarryYoung (10/3/2012)
So right now, I'm using Paul's latest CLR splitter...
You mean mine, that Paul posted the binaries for! 🙂
I am using this one here: http://www.sqlservercentral.com/Forums/FindPost1356773.aspx, I had assumed...
October 3, 2012 at 6:12 pm
Jeff Moden (9/6/2012)
UMG Developer (9/5/2012)
Adam Machanic (9/5/2012)
Generally when I...
October 3, 2012 at 12:08 pm
Viewing 15 posts - 46 through 60 (of 7,635 total)