Forum Replies Created
Viewing 15 posts - 36,001 through 36,015 (of 39,804 total)
-
RE: Upgrading SQL7 to SQL2000
Haven't done it in awhile, but should be pretty smooth. Course I've got to do one next week, so if anything happens, post it here.
Steve Jones
-
RE: Never mind...
-
RE: SQL Server and other applications
It happens, I know it's happened to me. All you can do is document and voice your concerns as a CYA and deal with it the best you can.
Let us...
-
RE: Max Memory recommendation?
SQL will leave memory for the OS, but the deallocation and reallocation can be (relatively) slow sometimes. If you have concerns or issues, you should set it.
Hard to determine exactly...
-
RE: 4 Excel Columns into one
I think that you want to setup the transform as anm ActiveX task and then use the CHR() function in the VB Script.
Steve Jones
-
RE: Connecting to dBs with different userid and pwd
I'd use roles, transfer the permission to the role and grant to both users.
Steve Jones
-
RE: Data dictionary
This is always a little kludge and I haven't seen any great ways to do it. Embarkadero's ER/Studio would do some as would one of FMS Software's products. Not sure...
-
RE: Given a date Find the Stored Procedures Updated
The alter statement will not update a date, but it will update the base_schema_ver. You'd have to know the previous versions, but this goes up by 16 with each ALTER.
Steve...
-
RE: Table Order!
Frank is correct. There is no benefit to the order of the tables in the statement. This is different from Oracle I believe.
The optimizer considers the request and may reorder...
-
RE: Number of times a Word appears in a string...
Nice. You might want to add this to the scripts section.
Steve Jones
-
RE: SQL Server and other applications
It's a bad idea in general because SQL is competing with other applications for resources. You tend to separate your database from the applications.
That being said, it's not horrible in...
-
RE: Advertising Problem
It seems to flake sometimes, but not consistently. Is this a consistent or intermittent problem? Is it on all pages?
Steve Jones
-
RE: What did you do before SQL?
Never been a farmer, suburban boy, but now live on 2 1/2 acres and my wife wants a horse, so I guess I'm about to learn a few things.
Steve Jones
-
RE: Dubious DBA Statement
I guess it depends on the setup of their server, but it's possible this might cause them issues.
However, I'd dispute this and then ask that they upgrade their server...
-
RE: "How old are you?" oddity
Have you scrolled down and to the side? These forums sometimes flip out.
Steve Jones
Viewing 15 posts - 36,001 through 36,015 (of 39,804 total)