Viewing 15 posts - 42,076 through 42,090 (of 49,552 total)
Jeff Moden (12/30/2008)
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
December 30, 2008 at 5:23 am
sunandas (12/30/2008)
Around 30000000 records are there in the table.
And you want to remove all of them?
I cant use TRUNCATE as its index will also removed(though I can recreate it again).
Truncate...
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
December 30, 2008 at 3:09 am
Jeff Moden (12/30/2008)
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
December 30, 2008 at 1:38 am
Jeff Moden (12/30/2008)
Seems like the intent of Microsoft was to make things easier for folks that don't know how to do it in T-SQL...
I don't agree with that. SSIS...
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
December 30, 2008 at 1:36 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/Topic627035-146-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
December 30, 2008 at 12:59 am
Jeffrey Williams (12/30/2008)
The question I have is what else could cause a database to not have a current backup. Is this a bug that existed in an earlier version?
That's...
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
December 30, 2008 at 12:54 am
GilaMonster (12/29/2008)
How many rows do you need to delete, how many rows are you keeping?
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
December 30, 2008 at 12:47 am
I found the bug that I was thinking about, but it's 2005 RTM, fixed by SP2
http://support.microsoft.com/kb/921106
If the diff succeeds on the sat, but fails on the sunday, I think you're...
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
December 30, 2008 at 12:38 am
biniyb (12/30/2008)
It seems that you tested an error message pertaining to the log backup...i'm having an issue with the DIFF backup. Unless i completely misunderstood your explanation.
The test was for...
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
December 30, 2008 at 12:23 am
Bini, I seem to recall there's a bug in one version of SQL regarding the diff backups. Perhaps a google search of support.microsoft.com would turn something up
Jeffrey : I setup...
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
December 30, 2008 at 12:07 am
How many rows do you need to delete, how many rows are you keeping?
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
December 29, 2008 at 11:59 pm
See here for all certification info - http://www.microsoft.com/learning/mcp/certifications.mspx
To upgrade MCDBA to SQL 2008 MCITP (DB Admin), you need to first get the SQL 2005 MCITP (DB Admin), as there's 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
December 29, 2008 at 11:58 pm
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic627024-149-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
December 29, 2008 at 11:53 pm
Depends on what FTP program you're using. See it's manual/help file for how to check what mode the transfer is in.
I know the file is transfered, but that doesn't mean...
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
December 29, 2008 at 11:51 pm
Is the FTP succeeding? Is the file transferred completely?
Are you doing the FTP in binary mode?
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
December 29, 2008 at 11:09 pm
Viewing 15 posts - 42,076 through 42,090 (of 49,552 total)