Creating SQL Objects on the fly with VB and XML
A method for creating databases and other objects on the fly and distribute these objects to multiple servers.
2001-06-08
1,944 reads
A method for creating databases and other objects on the fly and distribute these objects to multiple servers.
2001-06-08
1,944 reads
This article discusses queries that involve more than one database server. For example, you can run a query that returns a joined recordset where some records come from a SQL Server™ database and others come from an AS/400 machine.
2001-06-06
1,416 reads
Lots of people are designing and building Microsoft Windows-based apps with previously unimagined reliability. Starbucks, GMAC, and FreeMarkets.com all have case studies demonstrating five nines. So, how are these companies able to achieve these levels of reliability?This month I am going to show you how to use standard Microsoft Windows technologies to make your Microsoft SQL Server™ app just like Denny's—“always open” and ready for business.
2001-06-05
1,660 reads
SQL is the lingua franca of server-side Web data apps. Some of the advanced features of SQL joins, views, rankings, and computed columns can drastically simplify your code.
2001-06-04
1,107 reads
Getting ready to install Windows 2000 SP2? Read this article first. It provides links to resources as well as potential problems.
2001-06-01
1,069 reads
An introductory article from Microsoft on the newest version of SQL Server: SQL Server CE designed for Windows CE devices. Includes some ideas for where this version fits in your architecture.
2001-05-30
1,721 reads
A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.
2001-05-29
1,816 reads
Provides audience with information on cluster analysis algorithm.
2001-05-07
1,594 reads
In this product review by Brad McGehee, he shows you how Coefficient helps you performance tune your database.
2001-05-02
1,543 reads
This article describes how to create a Visual Basic application for merge replication that will handle both conflict and non-conflict changes between the affected tables.
2001-05-01
2,075 reads
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
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...
Comments posted to this topic are about the item PASS Summit Time
I have a backup of full, differential and transaction log setup for our database....
Hello everyone, I hope you can help me. I have a table with measurement...
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