Viewing 15 posts - 29,896 through 29,910 (of 49,552 total)
I still need you to answer one question of mine:
GilaMonster (10/16/2010)
Do you have a clean backup of this database?
That means a backup that does not have this corruption.
p.s. Was that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2010 at 3:02 am
Lennie's back... http://www.sqlservercentral.com/Forums/Topic1005823-169-1.aspx
With some sample code that looks like an interesting cross between T-SQL and an object-orientated language.
SELECT .... WHERE OrderDate.Month = 2
May I suggest that everyone just ignores that?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2010 at 2:51 am
Please answer Wayne's question
WayneS (10/16/2010)
What college and professor gave you this homework assignment?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2010 at 2:51 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1005812-338-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2010 at 2:45 am
You mean convert a package from DTS to SSIS?
There's a conversion wizard somewhere, I don't offhand know the link, but it's for simple packages. For more complex it's usually rewrite...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2010 at 2:44 am
Did you try a google search? Lots of good information available if you look.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 17, 2010 at 2:42 am
I wouldn't worry. The tables shouldn't be large enough for there to be a major concern around fragmentation.
Master database on my desktop has the largest system table with just...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2010 at 10:33 am
Zip your text file and then attach it.
Also, what's the output of the following?
SELECT @@version
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2010 at 10:25 am
Is anyone willing to bet some money on whether he has a clean backup or not?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2010 at 10:01 am
Swap? http://www.sqlservercentral.com/Forums/Topic1005710-265-1.aspx
Me: Run CheckDB and and post the full and unedited results
OP: I have used that command and it returned about 3000 line of error code. This is last lines....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2010 at 9:26 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1005710-265-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2010 at 9:21 am
ashkan siroos (10/16/2010)
Dear Gail,Thanks for reply,
I have used that command and it returned about 3000 line of error code:
I need to see them ALL to give you any useful advice....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2010 at 9:18 am
That's exactly what it will do as written.
If you want to make it clearer...
DECLARE @RowsUpdated INT
SET @RowsUpdated = 0
INSERT x VALUES (a)
IF @@rowcount>0
BEGIN
UPDATE x
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2010 at 8:39 am
@@RowCount ALWAYS takes the row count of the last statement executed. For the second @@rowcount, that will be either the update (if it runs) or the IF.
What do you want...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2010 at 7:49 am
SQL Server doesn't. Corruption is, in the vast majority of cases due to a faulty IO subsystem. That means that there's a problem somewhere in your drives, san controller, fibre...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 16, 2010 at 6:40 am
Viewing 15 posts - 29,896 through 29,910 (of 49,552 total)