Viewing 15 posts - 17,401 through 17,415 (of 22,219 total)
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
Ooooh. Cool. I like that one. You could really mess with people's heads with 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 20, 2009 at 6:24 pm
Changing as little as possible... yeah, that's probably a good way to go. I assume that the larger index is the most common access path? If the smaller index is,...
"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 20, 2009 at 1:30 pm
Dean Jones (5/20/2009)
I have quite a few questions and thought instead of starting separate threads, I ask it all in one.
1) I know SQL 2005/2008 has built in maintenance...
"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 20, 2009 at 1:27 pm
By the way, with a little more experimentation, this also works:
SELECT 'dude'dudette
"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 20, 2009 at 1:06 pm
Wild. I've never seen that before. Cool. Good job figuring it out. I can sleep tonight now. Thanks.
"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 20, 2009 at 12:56 pm
OK. Spill.
"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 20, 2009 at 11:51 am
I just did several searches on Connect. I don't see this listed anywhere. Weird stuff. I think I'm going to post it to another newsgroup to see if others have...
"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 20, 2009 at 11:50 am
Viewing 15 posts - 17,401 through 17,415 (of 22,219 total)