SQLServerCentral.com launched it April contest on April 1st sponosored by Lockwood Tech and SQL Server Magazine. Win LockWood Tech's Proc-Blaster Enterprise Edition, SQL Server Magazine, or Admin911 all for helping to build the SQL Server community.
2002-04-01
16 reads
AdminLog, by Lockwood Tech, has been added to the SQLServerCentral.com freeware library. AdminLog is a utility for managing projects, tracking bugs/tasks/assignments, etc.
2002-03-29
19 reads
Learn how to make the most out of ADO.NET and SQL Server. Find out how the new .NET Data Provider can boost SQL Server performance.
2002-03-29
1,053 reads
Last year Andy wrote about turning off the log reader as a way to reduce the overhead on a server, primarily when you have many logreaders running. In this follow up article he talks about the downside of using this technique and how the behavior of the logreader can be "tweaked" to make using non-continuous replication a little less of a headache.
2002-03-28
5,110 reads
Object Scriptr v1.0 for SQL Server 7/2000 by Rac4sql has been released as freeware on SQLServerCentral.com. The product quickly generates creation and drop scripts and insert statements.
2002-03-28
36 reads
SQLServerCentral.com today launched its new members only product discount area. The section allows members to purchase SQL Server related products at a deep discount.
2002-03-27
16 reads
Microsoft .NET Framework Service Pack 1 provides the latest updates to the .NET Framework. Service Pack 1 is highly recommended for all users of the .NET Framework, including customers of Visual Studio .NET.
2002-03-27
3,235 reads
This article written by Don Church discusses how to optimize your cubes schema, its worth a read.
2002-03-26
9,199 reads
Find out how SQL Server 2000 surpassed its previous number one result for the SAP Sales and Distribution benchmark.
2002-03-22
3,242 reads
As I work with a particular topic or problem, I often research on the Internet different opinions, white papers, etc. Here is a list of resources that deal with the licensing aspects of using SQL Server.
2002-03-21
5,058 reads
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Hello everyone, I hope you can help me. I have a table with measurement...
You can't handle the truth!! (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
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 = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers