Viewing 15 posts - 17,386 through 17,400 (of 22,214 total)
Steve Jones - Editor (5/22/2009)
Grant Fritchey (5/22/2009)
May 22, 2009 at 10:22 am
Now I'm second guessing what we're doing. If we're storing files directly in the DB, I'd expect it to be fairly large since we've got a pretty extensive Sharepoint installation,...
May 22, 2009 at 8:50 am
I suspect it's the temp table in the query, but you know what, instead of both of us guess, run the query with a Profiler trace going and look for...
May 22, 2009 at 7:36 am
Have you looked at the execution plans? It's possible it's doing lots of scans and you're seeing contention. Have you tried running a blocking monitor (do a search in the...
May 22, 2009 at 6:12 am
Really? I'm sorry if I put out bad info. Maybe it's a setting during the install because we've been dealing with file systems seperate from the data store for a...
May 22, 2009 at 6:04 am
mverma4you (5/21/2009)
check this for automation
Before I'd go in that direction, I'd look into Powershell. It's going to work as well or better for minor bits of automation, especially within a...
May 22, 2009 at 6:00 am
No one is going to believe this, but a friend of mine & I were very minor characters in one of the Destroyer novels. We were introduced and killed within...
May 22, 2009 at 5:54 am
Jack Corbett (5/21/2009)
GilaMonster (5/21/2009)
Oh yay. 🙁Another email accusing me of personal attacks and damaging someone's public image by 'misleading' people about his statements.
Sometimes I wonder why I bother.....
That's always fun....
May 21, 2009 at 11:27 am
GilaMonster (5/21/2009)
Lynn Pettis (5/21/2009)
Are we talking about our window washer friend here?
No. It's someone who answers questions, not asks. (no one here, obviously)
Steve: Apologies in advance if this...
May 21, 2009 at 11:25 am
Lynn Pettis (5/21/2009)
Would anyone mind if I asked him how he got this job if he can't even figure out how to read error messages and complete simple tasks?
Actually, no....
May 21, 2009 at 8:18 am
ChandraMohan Nandula (5/21/2009)
Please give the complete syntax for DBCC CHECKDB. From the error message you had posted it looks like a page got corrupted. I think you...
May 21, 2009 at 7:15 am
Samuel Vella (5/21/2009)
I'm ->||<- that close to telling him to
right click the table
select open
scroll to the last row which should be full of "nulls"
start typing
How do you right click?...
May 21, 2009 at 7:13 am
You just need to read the error messages. From your post:
• Error 0xc020901c: Data Flow Task: There was an error with input column "FiscalYear" (161) on input "Destination Input" (72)....
May 21, 2009 at 7:08 am
Then your backup is corrupted. Nothing you can do with it. Time to go to the previous backup.
May 21, 2009 at 6:52 am
Another vote for Hyperbac. We're not using it at my company because we had previously purchased Litespeed, but we're looking to age that out & replace it with Hyperbac.
Another...
May 21, 2009 at 6:50 am
Viewing 15 posts - 17,386 through 17,400 (of 22,214 total)