Viewing 15 posts - 466 through 480 (of 518 total)
I agree with Simonsabin. When you consider the scalability in Sql Server, comparing scalability in IIS, ANYTHING I can move off my Sql Servers is preferable if in fact there...
October 21, 2002 at 4:21 pm
you are right Simon, and I only thought about it in the concatenation, not in the join.....good catch...
If your not gonna help, Please move to the side, because if your...
October 21, 2002 at 4:09 pm
His will work as well, its just done with a subquery rather than a join....I didn't see it until I posted mine.
Actually, after looking at it closer, I notice he's...
October 21, 2002 at 3:30 pm
I was bored so I wrote it for you....
INSERT INTO Teacher_Data_MainTEMP
...
October 21, 2002 at 3:27 pm
The code should be rewritten to left outer join the tables on the fields TMP.Schoolnum, TMP.Tchnum, TMP.Lastname, and TMP.Firstname
and check for it not being there by using a where clause...
October 21, 2002 at 3:14 pm
I thought so.....
If your not gonna help, Please move to the side, because if your not helping the situation, your hurting it....
October 21, 2002 at 3:07 pm
I have a generic log table I created to write things like that to from within my procs. I go back after I finished working with it and remove the...
October 21, 2002 at 1:58 pm
In all the jobs I've worked, the programmers work with a development enviroment, and have NO rights anywhere else or possibly read rights to stage or test enviroments, but NEVER...
October 21, 2002 at 1:39 pm
If it is possible, wouldn't it violate the license agreement?
If your not gonna help, Please move to the side, because if your not helping the situation, your hurting it....
October 21, 2002 at 12:14 pm
I think what Simon is suggesting is to create the indexed view without the date criteria, and then use the date criteria when calling the view, which would work, as...
October 21, 2002 at 12:07 pm
A simple way is to set your enterprise manager to task pad view, and check the size of the file before and afterwards.
A more exact method would be to check...
October 18, 2002 at 12:33 pm
Is there a particular reason for shrinking the file afterwards......when it grows again, you'll take a performance hit.....
If your not gonna help, Please move to the side, because if your...
October 18, 2002 at 11:40 am
Keep in mind that Winzip is limited to 2GB files. Rar on the other hand, is not limited in this way. Just a FYI....
We dump our backups to a network...
October 18, 2002 at 11:32 am
I notice table scans and bookmarked lookups in your execution plan. Try to take care of these, and you'll definately see improvement. Table scans are obvious, and you can eliminate...
October 18, 2002 at 7:14 am
It seems to me that is the system tables were restored from server A, then in the master database, in the sysservers table, row 0 would show server a's name...
October 18, 2002 at 6:52 am
Viewing 15 posts - 466 through 480 (of 518 total)