Improving Cardinality Estimation: Answers & Discussion
Your challenge for last week was to take this Stack Overflow database query to show the top-ranking users in the most popular location:CREATE INDEX Location ON dbo.Users(Location); GO CREATE OR ALTER PROC dbo.GetTopUsersInTopLocation AS SELECT TOP 200 …
Attention SQLBits 2024 Attendees!
Get ready to soar into SQLBits 2024 with us in Farnborough, UK March 19th – 23rd! Join keynote speaker, Asad Khan, General Manager of SQL, along with leading SQL experts from Microsoft including, Bob Ward, Rie Merrit, Buck Woody, Muazma Zahid, and Erin …
Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, Inverse and more
The post Scientific Calculations in Power BI – Cube, Square, Logarithms, Powers, Inverse and more appeared first on SQLServerCentral.
The Last Ticket/Issue I Closed #TSQL2sday
For this month’s T-SQL Tuesday, I asked y’all to write about the most recent ticket or issue that you closed. (If you want to see other peoples’ posts, you can check out the comments on that invite post, or wait til next week and I …
SQL ConstantCare® Population Report: Winter 2023
The short story: SQL Server 2019 continues its utter domination of the Microsoft data platform landscape this quarter. The long story: ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adop …
Leave it better than you found it
This is for the folks who still have to log into remote machines and do work manually on the box. Yes, we still exist, and we will for as long as we’re still using physical servers in data centers and even IaaS. Not everyone has transitioned to s …
Writing SQL Server code with AI using GitHub Copilot
Introduction In this article, we will see how to work with GitHub Copilot. GitHub copilot is an interesting plug-in that generates code using AI. The technology is from Microsoft and OpenAI. We will show how to install Copilot, and how to generate SQL …
Planning a Database Testing Strategy for Flyway
The post Planning a Database Testing Strategy for Flyway appeared first on SQLServerCentral.
Automating BCP with PowerShell
I was talking with a good friend that has an environment with terabytes of information and to create a homolog or dev environment to him is a pain. He comes to me with a solution : A PowerShell script that gets only the first 1000 lines of each table, …
[Video] Office Hours: Lumberjack Edition
On a chilly January day, I went through your top-voted questions from https://pollgab.com/room/brento. Yes, it actually gets cold in Vegas! It’s sub-freezing overnight before the sun comes out each day. Here’s what we covered: 00:00 Start 0 …
Fun with Powershell
The post Fun with Powershell appeared first on SQLServerCentral.
Use a Table Variable for Logging Entries that Need to Survive Rollbacks.
Introduction Table variables are special types of local variables that can be used to store data temporarily, similar in many ways to temporary tables in SQL Server but they are intended for a different purpose. Temporary tables are physical tables sto …
LangChain Prompt Templates with OpenAI LLMs
The post LangChain Prompt Templates with OpenAI LLMs appeared first on SQLServerCentral.
Query Exercise: Improving Cardinality Estimation
Your challenge for this week is to tune a query. Say Stack Overflow has a dashboard that shows the top-ranking users in their most popular location. It’s even got an index to support it:CREATE INDEX Location ON dbo.Users(Location); GO CREATE OR A …
Database Changes to Find Tagged Questions Faster: Answers and Discussion
In the last Query Exercise discussion, we hit a performance wall when we were trying to quickly find questions with a specific tag. We threw up our hands and said it’s time to make database changes, but we had a few restrictions: We have a lot of …