January 8, 2002 at 3:39 pm
Correct, in my first job as a DBA we only had on SQL Server 7.0 and none of us had experience with it since I moved all our data from MS Access to SQL Server in the first month in my DBA position.
When I first started in my current position we only had a development and production environment. Our testing environment was set up a few weeks later. As I look back now I don't see how we got by with just one database server.
Robert Marda
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
January 8, 2002 at 4:01 pm
Actually I use the filesystem object to create a handle to a text file if I have a debug flag set. I store the debug flag, the filename and path in global varaibles. If the flag is set, then I create (and close ) the file. In many places i have a "if debugflag = 1 then write a line in the file".
Steve Jones
January 22, 2002 at 9:31 am
Steve,
Does the ctrl-shift-C work with 7.0 QA? I tried it but it did not comment the text. -JG
-JG
January 22, 2002 at 10:43 am
Not sure. I'll get up from my desk and go check. Are you highlighting lines and then doing it?
Steve Jones
January 22, 2002 at 12:02 pm
Yes I hightlight the line then perform the shortcut.
-JG
January 22, 2002 at 1:22 pm
January 23, 2002 at 9:15 am
I agree on the upgrade the client tools. What are some of the impacts of using SQL200 client utilities to adminster SQL 7 servers. Especially in the DTS realm?? -JG
-JG
February 4, 2002 at 10:46 pm
It has always bugged me that the pop up menu on Enterprise Manager for the registered instance has the disconnect item next to the stop (stop MSSQLServer service) item.
I am very careful, I tend to use the letter 'c' (underlined in disconnect) to complete the command.
Some of our developers complain to me regularly about how SQL seems to stop spontaneously on their laptops. (Their local copy not the production server).
February 5, 2002 at 2:59 pm
Keep in mind, never assume your first query for anything is optimal, and learn to understand the execution plan.
Biggest OPPS, renamed a table on a major production site and forgot to update all procs, views and asp pages to match. Then left for vacation.
February 5, 2002 at 3:36 pm
February 5, 2002 at 6:14 pm
Fortunately for me it was at Christmas and not too many people needed it. After a few days another programmer who read thru my comments and code and found my mistake, of course they did not let me forget for the longest.
Viewing 11 posts - 16 through 25 (of 25 total)
You must be logged in to reply to this topic. Login to reply