Viewing 15 posts - 316 through 330 (of 49,552 total)
The file is the one currently being written to. When you copy it, that's no longer the case.
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
February 26, 2018 at 10:02 am
Triggers on the tables beneath the views, with logic to determine whether the changes that fired the trigger would affect the views or not.
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
February 26, 2018 at 9:47 am
ScottPletcher - Monday, February 26, 2018 7:50 AMThat's a huge effort to insure.
And it pretty much requires that your process...
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
February 26, 2018 at 7:53 am
Triggers on the tables that make up the view (trigger on the view doesn't fire unless the view itself is the target of the modification)
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
February 26, 2018 at 7:42 am
Check that the app is connecting to the listener, not to the server directly.
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
February 26, 2018 at 7:04 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
February 26, 2018 at 6:37 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
February 26, 2018 at 6:33 am
dopydb - Monday, February 26, 2018 6:28 AMsoon hopefully we will upgrade, and we can experience 10 year old Tech 🙂
🙂
If...
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
February 26, 2018 at 6:31 am
Keep in mind sequences can and will have gaps in them. This is not a bug.
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
February 26, 2018 at 6:25 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
February 26, 2018 at 6:23 am
sys.dm_exec_query_stats is dependent on the query's plan being in cache. When the query's plan is removed from cache, the query stats for that query are removed.
Hence, what you're seeing...
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
February 22, 2018 at 4:06 am
As I said, you're going to need to redo it. i.e. full database restore
But, before you do that, it may be a good idea to recover the DB...
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
February 22, 2018 at 3:16 am
You'll have to code that manually as you do the insert, stored procedure for insert would probably be best.
Do watch out for concurrency errors, this kind of thing 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
February 22, 2018 at 2:46 am
Looks like the transaction log on the secondary is damaged (or could be the data files)
You're going to need to re-do it, and it may be a good idea...
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
February 22, 2018 at 2:40 am
Are you talking about constructing 'lookup' tables in a query?
LikeSELECT <stuff> FROM Transactions
Inner Join (SELECT 1 As StatusID, 'Active' as Status UNION ALL...
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
February 19, 2018 at 4:56 am
Viewing 15 posts - 316 through 330 (of 49,552 total)