2013-02-28 (first published: 2013-02-12)
1,166 reads
Scripts
ERRORFILE and MAXERRORS option with BULK INSERT
ERRORFILE and MAXERRORS option are rarely used important arguments in BULK INSERT so, I will try to highlight the use of these arguments in this script.
2013-02-27 (first published: 2013-02-14)
6,147 reads
Powershell - Query SQL Servers Operating system details
The script works through the CMS you have set up to manage your environment and gathers various server information.
2013-02-26 (first published: 2013-02-05)
1,682 reads
List Jobs and their respective programming.
List all active Jobs in SQL Server with the details of the schedule.
2013-02-25 (first published: 2013-02-07)
1,315 reads
2013-02-22 (first published: 2013-02-05)
1,810 reads
Script to Rebuild/Reorganise Indexes
A script to get the fragmentation of indexes in a database and then rebuild or reorganise accordingly
2013-02-19 (first published: 2013-01-29)
2,137 reads
2013-02-18 (first published: 2013-01-25)
2,788 reads
Get Detach or Attach all user databases script
Script to generate script to detach or attach user databases
2013-02-15 (first published: 2013-01-29)
6,080 reads
Reorganize indexes for all tables in all user databases
Script to reorganize all indexes on all tables in user databases
2013-02-14 (first published: 2013-01-31)
3,275 reads
2013-02-13 (first published: 2013-01-25)
2,012 reads
Blogs
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...
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...
Forums
Nomor Resmi Akun WhatsApp Bank BCA (0818751777)
WhatsApp resmi Halo BCA tersedia di nomor 0818751777. Layanan ini dapat digunakan untuk mendapatkan...
Layanan Halo BCA 24 Jam - Nomor Resmi 0818751777
Layanan Halo BCA dapat dihubungi melalui nomor resmi 0818751777. Layanan ini mencakup bantuan terkait...
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
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