Viewing 15 posts - 39,421 through 39,435 (of 39,498 total)
If your WHERE clause (or other join clause) only contains the second column, then yes, you need a separate index.
I.E.
table has ColA, ColB
index is testindex( ColA, ColB)
For
select * from table...
August 8, 2001 at 11:11 am
I'd recommend DTS and use the SQL Agent to run it every xx minutes.
One thing to do when you do this is keep a table and when the job starts,...
August 8, 2001 at 11:09 am
I have seen that. I think that it was related to not having the profiles set correctly.
Log in as the SQL Server/Agent account and verify the profiles.
Steve Jones
August 8, 2001 at 10:59 am
August 7, 2001 at 7:54 am
BTW, I can't comment on the Sybex book because I co-wrote it and haven't used any other books. I did think this exam was easier than the 7.0 exam.
Steve Jones
August 6, 2001 at 12:36 pm
You need to know quite a bit of T-SQL for the exam. Not sure how much is deviant from SQL-92, but there are many questions dealing with T-SQL.
Steve Jones
August 6, 2001 at 12:34 pm
BTW, I can't comment on the Sybex book because I co-wrote it and haven't used any other books. I did think this exam was easier than the 7.0 exam.
Steve Jones
August 6, 2001 at 12:34 pm
Just tried it and I get a 1 also as the result code from the removal.
I suspect this is a bug, but I will have to check.
BTW, I assume you...
August 6, 2001 at 12:31 pm
August 6, 2001 at 12:26 pm
If you make the change in EM and then click the "script" button (3rd from left) you should see this. Many things you do in EM are only possible...
August 6, 2001 at 12:24 pm
August 6, 2001 at 12:02 pm
Be sure your transaction loading is not a single transaction. the log will not truncate open transactions.
Steve Jones
August 1, 2001 at 11:27 am
Joe,
not sure what to tell you. I agree that the product should install or you should get support.
Is this a W2K box? If so, I'd be willing to setup...
July 30, 2001 at 3:48 pm
Joe,
I haven't seen this at all with SQL. It is either a bug or something obscure that you are doing. Are you accepting the default file locations? Are you...
July 30, 2001 at 12:43 pm
Viewing 15 posts - 39,421 through 39,435 (of 39,498 total)