Browse the archive
Question At what size should we consider applying Columnstore Index on a table? Is there a SQL Server storage or design guidance? Our Data Warehouse is 5TB total. Additionally, we have tables which are 100GB to 1TB which compose the database. Just curious if …
Continue readingQuestion I'm stuck in a way that how to do sum on a column let's say first column of a table (result from another query) without knowing the column name with something like column position id. it's something like this
Continue readingOn October 2, 2018 at 11PM EDT, I’ll be joined by John Q. Martin (blog|twitter) for a webinar on Azure SQL Database Managed Instance. To sign up, register here. You can access the recording of the session here. Follow-up Q & A from the live session can be …
Continue readingOn August 28, 2018 at 2PM EDT, I’ll be joining Melissa Connors (blog|twitter), Kevin Kline (blog|twitter), and Rob Sewell (blog|twitter) for a webinar on advanced SQL Server features. The webinar centers around a real-life case study of technology SentryOne …
Continue readingI was recently doing a training session when a developer commented that it was OK to run an expensive query twice because on the second execution, SQL Server would use the "results cache" and be "practically free". It's not the first time I've heard someone …
Continue readingI'm headed to SQLSaturdays in Louisville and Columbus for my first community events as Product Manager at SentryOne. While I'm there, I'm interested in talking with SentryOne users.
Continue readingIt’s been a little bit since the last T-SQL Tuesday I joined, when I blogged about religion & politics. This month, I answer Bert Wagner's call to blog about code I would hate to live without
Continue readingEarlier tonight, I sat down to install Reporting Services on my laptop. I haven’t played with SSRS 2017 yet, so I figured I’d poke around some. Much to my surprise, the configuration failed when creating the ReportServer database, reporting a deadlock. When I …
Continue readingConfigure SQL Server replication with availability groups and understand its supported publisher and subscriber roles.
Continue readingThe great tabs vs spaces debate is often framed as a matter of opinion or coding style. “As long as you’re consistent, it doesn’t matter.” Keep in mind that unlike your choice in footwear, coding style can’t be personal. I’m going to draw a line in the sand …
Continue reading
