Viewing 15 posts - 16,021 through 16,035 (of 49,552 total)
No, you will not be able to use single user mode. You cannot access a database in any way via any means until recovery is complete (or fails).
Once more with...
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
October 18, 2012 at 7:54 am
Sample data please (as in example of what would be in the tables before that insert runs)
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
October 18, 2012 at 7:46 am
and
http://www.sqlskills.com/blogs/jonathan/post/How-much-memory-does-my-SQL-Server-actually-need.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
October 18, 2012 at 7:37 am
Brandie Tarvin (10/18/2012)
Jeff Moden (10/17/2012)
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
October 18, 2012 at 7:32 am
Of course they are. Just as useful as on an int, date, decimal, numeric or any other data type that's legal for index key.
Please read the links I posted.
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
October 18, 2012 at 7:28 am
Nope, you won't be able to access the DB while it's in recovery, at all, DAC or no DAC. How do you know there's corruption? Got the error messages? 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
October 18, 2012 at 7:27 am
briancampbellmcad (10/18/2012)
These are two separate triggers though.
Yeah, I know. If they were in one trigger it wouldn't be potentially a nested trigger problem.
Ok, you've given table definitions, now please...
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
October 18, 2012 at 6:30 am
No, indexes can be applied to any column or set of columns under 900 bytes wide in total.
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
Your index likely isn't covering, hence it's more efficient to just scan 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
October 18, 2012 at 5:02 am
Err... close but I sense a misunderstanding there.
When changes are made, they are made to the data pages in memory and are logged. When the transaction commits, the log records...
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
October 18, 2012 at 5:00 am
It can be done as dynamic, but that in no way makes it a good idea. If you need the totals for other shuff, then
Create proceduretest1
As
begin
...
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
October 18, 2012 at 4:39 am
Errr.. backups. That's what they are there for.
If you restored over or deleted a backup, the transaction logs would be gone too, not that they are a way of recovering...
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
October 18, 2012 at 4:18 am
Then you'll have to rewrite them. When you restored a DB over the one with the procs, those procs were lost.
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
October 18, 2012 at 4:12 am
Perry Whittle (10/18/2012)
GilaMonster (10/18/2012)
Steve edits them, don't know what his process is.I'm guessing he didn't edit that one, it was way off base 😉
No need to guess.
Editor: Our apologies. Today's...
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
October 18, 2012 at 4:11 am
Yup, it can be due to the snapshot.
http://www.sqlservercentral.com/articles/Performance+Tuning/64080/
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
October 18, 2012 at 3:40 am
You need to declare and assign @col1 within the dynamic SQL. Or drop the @ if you just meant col1
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
October 18, 2012 at 3:30 am
Viewing 15 posts - 16,021 through 16,035 (of 49,552 total)