Viewing 15 posts - 2,746 through 2,760 (of 49,552 total)
I've used revlogin in a 2012 to 2014 migration, worked fine.
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
July 23, 2016 at 4:22 am
You can write the extended event session to a ring buffer, that's queryable. The perfmon counter will work as well if you just want a count.
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
July 23, 2016 at 4:20 am
The log can't be reused while a backup is happening, so it suggests that, at the time you do the backup, the DB is very active (or maybe running index...
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
July 23, 2016 at 4:19 am
Nothing.
Checkpoint_queue is a wait type, the checkpoint process is normally in that wait state, waiting for some work to do.
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
July 22, 2016 at 4:51 am
Again, no idea because we don't know the definition of the table or what the data in it looks like. Whatever you have there is custom, not something that's 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
July 22, 2016 at 4:23 am
Then you're going to need to script objects, export data and recreate the DB from scratch (and some stuff may fail to script or export due to the corruption)
Once you...
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
July 22, 2016 at 3:53 am
Restore from your last good backup. Damaged system table, that DB is toast, not repairable.
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
July 22, 2016 at 3:23 am
Jeff Moden (7/21/2016)
Heh... "CE". That's the "Crippled Edition", yes? 😛
Cardinality Estimator most likely, not Compact Edition. 🙂
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
July 22, 2016 at 2:00 am
pietlinden (7/21/2016)
If it's for a single stored procedure, wouldn't you just use WITH OPTION RECOMPILE?
Maybe. Maybe not. Depends on how much overhead the repeated compilations add.
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
July 22, 2016 at 1:58 am
Date error tossed over to the docs team, I've also asked about the download as I also can't figure out where to download the file.
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
July 21, 2016 at 2:28 pm
I doubt it's anything to do with the app. RStudio doesn't have query designer features, R (the language) just connects to SQL using ODBC and passes over whatever query 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
July 21, 2016 at 1:22 pm
Try this: http://www.sqlservercentral.com/articles/Restore/95839/. Otherwise there should be restore scripts available online that check folders for the log restores.
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
July 21, 2016 at 11:28 am
Not quite.
You're going to have to manually add the restore based on your full backup, rather than the virtual one, and the diff will only be useful if the virtual...
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
July 21, 2016 at 11:12 am
jasona.work (7/21/2016)
IIRC, if this is Paul Randal, he used to work for MS.
No. Paul White.
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
July 21, 2016 at 11:03 am
Shahin (7/21/2016)
So I think I should be able to run a query 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
July 21, 2016 at 9:27 am
Viewing 15 posts - 2,746 through 2,760 (of 49,552 total)