Configuring the Maximum Degree of Parallelism
How to configure settings to limit the number of processors used in parallel query execution
Do SQL Server User Defined Datatypes (UDT) affect performance?
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.
Don’t Make Dumb Mistakes by Duplicating Indexes
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...
PASS Update #9
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...
Take Advantage of Hard Times
With the economy in a downturn, Steve Jones talks about what you might want to do to be pro-active with your projects.
Take Advantage of Hard Times
With the economy in a downturn, Steve Jones talks about what you might want to do to be pro-active with your projects.
Take Advantage of Hard Times
With the economy in a downturn, Steve Jones talks about what you might want to do to be pro-active with your projects.
Giving Back
Steve Jones takes a minute today to congratulate Brian Knight and the Pragmatic Works Foundation for their efforts in giving back to the community.
Giving Back
Steve Jones takes a minute today to congratulate Brian Knight and the Pragmatic Works Foundation for their efforts in giving back to the community.
Giving Back
Steve Jones takes a minute today to congratulate Brian Knight and the Pragmatic Works Foundation for their efforts in giving back to the community.
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers