Viewing 15 posts - 2,806 through 2,820 (of 5,685 total)
PHXHoward (7/8/2011)
Does that make sense? I don't like the replace method because it is altering the data. Can SQL Server handle a value like 0x180?
The question makes sense, and you're...
July 8, 2011 at 4:56 pm
Brandie Tarvin (7/8/2011)
GilaMonster (7/8/2011)
Craig Farrell (7/8/2011)Saturday's article: Why some DBAs are Nincompoops. Sunday's article: Retraction of previous article with editing: Why ALL DBAs are Nincompoops.
Monday's article: Why some...
July 8, 2011 at 2:59 pm
mtillman-921105 (7/8/2011)
Speaking of old, it's time to change my avatar. Carl Fredrickson was looking too, um, classic.
Not a bad idea, time to go back to a classic. 🙂
July 8, 2011 at 2:55 pm
A little more detail.
You want this package to not run on any server but one particular one?
July 8, 2011 at 1:00 pm
GilaMonster (7/8/2011)
Craig Farrell (7/8/2011)Saturday's article: Why some DBAs are Nincompoops. Sunday's article: Retraction of previous article with editing: Why ALL DBAs are Nincompoops.
Monday's article: Why some clients need...
July 8, 2011 at 12:00 pm
Steve Jones - SSC Editor (7/8/2011)
SQLRNNR (7/8/2011)
SQLkiwi (7/8/2011)
Steve Jones - SSC Editor (7/8/2011)
Behave.Badly?
Think much much worse than that 😀
Umm, should I disable a few accounts today?
Disable? nononono...
EMPOWER!
Saturday's article: Why...
July 8, 2011 at 11:41 am
siva_krishnan (7/7/2011)
4. No transaction log backup at all since day one.
5. Now user need the data...
July 7, 2011 at 5:52 pm
Found problem.
Please note: If you're not familiar with how to properly escape unexpected errors out of your Try/Catch, please learn before using it in production code and driving some poor...
July 7, 2011 at 4:26 pm
Hey guys, I could use a hand here: http://www.sqlservercentral.com/Forums/Topic1138580-338-1.aspx
My google-fu is failing, my brain is on vaporlock at my confusion, and I've placed a nice bullseye on my desk...
July 7, 2011 at 4:21 pm
Jim Murphy (7/7/2011)
GSquared (7/7/2011)
Yeah, the indexing on The Thread is definitely broken. It's all "bookmark lookups" and "out of date stats" and the fragmentation on the "subject under discussion"...
July 7, 2011 at 4:19 pm
Don't use Service Broker as an optimization tool. It's there for concurrency load and multi-server asynchronous transfers. You will never get better performance from the broker on the...
July 6, 2011 at 10:11 pm
Gyeah... yeah, I know how, you won't like it though.
Use a script task to build a component list for the ForEach loop using VBA for Excel, then for each of...
July 6, 2011 at 10:05 pm
sql_novice_2007 (7/6/2011)
July 6, 2011 at 10:00 pm
Bruce W Cassidy (7/6/2011)
Good advice, Craig. I hadn't thought about it from that point of view.
You get used to hearing the arguments when the database is being used as...
July 6, 2011 at 9:55 pm
I'm not sure if this will help you any, but it's an article I wrote recently for here. Sorry for the self-plug, but it pretty much was written for...
July 6, 2011 at 9:42 pm
Viewing 15 posts - 2,806 through 2,820 (of 5,685 total)