How Many Bytes Are In My Column? – T-SQL Functions
One of the things you want to be aware of when writing T-SQL is using the proper function for a...
2011-03-25
4,056 reads
Blog Posts
NOLOCK for Developers
What is NOLOCK?
NOLOCK is a table hint for SQL Server that tells the engine to not take locks and ignore...
2011-03-25
1,748 reads
OUG Back to Basics Event – London Mar 2011
First Things First
At UKOUGs’ Back to Basics Special Event held in London today (Mar 24th), Niall Litchfield presented a very worthwhile...
2011-03-25
624 reads
The Mystery Of The Slow Last Row
Things Go South
Recently I was troubleshooting a piece of software that archives data out of a very active import table....
2011-03-25
1,697 reads
Why I don’t like NULLs and Nullable Columns
As I imagine (or hope), the majority of us adhere to some form of standards in the environment that they...
2011-03-25
751 reads
Fast File Copy With Managed Code: UBCopy update!
If you have been following my trials with working with C# and files you know it hasn’t been a bed...
2011-03-24
1,128 reads
Intel Sandy Bridge Mobile Processors Explained
The long wait for the new, mobile Sandy Bridge processor equipped laptops is nearly over. Most of the large system...
2011-03-24
1,114 reads
Maaaaaagic Tables!!!
I had an interview earlier this week. An interview for a SQL developer position. It went fine. But. Question number X...
2011-03-24
2,380 reads
So you’re RAIDed, but are you protected?
G’day,
Occasionally, I hear things that surprise me. And one of the statements that I’ve heard lately that fits into that category is...
2011-03-24
390 reads
TechFuse Follow-Up
Last week I spoke at the TechFuse event in Minnesota – out at Mystic Lake Casino. As I mentioned in the...
2011-03-24
474 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Kapas Krampung No.Telp 083831617937
Whatsapp.083831617937 Jl. Kapas Krampung 126-126A-B Surabaya, Jawa Timur, Indonesia 60133
BCA KCP Kapasari No.Telp 083831617937
Whatsapp.083831617937 Jl. Kapasari 81, Kapasari, Kec. Genteng, Kota SBY, Jawa Timur Surabaya, Jawa Timur,...
BCA KCP Kapasan No.Telp 083831617937
Whatsapp.083831617937 Jl. Kapasan 155, RT.007/RW.09, Kapasan, Kec. Simokerto, Kota SBY, Jawa Timur Surabaya, Jawa...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers