Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Blog Directory  >  Software Blogs  >  Programming Blogs  > - The SQL Server blog spot on the web programming Blog  > - The Sql Server Blog Spot On The Web Blog
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-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
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
How MAXDOP Really Works
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
Pulling Group By Above A Join
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.… Read More
2020-05-08 02:03
Over at 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 Please update your bookmarks and other links....(read more) 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
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-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 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-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-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-01 17:05
I recently published a new blog post on SQLBI.You can read it at this link: 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-05 14:55
Blog has been moved to: Follow me on twitter: 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
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-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-11-29 00:28
Slides and scripts are now up from today's webinar. Thanks to all who attended!...(read more) 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-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: This blog has moved to There will be no further posts on… Read More
2017-11-03 03:47
You can read this blog post at this link: This blog has moved to There will be no further posts on… Read More
2017-11-02 03:48
You can read this blog post at this link: This blog has moved to There will be no further posts on… Read More
2017-11-01 01:48
You can read this blog post at this link: This blog has moved to 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! Please also stop by the DB Best booth if you're at the PASS Summit this week! https://www.even… 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-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-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 ....(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: You can read the post from DB Best, linked to above, or fol… 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

Share the post - The SQL Server blog spot on the web


Subscribe to - The Sql Server Blog Spot On The Web

Get updates delivered right to your inbox!

Thank you for your subscription