Transaction isolation level:1. Uncommitted Read (NoLock)2. Committed Read (blocking)3. Repeatable Read (phantom)4. Snapshot (no blocking)5. Serializable (no blocking)Dirty Read:(DR)Non Repeatable Read:(NRR)Phantom:(P)Great...
2009-05-19
1,146 reads
For the past couple years I've been using a Targus (I think the model 300 right now) and they've been...
2009-05-18
887 reads
I stopped by Compusa on the way home to pick up a package of blank DVD's and did the 10...
2009-05-18
780 reads
If you are a leader of a Microsoft-related user’s group, and you haven’t done so already, you will want to...
2009-05-18
563 reads
If you want to be the first on your block to see the CTP (Community Technology Preview) of SQL Server...
2009-05-18
489 reads
As I'm digging more into SQL Server 2008 encryption I'm learning some interesting things about how SQL Server handles encryption....
2009-05-18
2,699 reads
Keynote speaker, Bill Veghte, Senior Vice President of Windows Business at Microsoft.
TechEd 2009 was started with a keynote presentation from...
2009-05-18
1,229 reads
My rolling 30 day post count dropped crazily this weekend. I noticed, but with family committments, I didn't do anything...
2009-05-17
630 reads
As none of us are immune to the current financial crisis, and your development projects have probably come to a...
2009-05-16
758 reads
I went over last night to do a presentation to the group managed by Bonnie and Lynn. Had 11 in...
2009-05-15
635 reads
By Chris Yates
Artificial intelligence is no longer a distant concept. It is here, embedded in the...
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed...
I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64) Microsoft Corporation...
i have sqlexpress on rds, is there any way i can get notifacation that...
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers