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?
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.
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?
Sylvie: Do you have a good way to see which deprecated features are used by a given TSQL query?
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?
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 ?
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?
chandwich: May I use the StackOverflow databases for reference on my website?
bill keegan: What are the advantages / disadvantages of multiple mdf / ndf’s?