Viewing 15 posts - 38,221 through 38,235 (of 49,552 total)
Along the lines of that rather strange comment on SimpleTalk a week or so back (asking for BioTech books iirc), I thought this might provide a few laughs.
http://plzsendmethecode.blogspot.com/
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
June 24, 2009 at 12:58 am
Google for stored procedure decryption for SQL 2005. There are several tools, maybe one or two free, most are not free.
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
June 24, 2009 at 12:47 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic740742-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
June 24, 2009 at 12:44 am
Do you have an earlier backup that is usable?
You've got an irreparable error there. There is no way to fix that. You have only two options. Restore a clean 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
June 24, 2009 at 12:43 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/Topic740627-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
June 23, 2009 at 4:15 pm
Florian Reischl (6/23/2009)
@roy: You just have to come to Germany.
How far are you from Berlin? There's a very, very, very, very small chance that I may be in that area...
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
June 23, 2009 at 3:38 pm
Just make sure that you rebuild your indexes afterwards.
See - http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/
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
June 23, 2009 at 3:32 pm
will (6/23/2009)
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
June 23, 2009 at 3:19 pm
Florian Reischl (6/23/2009)
GilaMonster (6/23/2009)
He offered $5.:laugh:!
Did you answer this?
I replied with my actual hourly rate (which seems lot to US people because of the exchange rate). Never heard back.
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
June 23, 2009 at 3:07 pm
No.
Leave them the size they are now. Monitor using DBCC SQLPERF(LogSpace) and you'll be able to see file size and space used. Keep an eye on that and see...
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
June 23, 2009 at 3:02 pm
WayneS (6/23/2009)
Well, I let him know a solution is available, but... well, see for yourself... http://www.sqlservercentral.com/Forums/FindPost740549.aspx
LoL.
I had a guy contact me via PM a while back about a procedure (apparently...
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
June 23, 2009 at 2:54 pm
Close.
A log consists internally of lots of VLFs (virtual log files). When a log backup occurs all VLFs that do not contain active portions of the log (portions still possibly...
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
June 23, 2009 at 2:35 pm
If you set the DB to simple you break the log chain. That may not sound important with a full backup straight after, but what if that full backup'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
June 23, 2009 at 2:22 pm
WayneS (6/23/2009)
David O (4/9/2008)
If you've go the maintenance window. I'd run dbcc dbreindex...
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
June 23, 2009 at 2:16 pm
You watch the database for a few weeks and see how big it grows. If it's too big (in your opinion) make your log backups more frequent, do a once-off...
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
June 23, 2009 at 2:05 pm
Viewing 15 posts - 38,221 through 38,235 (of 49,552 total)