Office Hours: “Read This” Edition

SQL Server
1 Comment

Sometimes when people post questions at, the answer is just a link, nothing more, nothing less. It doesn’t make sense for me to rehash something that’s been covered really well online, and I want to link ’em to the best resource possible.

Petr: Huge slowdown of basic queries when using a partitioned table (Partition_Key = ‘YYYYMM’). Queries: select max(ID) from PartitionTable; select top (1) ID from PartitionTable order by ID desc; scans all partitions and then limits the result (Sort, Stream Aggreate). What with this?

Read this and this.

MyTeaGotCold: Outside of T-SQL and Postgres, what SQL implementations do you find that people take seriously? I can’t remember the last time I heard a good thing about Oracle.

Read this.

Kulstad: I’ve just run SP_BLITZ on one of my production servers, and Query Store Disabled came up as a Priority 200 on SSISDB. Do you recommend turning QueryStore on for SSISDB? Are there any special config options or “gotchas” that I should be aware of in doing so?

Watch this.

Brent Reading Book
“What do all these big words mean?”

Sylvie: Do you have a good way to see which deprecated features are used by a given TSQL query?

Read this.

ReadyToJump: You have said you are into software version control. I would like to jump to the bandwagon, where do I start? How can we do version control of stored procedures?

Watch these.

A Business Intelligence guy: Kind of off topic, but I’m building up my home bar and wanted your recommendation on a range of tequilas to consider. I seem to recall you have mentioned some in the past but I can’t seem to locate those mentions again

Try these. (That’s not a random Google link either – I like most of those.)

need for spid: Is memory-optimized tables a good fit to implement a queue table, where there are multiple producers and multiple consumers ? We don’t need the queue data to be persisted. Are there any drawbacks to consider ?

Use this or this or this.

chandwich: In the world of SQL Server data, the veterans tend to have the most influence, given their lengthy presence. So, how can a mid-20s SQL DBA stand out in a field ruled by these seasoned pros?

Read this.

chandwich: May I use the StackOverflow databases for reference on my website?

Read this.

bill keegan: What are the advantages / disadvantages of multiple mdf / ndf’s?

Watch this.

Previous Post
[Video] Office Hours: Having a Bad Day Edition
Next Post
The Real Problem with SQL Server’s Licensing Costs

1 Comment. Leave new

  • Oracle may be the most popular DB but that doesn’t mean that people choose Oracle because they like PSQL or take it seriously.
    Oracle: 100 positive points, we’ll have to live with having to use PSQL


Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.