We have a discount code for last-minute attendees looking to go to our exciting preconference training session at this year’s SQL Saturday Atlanta on May 17th, 2019, called “Level...
2019-05-01
17 reads
As you may all know, having up to date index statistics is the key to make sure the query optimizer can choose the most optimal execution plan for any...
2019-05-01
169 reads
FIRST OF A TWO PART SERIES Some months ago, a fellow DBA came to me and expressed her concern over the normal housecleaning process that occurred at her company. ...
2019-05-01 (first published: 2019-04-17)
691 reads
Yes, it’s that time again. Time to do your homework. This month your homework is to set up the DAC ... Continue reading
2019-05-01
20 reads
I have a shorter post this week, but I reckon it’s an interesting story. As part of the new Intelligent Query Processing improvements introduced in the upcoming SQL Server...
2019-05-01
47 reads
I’m giving another webcast through MSSQLTips.com. This one is on May 9, 2019, at 3 PM EDT. It’s called Auditing SQL Server from the Ground Up. You can register...
2019-05-01
36 reads
It’s been long time ago I published the last article. I had exams at school and worked hard to pass and have a good grades. Now I have some...
2019-04-30
21 reads
My friend Andy Leonard has written an excellent blog series on getting SSIS up & running in a Docker container. I would never have even tried to go down...
2019-04-30
34 reads
My friend Andy Leonard has written an excellent blog series on getting SSIS up & running in a Docker container. I would never have even tried to go down...
2019-04-30
13 reads
Watch this week's video on YouTube
When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs:
WHERE Col1 IN...
2019-04-30
14 reads
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers