sp_executesql Is Not Faster Than an Ad Hoc Query
This requires an immediate caveat. You should absolutely be using sp_executesql over any type of non-parameterized execution of T-SQL. You...
2016-11-07
1,205 reads
The Scary DBA
Reinforcing the Importance of Statistics on Row Estimate
I recently wrote an introductory post about the importance of statistics. I just received a reinforcement on how important they...
2016-11-10 (first published: 2016-11-03)
1,229 reads
Stored Procedures Are Not Faster Than Views
A performance tuning tip I saw recently said, “Views don’t perform as well as stored procedures.”
<sigh>
Let’s break this down, just...
2016-11-09 (first published: 2016-11-01)
3,726 reads
A Sub-Query Does Not Hurt Performance
The things you read on the internet, for example, “don’t use a sub-query because that hurts performance.”
Truly?
Where do people get...
2016-10-24
1,526 reads
SQL Cruise as a Speaker and Sponsor
SQL Cruise offers a number of unique opportunities for everyone involved, including speakers and sponsors. I’ve written before, severaltimes, about...
2016-10-28 (first published: 2016-10-18)
1,143 reads
SELECT * Does Not Hurt Performance
I read all the time how SELECT * hurts performance. I even see where people have said that you just have...
2016-10-25 (first published: 2016-10-17)
4,420 reads
Pre-Summit PASS Board Update
Busy, busy, busy.
A lot of the work around PASS currently is getting ready for Summit. I’m prepping my part in the...
2016-10-11
443 reads
Statistics Are Vital For Query Performance
This is post #10 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
When you send a query to your...
2016-10-19 (first published: 2016-10-10)
2,088 reads
Where Do We Go To Share?
No one reads blogs any more.
Twitter is dying.
Facebook is broken.
LinkedIn? Please.
G+. Is that even on any more?
Where do we go...
2016-10-05
485 reads
Correlated Datetime Columns
SQL Server is a deep and complex product. There’s always more to learn. For example, I had never heard of...
2016-10-13 (first published: 2016-10-03)
1,807 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Alamat Kantor BCA KCU Wisma Asia Telp:08218200174
Via Wa:628218200174 Alamat Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
Alamat Kantor BCA KCU Kebayoran Baru Telp:08218200174
Via Wa:628218200174 Alamat. Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
Alamat Kantor BCA KCU Wisma Millenia Telp:08218200174
Via Wa:628218200174 Alamat.Jalan Letjen M.T. Haryono No.Kav. 16 11, RT.11/RW.5, Tebet Bar., Kec. Tebet,...
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers