SQLblog.com - The SQL Server blog spot on the web

Time 2020-09-14 03:02:37

Web Name: SQLblog.com - The SQL Server blog spot on the web

WebSite: http://sqlblog.com

ID:45712

Keywords:

SQL,Server,The,

Description:

SQL Server 2019 Aggregate Splitting The SQL Server 2019 query optimizer has a new trick available to improve the performance of large aggregations. The new exploration abilities are encoded in two new closely-related optimizer rules: GbAggSplitToRanges SelOnGbAggSplitToRanges The extended... A bug with Halloween Protection and the OUTPUT Clause Background The OUTPUT clause can be used to return results from an INSERT , UPDATE , DELETE , or MERGE statement. The data can be returned to the client, inserted to a table, or both. There are two ways to add OUTPUT data to a table: Using OUTPUT INTO... How MAXDOP Really Works A few days ago I ran a Twitter poll: The most popular answer gets highlighted by Twitter at the end of the poll, but as with many things on social media, that doesn’t mean it is correct: Continue reading...... Pulling Group By Above a Join One of the transformations available to the SQL Server query optimizer is pulling a logical Group By (and any associated aggregates) above a Join . Visually, this means transforming a tree of logical operations from: …to this: The above diagrams are logical... UPDATEs missing WHERE The other day I wrote a quick post about UPDATE statements where you didn't select the whole WHERE clause. Published it today. http://blogs.lobsterpot.com.au/2020/05/14/avoiding-the-where-clause-wasnt-selected-problem/... Blog post about patching docker Over at http://blogs.lobsterpot.com.au/2020/05/08/patching-sql-in-docker/ I blogged about patching my local copy of SQL Server, which is running in docker...... 24 Hours of PASS (April 2019): 20 Years of PASS! The next 24 Hours of PASS will have the opportunity to celebrate the first 20 years of the international association of professionals and data management experts. PASS is the acronym of Professional Association of SQL Server, PASS was established on 1999... Data Quake Data Quake. That's what it is. Dave Wells have just gave this great definition that clearly describes what's happening in the data management world during the recent years. I am greatly enjoying Dave’s session today at Enterprise Data World summit and... Read, Enrich and Transform Data with AWS Glue Service More and more companies are aiming to move away from managing their own servers and moving towards a cloud platform. Going serverless offers a lot of benefits like lower administrative overhead and server costs. In the serverless architecture, developers... SQL Server Data Migration: Tools and Services The Database Migration Team of the SQL Server Product Group has created the following tools and services to facilitate migration between different versions of SQL Server or between on-premises and SQL Azure DB in the cloud (but not only)! Azure Database... SQL Saturday Pordenone is back! Discover the 2019 edition! Another SQL Saturday has been scheduled in Pordenone (Italy), it will be the SQL Saturday #829 , as last year it will be an international event with international speakers and some sessions in English language! SQL Saturday Pordenone 2019 will be on february,... Compare SQL Server, MySQL and PostgreSQL Features Have you ever wondered how MySQL and PostgreSQL are different? Take a look at the mapping that I have made for myself: https://www.mssqltips.com/sqlservertip/5745/compare-sql-server-mysql-and-postgresql-features/ I would be happy to see comments posted... Discover how SQL Server can use Python to access any NoSQL engine . Many companies these days keep their data assets in multiple data stores. Many companies that I have worked at have used other database systems alongside SQL Server, such as PostgreSQL instances, Redis, Elasticsearch or Couchbase. There are situations... My AWS Aurora Postgres instance is 100% CPU. What’s next? I had to investigate today situation when my AWS Aurora PostgreSQL instance CPU was 100%. I have started to search for a root cause at the database statistic views level. There is a view pg_stat_activity which shows information related to the current... The 3rd edition of the ebook SQL Server Execution Plans From Redgate website you can download (for free) the ebook SQL Server Execution Plans written by Grant Fritchey and technically reviewed by Hugo Kornelis . This ebook can not be miss in your digital library! Enjoy!... SQL Saturday Parma is back! Discover the 2018 edition! Another SQL Saturday has been scheduled in Parma (Italy), it will be the SQL Saturday #777 . This year it will be an international event with international speakers and an entire track in English language ! SQL Saturday Parma 2018 will be on November,... Microsoft Docs and Localization Community Platform Microsoft Docs is the new platform for sharing high quality technical documentation about Microsoft technologies and related products. The documentation is hosted on GitHub and it is open to changes. Now, technical communities around the world have the... PASS Summit is back! Let's talk about the 2018 edition! PASS Summit is back! This year, the most important event around the world about Microsoft Data Platform will be held again in Seattle (WA) from 6 to 9 of November 2018 and it will be preceded from two pre-conference days at November 5 and 6. Every year... 24 Hours of PASS (June 2018) - Recordings now available! The sessions of the event 24 Hours of PASS Summit Preview edition (held this June on 12 and 13) were recorded and now they are available for streaming on-demand! If you have missed one session or the entire event, you can view or review your preferred...

TAGS:SQL Server The 

<<< Thank you for your visit >>>

SQL Blog

Hot Websites