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,728 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,531 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,090 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,811 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers