Office Hours: “Read This” Edition

Sometimes when people post questions at https://pollgab.com/room/brento, 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.

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.