(lukaseder) B-Tree indexes are perfect when your data is uniformly distributed. They are not really useful, when you have skewed data.
Tag: sql server
(Hannes du Preez) You can create an HTML Table with SQL. You make use of the ‘FOR XML RAW’ and ‘FOR XML PATH’ statements to organize the Table Body (TBODY), Table Header (THEAD) and Table Footer (TFOOT).
(Chris Webb) A few weeks ago I received a great tip from Simon Nuss about a Power Query feature relating to ODBC data sources that I hadn’t seen before (although it’s in Power BI Desktop and Excel 365, so it can’t be that new) and which is potentially important for the performance of data refresh an
SQL SERVER – FIX: Msg 41105: Failed to Create the Windows Server Failover Clustering (WSFC) Resource With Name and Type ‘SQL Server Availability Group’
(Pinal Dave) Sometimes there are errors which give us the solution to the problem and I love to discover other ways to fix it.
(Kenneth Fisher) Sometimes you need a table that is read only. You don’t want anyone to be able to write to it for various reasons.
(Melissa Coates) This post covers several things I’ve heard or been asked recently about organizing data in a data lake.
(Jose M Jurado) Time ago, we discussed in this post about partitioning option in Azure SQL Database.
(Ameena Lalani) Your company’s business is to host databases that require uptime of 24x7x365 days per year. Your company has invested a lot in building solid infrastructure with lots of redundancy at the VM host level and network level.
(Jason Brimhall) Cool new toys/tools have been made available to the data professional. Among these tools are query data store and automatic tuning. These two tools actually go hand in hand and work pretty nicely together.
(blobeater) You will very likely know that SQL Server 2008 / R2 end of support is on July 9th 2019. Not that long to start thinking about and assessing your options.