Searching for Strings in SQL Server Databases
Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google. Besides the obvious Full-Text search, Phil Factor describes some of the techniques for finding that pesky data that resists the normal SELECT blandishments.
SQL Saturday #292: Detroit
SQL Saturday is coming to Detroit MI on May 17, 2014. Join us for a free day of SQL Server training and networking. Register while space is available.
Stairway to SQL PowerShell Level 6: PowerShell Modules
In this level, we will walk through creating and using modules for PowerShell. Modules are simply a collection of functions that are most likely related to each other and packaged in a way that allow you to import them as a group.
Options to Move a Big SQL Server Database to a New Drive with Minimal Downtime
This article outlines the pros and cons associated with the different methods for moving SQL Server databases to new storage within a 15 minute timeframe.
Duplicate Detection and Management
Inevitably, every DBA is eventually asked to delete, merge, or otherwise report on duplicate data. There are many tools at our disposal to make this task both simple and efficient to complete. Read on for simple steps and examples to effectively deal with duplicate data.
The Subtle Push to the Cloud
There's a push to the cloud from Microsoft, and Steve Jones has a few thoughts. Have you warmed up to the cloud at all?
Moving from Practice to Production with Test-Driven Development
Test-driven development is often taught using simple examples, such as calculating the scores for a game of ten-pin bowling. Using the same practice effectively on a real code base isn’t as easy. This article covers some of the questions that arise when dealing with larger code bases and changing requirements.
Percentile calculations in DAX
It is not always easy to do what Excel does with PERCENTILE.INC. Learn what formulas to use in this article.
Blogs
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
Why sys.fn_dblog Is Undocumented And Why It's Still There
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
Forums
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
The Disabled Index
Comments posted to this topic are about the item The Disabled Index
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Question of the Day
The Disabled Index
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers