I am working with a SQL 2000 database from a piece of legacy software and I'm finding that table structures have changed and the views haven't been...
I have a new SQL 2000 Server I'm about to roll into production. My IIS web server (ASP.NET Application) will be communicating with the SQL server....
I am setting up a new server with SQL 2000 and Windows Server 2003 R2. It is an Intel dual quad-core processor system with 8 gig of RAM. Should I...
I have heard that if I put 64 bit Windows Server 2003 on my SQL server, I will have to also upgrade my web server (that reads data from the SQL...
In the next 10 days my new sql server should arrive. It will be running Windows Server 2003 and SQL 2000. The server has 8 Gig of RAM and I would...
We have an application that performs nightly calculations on our data, and then stores the results in a set of tables in the database. The overhead...
I don't remember having this problem in the past, but recently our production server takes a long time to compile stored procedures. FYI, the server...
My server is offsite at a cybercenter and I want to monitor it with Performance Monitor from a computer here in my office. I can't get perfmon to...
I have a temp table used by a stored procedure that contains some dates and values. I have a begin date and end date for a period of time and I need...
I want to be able to limit my nightly number crunching routines to acting on only data that has changed since the previous run. In order to do this,...
We have 10 databases that get nightly calculations done on them. The routine that does it is a vb.net application that reads data from 8 large...
I recently set up a test database server to setup on a client site. It was very similar to our production server except that the processor was...
I have to ship a copy of my database to a client site for preliminary testing. The db is still in development so we don't have encryption on any of...
Please help me decide what to do about my current hardware configuration. I have an ASP.NET app that uses SQL Server for the database. Currently...
I have read that I shouldn't be using AutoShrink on my production databases. If I turn this option off, how (and how often) should I shrink the...
Separate names with a comma.
