Put Advanced SQL Server Features To Work
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
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 Rob Sewell
The partner directory connects your agency with new customers.
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
CREATE TABLE TempA ( InvoiceNo VARCHAR(50) NOT NULL, Date TIMESTAMP NULL, Type VARCHAR(50) NULL,...
could you please help, i want to update holidayAll column with same Holidaydate...
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers