Viewing 15 posts - 14,986 through 15,000 (of 49,552 total)
devanandiiway (1/3/2013)
The problem is the good backup of this database got expired.
Then you have a serious problem, because there's no way you can repair this error. You need to...
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
January 4, 2013 at 2:18 am
SQLRNNR (1/3/2013)
GilaMonster (1/3/2013)
No, a shrink (even a 'properly performed' one) will not improve SQL performance. The index rebuild and stats update they recommend would be what improves performance.
Even better 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
January 3, 2013 at 3:49 pm
james marriot (1/2/2013)
Do i need to explicitly say SET TRANSACTION ISOLATION LEVEL SNAPSHOT; in each batch that i want to operate under Snapshot isolation?
Yes.
I altered database
Set Allow_Snapshot_Isolation ON, but even...
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
January 3, 2013 at 3:12 pm
Terrie (1/3/2013)
I always thought it was generally recommended not to shrink growing databases.
You would be completely correct there.
"The Shrink Database procedure is required due to continued insertions and deletions in...
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
January 3, 2013 at 3:09 pm
Evil Kraig F (1/3/2013)
Any twitter folks here use a samsung galaxy? If so, what app do you recommend?
Twicca's quite nice
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
January 3, 2013 at 3:01 pm
Can you post some sample data please?
One potential reason is that the where clause is NOT guaranteed to be executed before the functions in the select are, hence it may...
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
January 3, 2013 at 12:24 pm
kwoznica (1/2/2013)
You have a singular “phone_contact” table name!! ONLY One?!
I take that this is a suggestion to make the phone_contact table a wider table to include...
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
January 3, 2013 at 12:15 pm
SQL Server error log. There will be messages about being unable to open a file. Check there, post the messages.
Not interested in the login failure. It's an effect, not a...
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
January 3, 2013 at 10:02 am
john 60195 (1/3/2013)
After some more read maybe this would lock a record (and only one record) until all work is done
No.
Rowlock just says *start* with row locks. Not only ever...
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
January 3, 2013 at 9:47 am
Recovery pending means SQL cannot open one or more of the files.
Check the error log for details. There will be details of what file and what error.
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
January 3, 2013 at 9:42 am
Connect.
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
January 3, 2013 at 9:32 am
Well, probably less that it's wrong and more that the page in question was changed from reading "In SQL Server 2005" to "In SQL Server 2008" with noone on 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
January 3, 2013 at 8:45 am
craighiggins (1/3/2013)
Hi GailSorry to be a pain but what should the log_reuse_wait_desc value be?
Nothing
Anything other than that and something is preventing log reuse, meaning the log may grow if 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
January 3, 2013 at 8:41 am
Neither. I'd use dynamic SQL.
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
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
January 3, 2013 at 8:09 am
AWE enabled is for 32-bit SQL to access memory above the 4GB boundary. That's what's been removed.
awe_memory is any that's allocated using the alloc_physical_memory API call, and that's used when...
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
January 3, 2013 at 7:37 am
Viewing 15 posts - 14,986 through 15,000 (of 49,552 total)