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...
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...
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...
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...
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
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...
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...
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...
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...
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.
January 3, 2013 at 9:42 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...
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...
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/
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...
January 3, 2013 at 7:37 am
Viewing 15 posts - 14,986 through 15,000 (of 49,552 total)