How often do you check your SQL Server tables for fragmentation? How often do you defragment them? This is one of those technologies that has been available for disks for a long time, but now is here for SQL Server. Norb Technologies is offering a discount to the SQLServerCentral.com community on this product.
2005-11-01
4,122 reads
Tried at TechEd and manned by the SQLServerCentral.com crew, this was a great idea. It's going to be at PASS and hosted by James Luetkehoelter.
2005-09-21
2,940 reads
It is just next week that the PASS 2005 Summit kicks off and we've got some information about our casino party for those attending.
2005-09-20
3,558 reads
Less than two weeks away, sessions tried and tested at the PDC, the Microsoft SQL Server development team and gambling with SQLServerCentral.com! Register today!
2005-09-15
2,951 reads
Clustering, partitioning, database snapshots, database mirroring, SQL Server SAN storage design and more are all in the September issue of the SQL Server Standard.
2005-09-12
5,093 reads
The release of SQL Server 2005 is a few months away and there are many people that are excited and looking forward to moving the new release into production. But what percentage of people are really looking to adopt the new platform soon? Edgewood Solutions has put together a survey to see. Enter and you could win a prize.
2005-08-24
4,908 reads
The amazing 4S sale! Our space constraints are your gains as we've put a bunch of books on sale. Check them out and save.
2005-08-23
4,288 reads
If you are near the Jacksonville, FL area on Saturday, August 27th, check out this code camp with our own Brian Knight. Get the chance to learn some great development from Brian and a few other experts.
2005-08-17
2,964 reads
With a month left before the 2005 PASS Summit, there is yet another great reason to attend this SQL Server conference in 2005. Read about it and be sure that you register today with our source code "SSC".
2005-08-10
2,832 reads
If you live in the US, take a few minutes for this performance survey and you could win an Amazon gift certificate.
2005-08-02
3,281 reads
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...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
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