2020-10-19 05:56
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… Read More
Blog Directory > Software Blogs > Programming Blogs > SQLblog.com - The SQL Server blog spot on the web programming Blog >
Sqlblog.com - The Sql Server Blog Spot On The Web Blog
sqlblog.com
Tags:
insert
association
closest
twitter
docker
schema
join nested loops
query optimizer
management
join nested
SQL Blog - Blogs about SQL Server, T-SQL, CLR, Service Broker, Integration Services, Reporting, Analysis Services, Business Intelligence, XML, SQL Scripts, best practices, database development, database administration, and programming
2020-08-03 18:16
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… Read More
2020-08-03 18:10
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 ar… Read More
2020-08-03 18:04
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 cor… Read More
2020-08-03 17:49
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 o… Read More
2020-05-14 02:10
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-cl… Read More
2020-05-08 02:03
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 Read More
2019-04-15 13:08
My blog here has moved to sql.kiwi Please update your bookmarks and other links....(read more) Read More
2019-03-24 22:56
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 Prof… Read More
2019-03-18 01:30
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… Read More
2019-03-14 14:48
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 overh… Read More
2019-01-19 16:07
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-p… Read More
2019-01-05 15:21
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 i… Read More
2018-10-29 15:33
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-an… Read More
2018-10-26 22:04
.
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 PostgreS… Read More
2018-10-26 21:38
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 &hell…Read More
2018-10-24 21:10
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 d… Read More
2018-10-05 18:46
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 Engl… Read More
2018-09-14 21:30
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… Read More
2018-07-21 21:46
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 precede… Read More
2018-06-21 23:50
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… Read More
2018-06-06 09:26
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 hav… Read More
2018-06-03 13:24
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 l… Read More
2018-04-30 20:05
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… Read More
2018-04-29 15:39
https://www.joincosmosdb.com/...(read more) Read More
2018-04-28 13:43
The Service Pack 2 of SQL Server 2016 has been released!From the SQL Server Release Services, this service pack contains:Performance and scale improvementsSupportability and diagnostics… Read More
2018-04-27 17:13
Microsoft has greatly improved the Cosmos DB documentation making it much easier to learn and get started. Check it out at https://docs.microsoft.com/en-us/azure/cosmos-db/...(read more) Read More
2018-04-05 19:22
Microsoft has a new set of on demand webinars to teach you how to use Azure Cosmos DB. Register for them here . You can download the latest version of the Cosmos DB emulator from here . I li… Read More
2018-04-05 15:14
-- this is my version of sp_updatestats Some of you know that SQL Server has a problem with the way statistics are sampled. Indexes in which the lead column is not unique can be adversely af… Read More
2018-04-04 11:40
The Data Modeling for Power BI training is now available as a video recorded course, including exercises!Take advantage of the launch offer until April 17, 2018.Read more about this:Why Data… Read More
2018-03-20 16:09
I recently published a new blog post on SQLBI.You can read it at this link: https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/ Read More
2018-03-17 18:09
You have certainly already heard about the new European Regulation 679/2016, better known as GDPR, on the protection of personal data. GDPR is the acronym of General Data Protection Reg… Read More
2018-03-14 20:49
The company I work for, Perion, chose Amazon Web Services as a main cloud provider for managing and operating our applications. These days I am learning how to manage databases and data rela… Read More
2018-03-08 18:48
For the last twenty years, the standard practice has been to scale server performance with multi-processor (MP) systems. What is not widely understood is that after processors integrated the… Read More
2018-02-23 23:20
--my extension of sp_helpindex: sp_helpindex2 USE master GO IF EXISTS ( SELECT * FROM sys . procedures WHERE object_id = OBJECT_ID ( 'sp_helpindex2' ) ) DROP procedure [dbo] . sp_helpindex2… Read More
2018-02-23 23:08
-- sp_spaceused2 USE master GO IF EXISTS ( SELECT * FROM sys . procedures WHERE object_id = OBJECT_ID ( 'sp_spaceused2' ) ) DROP procedure [dbo] . sp_spaceused2 GO CREATE PROCEDURE [dbo] . [… Read More
2018-02-20 18:50
Most Intel processors use one of two cores, the main-line core and the Atom core. Desktop processors might use the newer Kaby Lake or Coffee Lake micro-architecture cores, while the Xeon SP… Read More
2018-02-09 22:18
SQL Server has always provided tools to manage hierarchies and relationships, facilitating query execution on hierarchical data, but sometimes relationships can become complex. Think about m… Read More
2018-02-08 16:15
The huge disparity between round-trip access to DRAM memory and the CPU clock cycle has been a serious problem for more than ten years. It is simple to demonstrate that even a small amount o… Read More
2018-02-07 14:06
I recently published a new blog post on SQLBI.You can read it at this link: https://www.sqlbi.com/blog/marco/2018/02/06/the-new-data-modeling-for-power-bi-course/ Read More
2018-02-06 14:38
T-SQL Tuesday #99 invitation......(read more) Read More
2018-02-01 17:05
I recently published a new blog post on SQLBI.You can read it at this link: https://www.sqlbi.com/blog/marco/2018/02/01/power-pivot-utilities-1-09/ Read More
2018-01-26 17:08
I recently published a new blog post on SQLBI.You can read it at this link: https://www.sqlbi.com/blog/marco/2018/01/26/why-i-attend-conferences-and-why-i-speak-at-conferences/ Read More
2018-01-19 21:01
Microsoft has released the following Cumulative Updates for SQL Server:Cumulative Update 3 for SQL Server 2017 RTMKB 4052987DownloadBuild number: 14.0.3015.40SQL Release Services Blog P… Read More
2018-01-19 12:50
I've moved my content over to sqlblog.org . Read more details......(read more) Read More
2018-01-12 08:45
Another SQL Saturday has been scheduled in Pordenone (Italy), it will be the SQL Saturday #707, as last year it will be an international event with international speakers and several se… Read More
2018-01-11 17:07
there is some degree of press hysteria, lawsuits etc. concerning the kernel vulnerabilities of Intel processors with out-of-order execution (which originates to Pentium Pro), so I did a quic… Read More
2018-01-08 23:24
The pain of parting is nothing to the joy of meeting again - Charles Dickens It amazes me, but I have blogged here for over 11 years. My first post was about some new functionality in SQL Se… Read More
2018-01-05 14:55
Blog has been moved to: jorgklein.com Follow me on twitter: twitter.com/jorg__klein Read More
2018-01-04 05:03
Going home y'all. On January 13th, I will be speaking at the Nashville SQL Saturday. I moved from Nashville less than 1 year ago, and I always look forward to making a trip up (and not just… Read More
2018-01-03 23:06
From Microsoft-Docs on GitHub: Azure Data Lake Store is an enterprise-wide hyper-scale repository for big data analytic workloads. Azure Data Lake enables you to capture data of any size, ty… Read More
2018-01-02 01:27
SQL Server Replication usually works just fine when testing in a development environment where there’s low latency and high bandwidth. Real world conditions aren’t always like th… Read More
2017-12-27 17:09
I recently published a new blog post on SQLBI.You can read it at this link: https://www.sqlbi.com/blog/marco/2017/12/27/what-has-happened-in-the-dax-world-in-2017/ Read More
2017-12-26 19:00
Standardizing on 2 and 4 sockets systems for servers has been an established practice going back to 1996. There were very good reasons for this, but it was so long ago that they have been fo… Read More
2017-12-19 09:19
You can read this blog post at this link: https://jorgklein.com/2017/12/19/multi-source-partitioned-azure-analysis-services-tables-cold-data-from-azure-data-lake-store-hot-data-from-azure-sq… Read More
2017-12-17 13:28
Every cloud provider these days have a serverless interactive query service that uses standard SQL for data analysis.
As for the biggest cloud providers, we have Azure Data Lake analytics… Read More
2017-12-14 23:07
On an otherwise unremarkable day, almost twelve years ago (early 2006 to be exact), I got an email from Adam Machanic . I don’t have it anymore, but I do remember the management summar… Read More
2017-12-12 13:54
To install PolyBase on SQL Server 2016 or 2917, there is a dependency on the Oracle Java Runtime Environment (JRE). Oracle made a breaking change to the JRE from version 8 to 9. I published… Read More
2017-12-11 20:02
(Part 2 of 2 -about and for Speakers.) In the previous article, Speakers were acknowledged for their dedication, passion, sacrifices, and contributions to the global SQL Server community, gr… Read More
2017-12-07 03:32
(Part 1 of 2 -about and for Speakers.) The SQL Server community stands out as one of the most open, sharing, and giving technology communities. Around the world, there are active and robust… Read More
2017-12-04 13:48
Please take a minute and check this brief introduction of our wonderful gold, silver, and bronze sponsors. Comtrade is a dynamic and well established technology group, with a 25-year track… Read More
2017-11-29 07:18
If you want to join the event and you are not registered yet, this is the time to register. We are nearly full, opening the wait list soon. You can find the link to the registration at the e… Read More
2017-11-29 00:28
Slides and scripts are now up from today's webinar. https://www.dbbest.com/blog/webinar-2-6-followup-episode-9-fragmentation/ Thanks to all who attended!...(read more) Read More
2017-11-25 17:10
I recently published a new blog post on SQLBI.You can read it at this link: https://www.sqlbi.com/blog/marco/2017/11/25/using-treatas-in-place-of-in-in-dax/ Read More
2017-11-24 19:30
Microsoft has released the following Cumulative Updates for SQL Server 2016 (RTM and SP1).Cumulative Update 9 for SQL Server 2016 RTMKB 4037357 Download Build number: 13.0.2216.0 S… Read More
2017-11-22 13:42
While the Cosmos DB emulator is a great way to learn Cosmos DB, it’s better to work directly with the full Cosmos DB service in Microsoft Azure. Previously this was a barrier to learni… Read More
2017-11-17 21:37
Another PASS Summit has passed, and I have had a bit of time to consider what I want to do with the time of the week that "normal" people call "free time." While during November and December… Read More
2017-11-14 17:12
Check out my new post on some of the people who helped shaped my career: The Career Influence of Usenet Strangers (T-SQL Tuesday #096)...(read more) Read More
2017-11-12 19:31
For a feature we’re developing in Sensoria, we had to solve one of the well-know, yet hard to solve, problem with data and relationships between elements in a data set. While there are… Read More
2017-11-08 07:27
PASS took almost all my “free” time and I quite forgot to write a quick post to let you know that tomorrow November 8th (so I’m just right on time!) Dino Esposito – t… Read More
2017-11-07 20:54
Slides and scripts are now up from today's webinar. https://www.dbbest.com/blog/webinar-2-3-follow-episode-6...(read more) Read More
2017-11-07 10:39
Several days ago I have spent a few hours of my life figuring out how to do dynamic pivot in Amazon Redshift. To tell you the truth, I have expected much more from this DBMS SQL language… Read More
2017-11-06 03:53
Ah, back home in my comfy work chair, feet up surrounded by the warm glow of computer monitors with the football game on (and at the right time, not 3 hours too early!) It was quite a week… Read More
2017-11-04 01:47
You can read this blog post at this link: https://jorgklein.com/2017/11/04/pass-summit-2017-day-3/ This blog has moved to https://jorgklein.com There will be no further posts on sqlblog.com… Read More
2017-11-03 03:47
You can read this blog post at this link: https://jorgklein.com/2017/11/03/pass-summit-2017-day-2/ This blog has moved to https://jorgklein.com There will be no further posts on sqlblog.com… Read More
2017-11-02 03:48
You can read this blog post at this link: https://jorgklein.com/2017/11/02/pass-summit-2017-day-1/ This blog has moved to https://jorgklein.com There will be no further posts on sqlblog.com… Read More
2017-11-01 01:48
You can read this blog post at this link: https://jorgklein.com/2017/10/31/pass-summit-2017-highlights-on-this-blog/ This blog has moved to https://jorgklein.com There will be no further po… Read More
2017-10-31 07:13
Wow, it's been over a year now since I made my second round of foolish promises and plans . Now I take a quick pass at saying how I did at these promises before the major annual gathering of… Read More
2017-10-30 18:40
It's not just about performance tuning! https://www.dbbest.com/blog/learn-sql-server-internals/ Please also stop by the DB Best booth if you're at the PASS Summit this week! https://www.even… Read More
2017-10-23 20:30
I am presenting my entire SQL Server Internals training online, an hour at a time, though DB Best. Check my blog there regularly for follow-up information including the slides and scripts, a… Read More
2017-10-20 14:17
Hi SQL Folks, I just written a blog post about the functions and hidden gems in the USQL Summer Refresh 2017
Take a look there.
and tell me what you think!!! Read More
2017-10-17 02:04
Deep breath. There is two weeks and two day before the PASS Summit. And like the past few years, I didn't submit any sessions, so those three days will be nonstop learning and chilling with… Read More
2017-10-11 23:53
For many years now, I’ve been hosting my blog at sqlblog.com. I can’t thank my old friends Adam Machanic and Peter DeBetta enough for starting SQL Blog and for providing many of… Read More
2017-10-11 17:54
I recently published a new blog post on SQLBI.You can read it at this link: https://www.sqlbi.com/blog/marco/2017/10/10/offline-model-editor-experience-for-power-bi/ Read More
2017-10-11 12:19
You can read this blog post at this link: https://jorgklein.com/2017/10/11/azure-analysis-services-scheduled-autoscaling/ This blog has moved to https://jorgklein.com There will be no furth… Read More
2017-10-10 13:49
The latest version of SSMS ( SQL Server Management Studio 17.3 ) is now available to download. There are a bunch of new features in addition to the usual bug fixes but some of the mor… Read More
2017-10-10 10:50
We all know that Profiler and its background functionality SQL Trace has been deprecated since 2012. Right? And we have all switched to using Extended Events (XE), a long time ago, right? No… Read More
2017-10-10 07:54
Trends come along, and trends pass. Some hang around for quite a while, and then move on, and some seem to disappear quickly. Often we’re glad that they’ve gone, but we still bea… Read More
2017-10-07 20:42
The Service Pack 4 of SQL Server 2012 has been released!This service pack contains:More than 20 improvements around performance and scalabilityAll fixes released up to and includin… Read More
2017-10-03 22:23
Another month, another session for the PASS Application Development VG. This time I will be both the host and the guest :), talking about something is very close to my interests and, I think… Read More
2017-10-02 17:02
Call for speakers for our event is closed. Now we have the hardest work. Out of 150 submitted fantastic session proposals, we need to select only 30. You can see a nice graphical summary of… Read More
2017-10-02 15:39
I recently published a new blog post on SQLBI.
You can read it at this link: https://www.sqlbi.com/blog/marco/2017/10/02/why-data-modeling-is-important-in-powerbi/ Read More
2017-10-02 13:07
The first event on my Fall tour is behind me now. I had a wonderful time at SQL Saturday Holland. A couple of great questions came up that should lead to blog posts soon! Slides and scripts… Read More
2017-10-01 14:45
Sign up for the new edX course Developing Planet-Scale Applications in Azure Cosmos DB at https://www.edx.org/course/developing-planet-scale-applications-microsoft-dat237x ....(read more) Read More
2017-09-29 16:09
Microsoft just announced a new serving model for SQL Server starting with SQL 2017. The link below goes into much more detail so I won’t duplicate that here. However in a nutshe… Read More
2017-09-27 23:36
I'm taking off tomorrow for Holland, UK, Denmark, Germany and Israel: https://www.dbbest.com/blog/im-leaving-jet-plane/#more-11622 You can read the post from DB Best, linked to above, or fol… Read More
2017-09-27 02:49
For years, I had thought (and was probably taught in SQL.AlongTimeAgoInAPlaceFarFarAway) that the timestamp column (well before rowversion was a thing,) was not guaranteed to be an ever incr… Read More
2017-09-26 14:41
You can read this blog post on jorgklein.com: https://jorgklein.com/2017/09/26/azure-data-factory-and-ssis-better-together-with-adf-v2-preview/ Read More
2017-09-24 01:01
Another SQL Saturday has been scheduled in Parma (Italy), it's the SQL Saturday #675 and this year it will be more international than the previous editions because there will be six ses… Read More
2017-09-20 18:50
(This article was originally published at https://www.dbbest.com/blog/ Long ago (in SQL Server years) many metadata changes were implemented with special one-off stored procedures. For examp… Read More
Subscribe to Sqlblog.com - The Sql Server Blog Spot On The Web
Get updates delivered right to your inbox!