There are many occasions in programs where you need to manipulate strings of characters that are delimited by a particular character, such as a comma, or a space. This function enables you to extract a substring from the string at a specified occurence of the delimter. declare @Data varchar(255) set @Data = 'A,B,C,D,E' print dbo.field(@data,',',2,2) […]
2011-11-07 (first published: 2007-08-03)
2,637 reads
Script helps to get the client and queries that generate longer waiting time.
2011-11-07 (first published: 2011-10-14)
1,542 reads
There are many ways 2 compare datasets to find differences, this is one of them.
2011-11-04 (first published: 2011-10-21)
2,328 reads
This is a script to find all constraints and check if they are enabled or disabled.
2011-11-03 (first published: 2011-10-12)
7,894 reads
2011-11-02 (first published: 2011-10-21)
1,781 reads
2011-11-01 (first published: 2011-10-18)
2,572 reads
2011-10-31 (first published: 2011-10-19)
2,281 reads
A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.
2011-10-28 (first published: 2008-05-13)
3,014 reads
Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database.
2011-10-27 (first published: 2008-02-08)
3,467 reads
Index maintenance procedure using rebuild or reorganized based on fragementation level.
2011-10-26 (first published: 2008-03-28)
3,509 reads
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
Comments posted to this topic are about the item Server-Level Table sizes
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