When Have You Used MOT Tables? T-SQL Tuesday #117
Steve Jones (b/t) is our host for T-SQL Tuesday and in case you didn’t know has taken over running T-SQL ... Continue reading
2019-08-13
224 reads
SQLStudies
Temporary stored procedures
tl;dr; Temporary stored procedures are excellent for testing pieces of code that are going to go into (or come from) ... Continue reading
2019-08-21 (first published: 2019-08-07)
917 reads
SQL Homework – August 2019 – Getting the data out
Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading
2019-08-16 (first published: 2019-08-05)
325 reads
Header Query Crossword
I did an interesting form of crossword recently and since I haven’t done one in a while I figured this ... Continue reading
2019-07-31
57 reads
Optional vs Required parameters in Stored Procedures
If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain ... Continue reading
2019-07-29
172 reads
Custom error messages
I’m sure lots of you have used the function RAISERROR to handle an error caused by your code. The problem ... Continue reading
2019-07-24
38 reads
Current database vs database locks
I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is ... Continue reading
2019-07-22
299 reads
Is it just me or does msdb feel a lot like a user database?
When you think of system databases, tables, etc there are a number of things you might think of. Necessary to ... Continue reading
2019-08-07 (first published: 2019-07-17)
660 reads
Short circuiting an AND
The other day I did a post on how an OR short circuts. It was a somewhat unusual type of ... Continue reading
2019-08-06 (first published: 2019-07-15)
717 reads
Learning Powershell with Show-Command
Years ago I blogged about how I like to use the SSMS scripting feature to learn how to do things. ... Continue reading
2019-08-01 (first published: 2019-07-11)
867 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
FARE Lab's Leading FSSAI Third Party Auditing Services
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
FARE Labs is The Leading FSSAI Third Party Auditing Services of India.
If you are looking for India’s best FSSAI Third Party Auditing Services in India....
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers