1. I assume the stored procedure returns data from multiple tables, because if it returns data from one table there would be no speed increase.

2. You do not need a...

I agree with everything said, but Steve, you sound older than I am.  I still do my 48 hours non-stop when needed, especially at a game LAN and I am...

The problem is that there is not enough time spent on testing?  TRUE!, but I believe that there is a limit to where the programmer must test.  The ONLY...

Being proud will make me stay.  Being proud of what my colleges and I has done and are doing, the working environment, the company.  To be able to take anybody...

OK, lets be more specific.  Maybe I will get a better understanding which direction to go.  I work in South Africa and because of the brain drain; we have...

You could consider using “scalectric” engines to do it yourself.  The engines you find in radio controlled cars and airplanes.  Many people think that a small engine like that...

If you give a group access to a database, what prevents an AD Administrator from adding himself to the group, look up what he/she wants to see, and removing himself...

I believe the best way to get data into sql is to import it first into a temp table with no key and all the columns allowing nulls.

Now use a...

I work for a Mining company in South Africa and we are expected to go on 1 to 2 training courses per year, fully paid by the company, with no strings...

I have used this method for years (because I hate cursors), but does it slightly different. I use a #Temp table and then select the TOP 1 at the beginning...

In the DTS package you must add a connection to the database. Then add a "Execute SQL task".  In this task you can enter your Sql code to execute a...

I am responding because I would also like to hear an answer (if any) on this one.  I do log backups every hour to keep them small.

Assuming it is not a live table and you know what and why you want to do this, you can remove the identity from the column, update the column and...

English is not my first language, so maybe I am not phrasing myself correctly, but it is not about being offensive.  Asking questions about certain topics is being seen...

I do not know about other countries, but in SA it is forbidden to ask certain questions in an interview.  Like are you gay?

So a lot of interviewers are using...