Viewing 15 posts - 37,546 through 37,560 (of 39,456 total)
April 22, 2002 at 12:23 pm
I'm not sold on log shipping, mainly because I've seen too many errors with MS tools like this. I prefer to do it myself.
Total DB size (3 dbs) was about...
April 22, 2002 at 10:23 am
I'm not sure who is running instances, but this is an interesting idea.
Couple things. By default the services share resources. So if a query in one instance runs amok, it...
April 22, 2002 at 10:20 am
Since SQL Server doesn't track physical order, you need someway to order the rows. As Ansy said, you can use a cursor, but you still need ordering.
Steve Jones
April 21, 2002 at 4:16 pm
select b.firstname, b.lastname, b.middlename, a.dob, count(*)
from emp a
inner join emp b
on a.emp_id = b.emp_id
group by b.firstname, b.lastname, b.middlename,...
April 21, 2002 at 4:10 pm
April 19, 2002 at 1:36 pm
Since you are case insensitive, the check is correct. 'abc' = 'ABC' in this case.
I've run into this and started working on a char by char check that compares the...
April 19, 2002 at 1:33 pm
I agree with Antares. A packet sniffer will help. You could also open a QA or ISQL session from the server and see if it stays open for an hour,...
April 19, 2002 at 1:20 pm
is the value being changed? I wouldn't be surprised if v6.5 didn't flag update() with no actual data changes.
Steve Jones
April 19, 2002 at 1:16 pm
I have connections that run from my machine sometimes overnight and they do not break. I suspect you have some network issue here.
The short answer is the DBA sets...
April 19, 2002 at 10:52 am
If you have a multi CPU box, then the server will "parallelize" the queries, which will run multiple threads or fibers (not the same). On a single proc box, there...
April 19, 2002 at 10:50 am
A few thoughts.
1. Upgrade to SQL 2000 and W2K. I know it costs money, but it also will give nice performance improvements in how the server runs. You can run...
April 19, 2002 at 10:39 am
It was intended to allow multiple applicaitons to setup their own SQL Server without worrying about issues with a database inside a server, etc. Like Access, multiple .mdb files can...
April 19, 2002 at 10:32 am
You will have to use an ActiveX task to do this. Basically you will have to set a variable reference to the package, then get the table name you need...
April 19, 2002 at 10:28 am
select top 1
from ( select top 6
salary
from salarytable
...
April 19, 2002 at 10:20 am
Viewing 15 posts - 37,546 through 37,560 (of 39,456 total)