Viewing 15 posts - 2,911 through 2,925 (of 49,552 total)
Igor Micev (6/23/2016)
ashwan (6/23/2016)
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
June 23, 2016 at 3:13 am
Then select won't take locks and will read whatever value is there at the point it runs, might be old value, might be new, no way to tell, just depends...
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
June 23, 2016 at 3:10 am
dastagiri16 (6/21/2016)
Thanks..which replication is better to implement two way sync as many tables are having pk indentity auto increment option
To be honest, multiple writable nodes and two-way sync is complex...
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
June 23, 2016 at 2:14 am
ashwan (6/23/2016)
let say there is a DB with large update frequently . In this situation all select statements are waiting for new update. ?
No, the lock manager's smart, the selects...
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
June 23, 2016 at 2:03 am
It won't break the log chain, because SQL doesn't know the backup's been discarded, so you will still be able to take log backups, however those log backups will be...
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
June 23, 2016 at 1:46 am
In default isolation level with none of the snapshot isolation options turned on, it will wait for the update to finish and then return the new value.
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
June 23, 2016 at 1:45 am
simon.letts (6/22/2016)
I'm learning lots here...I didn't realise that? So the only way to get actuals is from XE
If you're talking about actual plans from queries run by an application,...
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
June 22, 2016 at 9:38 am
MadAdmin (6/22/2016)
Cos the plan cache is there, juicy enough to eat, with all the info you need in one crispy query.
His event is for actual execution plans (plans with 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
June 22, 2016 at 9:28 am
terry999 (6/22/2016)
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
June 22, 2016 at 9:23 am
terry999 (6/22/2016)
Is it possible to restore a filegroup backup onto another Server?
Only if you start by restoring primary and, since the DB is in simple recovery, all the filegroups 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
June 22, 2016 at 9:19 am
Profiler, the gui, is a server-killer. Extended events are much lighter-weight, but that doesn't mean they're free.
Server-side traces only returned the filtered events, profiler didn't filter them after 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
June 22, 2016 at 8:13 am
No, I didn't suggest using the procedure name. I said that your filter on ObjectName is wrong because that ObjectName is the procedure name, not the name of tables 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
June 22, 2016 at 7:08 am
You're using the wrong filter.
Object name would be the name of the procedure which the query is in, not the name of a table used by the query. The second...
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
June 22, 2016 at 6:26 am
andymay-496937 (6/21/2016)
So do I, anyway Microsoft would never give us buggy code, would they? 😉
I wasn't referring to Microsoft's code, I was referring to yours. I've seen enough databases 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
June 21, 2016 at 12:47 pm
dastagiri16 (6/21/2016)
i believe peerto peer reications support two node modification...?
Peer-to-peer replication supports multi-node modifications, but the design guidelines recommend localisation of data changes (localise changes to tables to specific nodes),...
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
June 21, 2016 at 5:33 am
Viewing 15 posts - 2,911 through 2,925 (of 49,552 total)