Viewing 15 posts - 37,231 through 37,245 (of 49,552 total)
The method to decrypt a proc in 2000 does not work at all in SQL 2005.
Google for SQL 2005 stored procedure decryption. You should be able to find a tool...
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
August 7, 2009 at 9:07 am
Is there a question here?
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
August 7, 2009 at 9:01 am
At the bank where I used to work we could take leave or get paid for authorised overtime (meaning that the line manager had approved it before or after the...
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
August 7, 2009 at 8:35 am
Backup log ... with truncate_only is also gone in SQL 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
August 7, 2009 at 8:30 am
What's the version of 2005 that you're on? (run SELECT @@Version)
I know there were a couple bugs in earlier versions of 2005 that caused this.
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
August 7, 2009 at 7:59 am
Grant Fritchey (8/7/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
August 7, 2009 at 7:57 am
sknox (8/7/2009)
Mark Horninger (7/14/2008)
Bill Whitman (7/14/2008)
oberhardt is correct.A maintenance plan should be set up to truncate, shrink, and backup the transaction log -- nightly, if necessary.
Probably don't 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
August 7, 2009 at 7:56 am
Way too small to worry about fragmentation. Start getting concerned about fragmentation when there are around 1000 pages in the index. Fragmentation just isn't a problem on very small indexes...
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
August 7, 2009 at 7:00 am
Grant Fritchey (8/7/2009)
Is there a trigger or something that relates dbo.intPolicy and dbo.afl?
Could be from other statements earlier in the procs if there are explicit transactions been used.
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
August 7, 2009 at 6:57 am
Can you post the full definition of the following two procs?
MyDB.dbo.CBZsp_Policy_Save
MyDB.dbo.CBZsp_aflmentCollection_SaveAll
Can you also post the definitions and index definitions of these two tables
MyDB.dbo.intPolicy
MyDB.dbo.afl
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
August 7, 2009 at 6:56 am
Have a browse through the backup and admin forums here. It's kinda scary. The 'I'm in full recovery, what's a log backup, why's my log filling the drive' 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
August 7, 2009 at 6:53 am
---------
Bill: A maintenance plan should be set up to truncate, shrink, and backup the transaction log -- nightly, if necessary.
Me: Backup the log, sure, though more often than nightly is...
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
August 7, 2009 at 6:36 am
I don't know which of my posts you're reading, but the only thing I said about Simple Recovery was
On a dev server I'd just set all the DBs to Simple...
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
August 7, 2009 at 6:15 am
GilaMonster (8/6/2009)
Also, have you checked to see if the proc's getting blocked? Look at sys.dm_exec_requests and check for blocking processes or high wait times
Is there a DBA there who can...
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
August 7, 2009 at 6:03 am
Why on earth are you running repair without checking what's wrong? Repair is a last resort. It should never be the first thing done and it should never be run...
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
August 7, 2009 at 5:56 am
Viewing 15 posts - 37,231 through 37,245 (of 49,552 total)