Viewing 15 posts - 33,706 through 33,720 (of 49,552 total)
preetshari (3/3/2010)
Yes but i need to return the updated LastUsedIndex.
Lynn's code does that. The @num variable will containt the updated value. Try it.
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
March 3, 2010 at 12:45 pm
Since it's an important database, wouldn't it have a backup?
You can try any disk undelete tool, providing absolutely no changes have been made to the disk since the files were...
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
March 3, 2010 at 12:44 pm
Lynn Pettis (3/3/2010)
IIRC, Microsofts certs now expire after 3 years.
They don't expire. There was a plan for that to happen, but didn't become reality. They are retired and become...
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
March 3, 2010 at 12:24 pm
As for should you get certified, this blog post parallels my usual thinking on the subject
http://www.brentozar.com/archive/2009/04/certifications-are-the-icing-on-the-cake/
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
March 3, 2010 at 8:49 am
Got an old developer cert, all the SQL server 2000, 2005 and 2008 (except BI), one Windows Server exam and two sharepoint certs (one of which I managed to get...
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
March 3, 2010 at 8:46 am
Does anyone have time to go into detail on this one?
http://www.sqlservercentral.com/Forums/Topic875858-338-1.aspx
Probably a variant of parameter sniffing, from all that's been said. The procs and exec plans have been made available,...
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
March 3, 2010 at 8:26 am
NicHopper (3/3/2010)
This is just as the powers that be dont want the data leaving up on a public forum, the files will be removed later on today.
I'm not going...
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
March 3, 2010 at 8:24 am
Yeah, that's due to the incorrect results bug I mentioned. The functionality was removed quite early, pre SP1. I have demoed this on 2008 RTM and there's a very obvious...
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
March 3, 2010 at 8:19 am
dbychen (3/3/2010)
Yes, it does. This type of backup is differential backup.
Differential and incremental are not the same thing.
Differential = changes since last full backup
Incremental = changes since last backup (full,...
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
March 3, 2010 at 6:52 am
HowardW (3/3/2010)
It was...
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
March 3, 2010 at 6:51 am
SQL has full backups, differential backups (changes since last full backup) and log backup (backup of log records since last log backup)
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
March 3, 2010 at 6:22 am
NicHopper (3/3/2010)
Thanks for the quick reply, I think your probably right as it is one of them 'jack of all trades' procedure which has some parameters which are optional.
In 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
March 3, 2010 at 6:17 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic875690-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
March 3, 2010 at 6:01 am
Don't understand the question.
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
March 3, 2010 at 6:00 am
Repair_rebuild will do nothing, seeing as the minimum level to repair is repair_allow_data_loss.
I strongly suggest that you get out a clean backup and restore. Especially seeing as this is sharepoint,...
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
March 3, 2010 at 6:00 am
Viewing 15 posts - 33,706 through 33,720 (of 49,552 total)