Viewing 15 posts - 17,401 through 17,415 (of 22,226 total)
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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?...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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)....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 21, 2009 at 6:50 am
Actually the files themselves in Sharepoint are stored on the file system. The meta data about the files is stored in Sharepoint. Restores of a Sharepoint system can be entertaining...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 21, 2009 at 6:46 am
Yeah. It works on 2000 too. I wish I had a 7.0 or, better still, a 6.5 system to try it out on.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 21, 2009 at 5:39 am
RBarryYoung (5/20/2009)
Grant Fritchey (5/20/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 21, 2009 at 5:32 am
Viewing 15 posts - 17,401 through 17,415 (of 22,226 total)