Is it possible to set SQL 7 up to use an autoloader tape drive? I've managed to set up a tape device on one of our SQL installs with a single DLT drive which works fine, but I can't seem to make it talk on the server with a 7 slot autoloader DLT drive. Thanks […]
2001-08-01
4 reads
I have created a stored procedure on SQLServer 2000 which collects data from a linked Sybase server to be placed in a table on the SQLServer. Due to issues with the sybase ODBC Driver provided with Sybase, Inserting into a temp table from a Remote Procedure Call directly will not work, i.e.: INSERT INTO STAGING_TABLE […]
2001-08-01
5 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/tamethosestringspart5propercasingstrings.asp
2001-07-31
9 reads
Hi all I have two small OLTP databases (4 gig each)...are have around 450+ users on average throughout the day, generating around 500Mb in logs on the best of days. I am doing full backups @ 2am and log backups from 7am to 11pm - all daily. The backups are going to two RAID-1 arrays […]
2001-07-30
2 reads
This article presents the technical details of the page layout for data in SQL Server 6.5
2001-07-30
2,719 reads
I got the following questions from a reader and was hoping to get some responses from the world out there. At this moment in time, i'm pursuing a bachelors in computer science and i would like to know what's it like working as a DBA? what is the entry level at which u join a […]
2001-07-27
2 reads
Hi all Im trying to write a script that lists me: table_owner table_name column_name for those tables that use IDENTITY to seed its values. Ive been looking around syscolumns and for the life of me cant locate what I need. Any tricks to this? Cheers Chris
2001-07-25
2 reads
Sizing a database can be one of the most arduous tasks a DBA, analyst or developer must attend to. It?s time consuming and more hours go into analyzing the database than actually sizing it. This article focuses on how to monitor the database?s growth after its deployed and contains some tips on how to size it before deployment. We will also dive a little into how to benchmark your database against a robust data load.
2008-08-01 (first published: 2001-07-25)
42,766 reads
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
We have SQL Server 2000 Personal Edition installed on Windows 2000 Professional machine with 1GB RAM and 80 GB hard drive. The SQL Server stops functioning some times and sometimes it runs stuff you never asked for. SQL Server log file shows that it is starting up databases once every minute. Is this a machine […]
2001-07-19
2 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers