I’ve often described SQL Server to people new to databases as a data pump. Just like a water pump, you have limited capacity to move water in or out of a system usually measured in gallons per hour. If you want to upgrade your pumping systems it can be...
2009-04-21
6,824 reads
New author Drew Salem brings us a series on how to centrally monitor your SQL Servers. He includes ASP.NET code and a framework that will check your servers and display a report for you. This article presents an overview of the dealing with the SCOME issue.
2009-04-20
10,118 reads
How to configure settings to limit the number of processors used in parallel query execution
2009-04-20
3,121 reads
There is a legend among SQL Server developers and DBAs saying that UDTs may degrade performance. In this article I prove whether this believe is right or wrong.
2009-04-20
3,361 reads
Just today, I was reviewing the indexing of a database used by a third-party application. As part of my review, I ran a script against it that is used to identify duplicate indexes. The script I used was written Paul Nielsen, the author of the SQL Server...
2009-04-20
3,400 reads
Time has flown by since my last update, busy time at work and struggling to get that done and find a few hours for PASS too. Here's a short version of what I've been working on lately: Added the Top 10 List page and have some starter lists from...
2009-04-20
1,208 reads
With the economy in a downturn, Steve Jones talks about what you might want to do to be pro-active with your projects.
2009-04-20
75 reads
With the economy in a downturn, Steve Jones talks about what you might want to do to be pro-active with your projects.
2009-04-20
66 reads
With the economy in a downturn, Steve Jones talks about what you might want to do to be pro-active with your projects.
2009-04-20
66 reads
Steve Jones takes a minute today to congratulate Brian Knight and the Pragmatic Works Foundation for their efforts in giving back to the community.
2009-04-19
751 reads
I’ve been doing storage load tests for SQL Server for a long time, both...
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
I have an app that has an address field on the customer and the...
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
How do I easily get the next 12 sequence values from a sequence object?
See possible answers