Viewing 15 posts - 2,911 through 2,925 (of 49,571 total)
Igor Micev (6/23/2016)
ashwan (6/23/2016)
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...
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...
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...
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...
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.
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,...
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...
June 22, 2016 at 9:28 am
terry999 (6/22/2016)
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...
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...
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...
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...
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...
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),...
June 21, 2016 at 5:33 am
Viewing 15 posts - 2,911 through 2,925 (of 49,571 total)