SQL Server – Get SQL Server Service Account using T-SQL
SQL Server service account information is stored in Windows Registry database. You can get this information from Services Console or...
2013-08-20
2,506 reads
SQL and Me
SQL Server – Import text file using xp_cmdshell
There are several options available to import data from external sources to SQL Server. Such as Import & Export Wizard, BULK...
2013-07-29
1,062 reads
SQL Server – Get values as DATETIME from sysjobhistory
This is a follow-up post on SQL Server – Check SQL Agent Job History using T-SQL.
SQL Server Agent stores SQL jobs...
2013-07-22
738 reads
SQL Server – SELECTing/Displaying Top N rows from a table
To SELECT only top N rows from a table we can use TOP clause in SELECT statement. Using TOP clause...
2013-07-15
867 reads
SQL Server – How to change SQL Server ERRORLOG location
By default SQL Server ERRORLOG is stored in "C:\Program Files\Microsoft SQL Server\InstanceFolder\MSSQL\Log" folder. The ERRORLOG location is configured as a...
2013-07-12 (first published: 2013-07-08)
5,734 reads
SQL Server – How to connect to SQL Server when ‘sa’ account is disabled
If you have lost the password for sa account or does not have any administrative account and you are locked...
2013-07-03 (first published: 2013-07-01)
4,180 reads
SQL Server – How to Enable a Disabled SQL Server Login
When an account is disable it cannot be used to login to SQL Server. You will receive below error when...
2013-06-24
982 reads
SQL Server – Update Table with INNER JOIN
Often we may need to update a column in a table based of another column in another table.
In SQL Server...
2013-06-18
1,161 reads
SQL Server – How to get sizes of all databases on a server
To get database size information we can use sys.master_files catalog view. This view contains a row per file of a...
2013-06-10
1,284 reads
SQL Server – How to Detach a Database
To move a database from one location to other you fist need to detach the database from server. In this...
2013-06-03
1,153 reads
Blogs
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...
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
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