Can you shrink your SQL Server database to death?
To increase SQL Server disk space, 'shrink the database' task is used. But the tests in this tip using autogrowth prove that 'shrink database' poorly impacts SQL performance.
Climb Another Mountain - Database Weekly (Oct 13, 2008)
The next version of SQL Server has a codename. Or does it? Steve Jones talks about some announcements in the SQL Server world this past week.
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
A methodology is described to bring out the best in database monitoring through System Center Operations Manager 2007 customization.
Granting View Definition Permission to a User or Role
Instead of granting higher level permissions, is there a way to allow users that only have public access the ability to see object definitions?
Too Good at Data Analysis
Can you be too good at analyzing data? An interesting story from the financial markets.
Too Good at Data Analysis
Can you be too good at analyzing data? An interesting story from the financial markets.
Too Good at Data Analysis
Can you be too good at analyzing data? An interesting story from the financial markets.
Climb Another Mountain - Database Weekly (Oct 13, 2008)
The next version of SQL Server has a codename. Or does it? Steve Jones talks about some announcements in the SQL Server world this past week.
Climb Another Mountain - Database Weekly (Oct 13, 2008)
The next version of SQL Server has a codename. Or does it? Steve Jones talks about some announcements in the SQL Server world this past week.
Climb Another Mountain - Database Weekly (Oct 13, 2008)
The next version of SQL Server has a codename. Or does it? Steve Jones talks about some announcements in the SQL Server world this past week.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Pejagalan No. Telp:083831617937
Whatsapp.083831617937 Jl. Pejagalan I No. 3E Jakarta Utara, DKI Jakarta, Indonesia 11240
BCA KCP Permata Kota No. Telp:083831617937
Whatsapp.083831617937 Ruko Permata Kota Blok A No. 10 Jl. Pangeran Tubagus Angke No. 170...
BCA KCP Pluit Kencana No. Telp:083831617937
Whatsapp. 083831617937 Jl. Taman Pluit Kencana Selatan No. 1-3 Jakarta Utara, DKI Jakarta, Indonesia...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers