DBA 101: Altering a column
People always ask me what tools I use. Mostly this question comes from the topic of monitoring. I can honestly...
2017-02-06 (first published: 2017-02-02)
2,222 reads
Daniel Janik
Query tuning 101: Non-trusted Foreign Keys
Foreign keys are an interesting feature of relational databases. They help enforce data integrity, sometimes help improve performance by eliminating...
2017-01-05 (first published: 2016-12-30)
3,544 reads
Off topic: The two cycle engine and your career path
I’ve been in technology for twenty years now. I’ve seen hundreds of environments, nearly 300 while employed at Microsoft alone.
One...
2016-12-30
778 reads
Using Memory Optimized tables for reporting
I recently worked on a project for fraud. This project needed to relate 67 million accounts to one another “Kevin...
2016-12-27
1,304 reads
What keeps clearing my query stats?
I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface...
2016-12-27 (first published: 2016-12-08)
2,001 reads
Query Tuning 101: Debugging a procedure
I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds...
2016-12-15 (first published: 2016-11-30)
4,390 reads
Nintendo NES Classic Edition giveaway! #SQLFamily
I’ve managed to get my hands on a Nintendo NES Classic and I’m going to give it away. The details...
2016-12-13
701 reads
Query tuning 101: How to measure Query Plan I/O cost
If you’re a DBA or a developer chances are you’ve looked at a query plan or two. While looking at...
2016-11-23 (first published: 2016-11-18)
3,317 reads
Query tuning 101: Problems with IN ()
If you’re a DBA or database developer, chances are you will have to write or rewrite queries from time to...
2016-11-14 (first published: 2016-11-10)
5,702 reads
Why Halloween slowed your queries
Let me start by saying that this isn’t your typical post about the Halloween problem. This is intended to describe...
2016-10-31
982 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers