SQL Developers Please Use the Table Name/Alias to Prefix Columns
Note: After I completed this post Aaron Bertrand added this subject to his “Bad Habits to Kick” series for myself...
2010-02-16
874 reads
Quick Tip Of The Day
Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do...
2010-02-16
2,601 reads
Review: Windows Live Writer Backup
Live Writer tends to be one of those applications that you spend a few minutes configuring and then you forget...
2010-02-16
580 reads
In Vs. Inner Join
This is tightly related to another of my forays into tuning some slowly/poorly performing processes. This process came across my...
2010-02-16
873 reads
Presenting in Colorado Springs on May 19, 2010
I will presenting at the Colorado Springs SQL Server User’s Group (CSSQLUG) on Wednesday, May 19, 2010. I will be...
2010-02-16
644 reads
Three Turns On The Road
Huh? My story? Okay. It was never easy for me. I was born a poor black child. I remember the...
2010-02-16
1,121 reads
nHibernate Database, First Look
I’m getting my first look at a full-fledged nHibernate database developed by consultants for our company. I thought I’d share...
2010-02-15
1,300 reads
Finding Blog Topics
I used to think that I would run out of things to write about, but a decade after starting to...
2010-02-15
878 reads
The PASS Acquisition of SQL Saturday
A couple of weeks ago, it was announced that the SQL Saturday franchise was voluntarily transferred to PASS . This change...
2010-02-15
1,177 reads
Windows 7 Presentation Mode
Recently I was just killing a few minutes and was looking for some tips for Windows 7. I get along...
2010-02-15
611 reads
Blogs
Stanford Emerging Technology Review 2026 Report is out
By Brian Kelley
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue...
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
By ReviewMyDB
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I...
Forums
Test topic for spam filtering
A new thread for testing the spam filter. Adding a link: https://www.bbc.co.uk/weather
Removing production permissions when restoring database to non-prod
Hello experts, An application team has asked us to modify a SQL Agent job....
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...