No Shrink-y Tempdb
I caught the end of a Twitter conversation the other day between Wes Brown (Blog | @WesBrownSQL), Paul Randal (blog | @PaulRandal),...
2011-05-26
1,608 reads
Blog Posts
Random Ordering of Results using NEWID
A discussion of how NEWID can be used to help randomize the results returned from a SQL query.
A scenario I...
2011-05-26
1,147 reads
SQL Server, Storage and You Part 2!
I saw 500 faces an rocked them all!
To those who attended my webinar today THANK YOU! If you didn’t…. There...
2011-05-26
651 reads
SQL University Troubleshooting Week: Keeping an Open Mind
Office politics during a major event can be dangerous. It pays to be seen as contributing to solving the problem...
2011-05-26
761 reads
SQLRally 2011 Women in Technology Luncheon
On May 12, during the first-ever SQLRally , we held the first-ever SQLRally Women in Technology luncheon! I moderated, and our...
2011-05-26
1,015 reads
SSRS Error: Unable to connect to remote server error
One fine day when I tried to connect to one of my staging report server I got the
“Unable to connect...
2011-05-26
5,342 reads
Survival Mode & Dodging Burn Out
One of the benefits of experience is that you can see problems coming, that doesn’t mean you have enough experience...
2011-05-26
736 reads
ABL: Always Be Learning
If you have been in the IT field for any length of time, I’m sure you have heard the phrase...
2011-05-25
1,533 reads
devLINK Technical Conference to be Held in Chattanooga, TN, August 17-19
This year’s devLINK Technical Conference will be held at the Chattanooga Convention Center, Chattanooga, TN this upcoming August 17-19, 2011....
2011-05-25
642 reads
Efficiency of Subqueries and OR conditions in SQL
A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.
SQL queries...
2011-05-25
953 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
Kantor Cabang BCA Mall Kelapa Gading Telpon/WA:.085188120691
Kantor Cabang BCA Mall Kelapa Gading Telpon/WA:.085188120691 Mall Kelapa Gading 3, Jl. Sanur Raya...
BCA KCP Harmoni Plaza Telp:08213111109
Ruko Harmoni Plaza Blok B No. 26-27, Jl. Suryopranoto No.2, Daerah Khusus Ibukota Jakarta...
BCA KCU ALAM SUTERA Telp:cs.(0821)8171955
Whatsapp:08218171955 Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec. Serpong, Kota Tangerang...
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