2018-02-19 (first published: 2018-02-07)
1,030 reads
Scripts
Compression estimates
The script estimate compression benefits per each object in the database for which the page compression has not been implemented.
2018-02-15 (first published: 2018-01-15)
2,075 reads
2018-02-12 (first published: 2018-01-24)
339 reads
Run SQL/T-SQL scripts on folder
What to do when you have several sql scripts to run in your DB? Put all in a folder and use this...
2018-02-09 (first published: 2018-01-24)
2,236 reads
Remove Database Encryption Key on all user databases
Below script will remove database encryption key, database certificate and master key on all the user databases.
For tempdb database, you need to restart the SQL Server Instance to complete the process.
Note: It is advisable to take transaction log backup before this activity is performed.
2018-02-08 (first published: 2018-01-29)
2,224 reads
All Link servers working status check and failure alert over E-mail
This procedure will help you to automation of link server failure status check with help of SQL agent job scheduling. Job query :-
exec proc_check_linked_servers 'profiler name','E-mail ID'
2018-02-07 (first published: 2018-01-30)
781 reads
2018-01-26 (first published: 2018-01-18)
12,608 reads
Compare MS SQL Agent jobs on two servers
During a database migration or a side by side database upgrade project we need to migrate the MS SQL Server Agent jobs. This script compare jobs by names and shows unmatched jobs.
2018-01-25 (first published: 2018-01-20)
3,520 reads
Insert data into a SQL Server Table using Powershell using Invoke-SQLc
How to insert data into a SQL Server Table using Powershell using Invoke-SQLcmd Commandlet
2018-01-24 (first published: 2018-01-11)
31,318 reads
2018-01-23 (first published: 2009-10-27)
15,629 reads
Blogs
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
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...
Forums
Having some performance issues with linked server query
When I run my query from DW, which uses a linked server, it times...
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
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