2001-07-24
7,810 reads
Articles
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,562 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
57 reads
2001-07-23
3,190 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,576 reads
Troubleshooting ASP and ADO Errors
My ASP file doesn’t access my database." "I can’t connect to my database from my code." "I’m having problems calling and debugging stored procedures." These are some of the problems I hear every day as a Microsoft® developer support engineer.
2001-07-20
2,008 reads
2001-07-19
2,591 reads
Using Java to Encrypt Passwords
Lots of applications store user names and passwords in the database. This article presents a method for encypting this information using Java.
2001-07-19
14,927 reads
How Many Business Days Are There?
Ever had to calculate the number of business days between two dates? This article presents a way to solve this problem in T-SQL.
2001-07-18
13,002 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
SQL Server Auditing: Track Changes by Specific Users on Specific Database Tables
Hello Everyone! My organization is looking to implement a solution in SQL Server (2019...
Experimental Verification of the NKTg Law on 8 Planets (NASA 2024 Data, SQL)
Nguyen Khanh Tung Email: traiphieu.com@gmail.com ORCID: 0009-0002-9877-4137 -------------------------------------------------------------------------------- Abstract This article presents a numerical...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers