Viewing 15 posts - 26,791 through 26,805 (of 49,552 total)
Well.....
Test and confirm that I'm not lying to you first. 😉
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
April 11, 2011 at 8:46 am
It shouldn't cause a recompile event. That's for when the query starts executing and something (schema/stats) have changed invalidating the plan. If that set option is one that results 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
April 11, 2011 at 8:38 am
What do you mean by 'actual row number'? Tables have no order and there's no automatic row number that you can query.
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
April 11, 2011 at 8:35 am
Please post new questions in a new thread. This thread is 3 years old and the person you are addressing hasn't logged in in 3 months.
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
April 11, 2011 at 8:35 am
What events are you tracing for?
That shouldn't cause a recompile. It should cause a compile and a second plan in cache with the different set option. Set options don't so...
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
April 11, 2011 at 8:32 am
homebrew01 (4/11/2011)
I think the total size of you t-log backups should be about the same. One huge daily backup, or many small 20 minute backups.
A daily log backup will also...
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
April 11, 2011 at 8:20 am
Please note: 3 year old thread. Might be better to ask new questions in a new thread.
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
April 11, 2011 at 8:15 am
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
April 11, 2011 at 3:24 am
Ratheesh.K.Nair (4/10/2011)
Is there anyway to recover without data loss and without restoring.
No. Those weren't the two best options I gave above. They're the only options. You can repair or...
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
April 11, 2011 at 2:58 am
Since it was suspect your only two options are:
1) CheckDB with REPAIR_ALLOW_DATA_LOSS. There's damage to the clustered index (just one page) and that's the only repair level allowed in emergency...
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
April 10, 2011 at 10:59 pm
Because nothing needs to log in via the database owner, hence the status is irrelevant. The account must just exist, which is why there are problems if the job/db owner...
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
April 10, 2011 at 11:20 am
The DB will be accessible, but some objects will break. No need to use the sa, leave it disabled. Just change the DB's owner to sa after the DB 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
April 10, 2011 at 4:20 am
That's a big topic. Entire books have been written on that subject. May I suggest this one: http://www.amazon.com/Securing-SQL-Server-Protecting-Attackers/dp/1597496251
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
April 9, 2011 at 9:33 am
Yup.
It's odd that it's a resource semaphore wait though. IO related I would have expected IO latches rather.
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
April 8, 2011 at 11:56 pm
llevity (4/8/2011)
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
April 8, 2011 at 4:46 pm
Viewing 15 posts - 26,791 through 26,805 (of 49,552 total)