Technical Article

Upcoming SQL Server 2000 64-bit Beta Program

Liberty Beta 2 will incorporate all the updates of SQL Server’s Service Pack 3. Furthermore, Liberty Beta 2 will be optimized for the newest addition to Intel’s Itanium® Processor Family, the Itanium® 2 processor. This beta is scheduled to start in late September.

Note: Liberty requires 64-bit hardware with an Intel’s Itanium® or Itanium® 2 processor and will not run on standard 32-bit machines.

Technical Article

SQL-UP! version 1.3 now available

Incepto Ltd. announced the availability of SQL-UP! version 1.3, distributed SQL Server Cluster. SQL-UP! clusters SQL Server databases over LAN or WAN, with no shared storage device.

The software provides business continuity and complete disaster protection for business-critical databases. The new version adds support for online database schema changes, inter-domain clusters and high transaction load.

Blogs

2024 PASS Data Community Summit Prep

By

Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...

A New Word: Bye-over

By

bye-over – n.  the sheepish casual vibe between two people who’ve shred an emotional...

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

By

I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...

Read the latest Blogs

Forums

Temporary Table Problem

By fk.da

Hello everyone, I hope you can help me. I have a table with measurement...

A Few Good DBAs

By Rod Weir

You can't handle the truth!!  (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...

Python with SQL 2022 Enterprise doesn’t work

By VK_Carry

I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...

Visit the forum

Question of the Day

Incremental Statistics

I have run this on SQL Server 2022 for the Sales database:

ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)
I then run this in the Sales database:
USE Sales
GO
CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFF
The dbo.Customer table is partitioned. How are statistics created?

See possible answers