Viewing 15 posts - 316 through 330 (of 489 total)
Thanks Antares! I finally went and read the MS article you first recommended. I didn't read it at first because I thought it would be something similar to...
May 17, 2002 at 7:30 am
I have tested the technique described in example 1 of my article on a table that has 1.8 million rows.
When getting half to all of the rows I...
May 14, 2002 at 8:40 am
The first example has been tested on larger searches, up to about 5500 rows and does well. The execution plan for that stored procedure shows a clustered index seek...
May 13, 2002 at 11:52 am
Thanks for the suggestions. Let me explain a bit further. The SQL Server 7.0 that we want to put the EM from SQL Server 2000 on is dedicated...
May 11, 2002 at 1:37 pm
Yes your comments help. Thanks!
I have a few more questions. What kind of profiler problems did you, cjlane, encounter? We don't use it a lot, but on...
May 10, 2002 at 7:30 pm
Also, does anyone know can we install the EM for SQL Server 2000 on a SQL Server 7 without upgrading the server to 2000 and without installing an instance of...
May 10, 2002 at 2:49 pm
You would have to work on site.
Robert Marda
May 9, 2002 at 4:07 pm
You'll forgive me for answering my own question, but I just found out how to fix this problem.
Enties in sysdbmaintplan_databases and sysdbmaintplans were missing. So I inserted one row...
May 7, 2002 at 5:00 am
My official title is SQL Programmer. However, from what I read here it sounds like I am doing many DBA tasks.
I develop stored procedures for new features as well...
May 7, 2002 at 2:13 am
It never occured to me to test for Windows only authentication. I've always used mixed authentication mode with the SQL Servers I've managed. I'll have to look into...
May 6, 2002 at 5:50 am
One way to modify solution 2 to work with the mentioned operators (=, <>, > , <, IN) is to create the WHERE clause like this:
WHERE (A.name = @Aname or...
May 2, 2002 at 1:53 am
You're welcome.
Many performance issues can be solved with indexes when you know the query is not the problem.
Robert Marda
May 1, 2002 at 1:57 pm
The first thing I would check is to see if the tables have indexes where needed. If not this could be the cause of the slowness you are seeing.
Without...
May 1, 2002 at 12:25 pm
I am a slow typist. Last I checked I typed at about 40WPM. I may be faster now since I've had more practice.
Before 1994, I hunt and pecked....
May 1, 2002 at 11:51 am
Viewing 15 posts - 316 through 330 (of 489 total)