|
|
|
|
Latest Blog Posts
-
|
In When Do SQL Server Sorts Rewind? I described how most sorts can only rewind when they contain at most one row. The exception is in-memory sorts, which can rewind at most 500 rows and 16KB of data. These are certainly tight restrictions, but we can...
|
-
|
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...
|
-
|
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...
|
-
|
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......
|
-
|
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...
|
-
|
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/...
|
-
|
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......
|
-
|
My blog here has moved to sql.kiwi Please update your bookmarks and other links....
|
-
|
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. 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...
|
-
|
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...
|
-
|
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...
|
-
|
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,...
|
-
|
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...
|
-
|
. 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...
|
-
|
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...
|
-
|
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!...
|
-
|
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 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! 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...
|
-
|
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...
|
-
|
I've been in the process of moving my blog for some time now. One thing lead to the other, among them changing my web-site from Window-based to Linux-based. But, that is behind me, and I have now moved my blog-posts. I am very grateful to Adam and Peter...
|
-
|
Which topics can you expect to see at the PASS Summit 2018 ? Find it out from June 12 to 13, 2018 at the 24 Hours of PASS - Summit 2018 Preview - edition. Register now at this link , thanks to the Sponsors , the 24 Hours of PASS is presented at no cost...
|
-
|
The Sessions of the event 24 Hours of PASS " Cross-Platform SQL Server Management " edition (held this April on 25 and 26) were recorded and now they are available for online streaming! If you have missed one session or the entire event, you can view...
|
-
|
The Service Pack 2 of SQL Server 2016 has been released! From the SQL Server Release Services, this service pack contains: Performance and scale improvements Supportability and diagnostics enhancements New improvements based on Connect feedback items...
|
|
|
|
|
|