SQL Server 6.5 Data Page Structure
This article presents the technical details of the page layout for data in SQL Server 6.5
2001-07-30
2,723 reads
Articles
Using Cursor Metadata to Dynamically Generate HTML Tables
The following stored procedure will demonstrate the use of cursor metadata. Using cursor metadata we can get information about an SQL statement and use that information to dynamically generate other code such as HTML or other stored procedures.
2001-07-27
5,146 reads
SQL Server 2000: .NET and the Death and Re-Birth o
In this month's article I will cover an aspect of SQL Server that always generates a great deal of, well, shall we say "discussion"—triggers. Love them or hate them, SQL Server 2000 will change they way you think about triggers and will probably alter the way you design your applications. Specifically, this month I will dive into cascading referential integrity (RI) and the new INSTEAD OF and AFTER trigger concepts in SQL Server 2000.
2001-07-27
1,538 reads
The DBA Dot Com Bust
The downturn in the economy has left quite a few technical people out of work. This ongoing article describes the experiences over the past two years of Steve Jones. Reader experiences are requested and the article will be updated weekly.
2001-07-26
6,878 reads
2001-07-24
7,657 reads
SQL Server 2000 Operations Guide
Are you responsible for keeping your organization's database systems up and running? Are you the one they call in the middle of the night if the database server is down? If so, the SQL Server 2000 Operations Guide is for you.
2001-07-24
933 reads
Review: SQL Server 2000 Database Design
Is this a book you should read? Spend a few minutes reading the review to find out!
2001-07-23
4,548 reads
SQLServerCentral.com Wrox Book Giveaway
Our first contest will begin July 23rd! We’ll be giving away a free Wrox book titled: SQL Server 2000 Database Design
to the individual who refers the most users to SQLServerCentral.com throughout the duration of the contest. The contest will last from July 23rd until July 29th.
To insure that each referral counts, make sure that each person you refer has your SQLServerCentral.com registered email address. Good luck!
2001-07-23
45 reads
2001-07-23
3,187 reads
Using COM to Output Queries to a Text File
This article presents a method of outputting the results of a query as a tab delimited text file using COM.
2001-07-20
6,571 reads
Blogs
Creating an Empty Repo in GitHub–#SQLNewBlogger
By Steve Jones
I saw someone struggling with getting started with a Visual Studio project and Azure...
Product Review: DataVeil
By Brian Kelley
If you’re looking at data masking tools, I recently was able to review the...
The Last Price Bump for the Data Community Summit
By Steve Jones
This week the cost of the PASS Data Community Summit jumps up to full...
Forums
Error in SQL Server Management Studio launcher
Guys, good night! I have a situation in my SQL Server Management Studio where...
Just upgraded SSRS from 2016 to 2022
I just upgraded SSRS from 2016 to 2022. This is my first time doing...
Weekly sales report
I have two tables InvHeader and InvDetail InvHeader table has the columns: InvNo, InvDate...
Ask SSC