Jake Manske (@jmanske) header
Jake Manske (@jmanske) profile picture

Jake Manske

@jmanske

Mathematician, developer, SQL performance enthusiast

concurrencyexchange.com
Joined March 2009
  • Tweets667
  • Following214
  • Followers87
81Media
Photo by Jake Manske (@jmanske)Photo by Jake Manske (@jmanske)Photo by Jake Manske (@jmanske)Photo by Jake Manske (@jmanske)Photo by Jake Manske (@jmanske)Photo by Jake Manske (@jmanske)Photo by Jake Manske (@jmanske)Photo by Jake Manske (@jmanske)Photo by Jake Manske (@jmanske)Photo by Jake Manske (@jmanske)
#sqlhelp does a parallel batch mode hash aggregate need a lot more memory than what SQL Server normally estimates? 44 billion row columnstore table. Query is simple: SELECT DISTINCT column_one, column_two. Data types are bigint and nvarchar(500). Optimizer guesses about 5 million unique combinations when in actuality there are about 2.5 million. Memory grant is 1.5 GB which seems like it ought to be enough to store the hash table based on the amount and size of the data. When it spills, it uses about 2TB of tempdb (it must be spilling the data pages of the table?) to avoid the spill, I actually need about 23GB of memory. Any explanation of this behavior would be helpful! When it spills, it gets to spill level 3 and reports about 263 million pages spilled.
2
4
462
Jake Manske retweeted
Curt Hogg (@CyrtHogg) profile picture
Curt Hogg@CyrtHogg16 Jan 2025
At the base of the Bob Uecker statue outside American Family Field right now: A single, unopened can of Miller Lite. “I must be in the front row.”
Image from Curt Hogg (@CyrtHogg)
165
2,497
171
19,422
1,839,918
SSMS 21 IS HERE!!! Download it now! techcommunity.microsoft.com/…
SSMS 21 Preview 1 release

SSMS 21 Preview 1 release

The SSMS 21 Preview 1 release is now available

techcommunity.microsoft.com
11
44
3
145
9,770
SSMS 21 Preview! learn.microsoft.com/en-us/sq…
2
4
270
Replying to @AnalyticAnna
@AnalyticAnna @erinstellato great presentation and awesome new features! When will SSMS 21 be available for preview (or generally)?
1
2
81
Ah never mind! I just found the blog post techcommunity.microsoft.com/…
SSMS 21 preview

SSMS 21 preview

SSMS 21 preview and copilot in SSMS

techcommunity.microsoft.com
1
53
Anyone who works in tech should read this new post from @erikdarlingdata about LLMs: erikdarling.com/everyone-kno…
Everyone Knows You Didn't Write That | Darling Data

Everyone Knows You Didn't Write That | Darling Data

SQL Server insights from Erik Darling. Want to get better at performance tuning, indexing, or query tuning? Try one of my online SQL courses.

erikdarling.com
6
10
662
Hey #sqlhelp if you’re still out there: When I am using incremental statistics to try to make it easier to maintain stats on a large partitioned table, why does it seem that some partitions do not get any stats? They have NULL for last_updated in dm_db_incremental_stats_internal.
1
1
1
176
Even if I issue UPDATE STATISTICS … WITH RESAMPLE ON PARTITIONS (14), partition 14 still isn’t getting any stats to contribute to the table-level histogram.
2
1
78
Home opener LFG
1
3
82
Anyone ever heard of SELECT @@SPID getting blocked for a non-trivial period of time? #sqlhelp
2
1
342
Now that SQL Server 2022 is GA, has there been any word on the street from the SQL Experiences team on GA for SSMS 19? #sqlhelp
3
Maybe @erinstellato @SysAdminDrew or @grrl_geek can give us a hint :)
1
Image from Jake Manske (@jmanske)
Hey @PASSDataSummit do we know when the pre con sessions will be revealed? It can help with us trying to plan PRs! Thanks!
It is not your patriotic duty to pay a billion dollars for gas to appease political leaders who don’t care about your suffering.
158
769
18
5,620
SSMS 18.10 is unusable for people who use it to review complicated query plans because of this bug. Upvote it if you want to see it fixed! feedback.azure.com/d365commu…
2
6
#sqlhelp is anyone experiencing this issue with SSMS 18.10 where ctrl+mouse wheel is “zoom in” on an execution plan, regardless of which direction I scroll? This is a pretty big bug for my workflows.
2
2
Tomorrow is the day! our first in-person meetup! (we'll still have an online link for virtual attendees) @SQLPhilUK is on deck presenting. plus 🍕🍻🥤 @MADPASS #SQLServer #aws @SQLSatMadison
Brijeet Akula (@brijeetAkula) profile pictureBrijeet Akula@brijeetAkula6 Oct 2021
well my friends.. @MADPASS is going to try out their first IN-PERSON meetup this month! (We will still livestream) @SQLPhilUK will be presenting on @awscloud RDS. Microsoft SQL workloads in AWS. join us for Food/drinks/networking/Gift card drawings! meetup.com/Madison-Data-Plat…
1
1
well my friends.. @MADPASS is going to try out their first IN-PERSON meetup this month! (We will still livestream) @SQLPhilUK will be presenting on @awscloud RDS. Microsoft SQL workloads in AWS. join us for Food/drinks/networking/Gift card drawings! meetup.com/Madison-Data-Plat…
1
1
2
Load more