g.britton (6/1/2015)

---

pietlinden (6/1/2015)

---

Not a very helpful article. A really helpful article would have gone something like...

Here are some places where you might consider a cursor...

Here are places where...

Just wondering where are the OS and SQL Server installed?

Cursors are a tool, if used properly they can be very effective but like most tools if use improperly they can be very terrible.

That could be interesting, try inserting into a temp table, verify the row count, then try inserting from the temp...

Just out of cursiousity have you looked at some of the rows that aren't being inserted that you feel should be to some of the rows that are and compared...

DB mail has limited formatting options, if you want a pretty report you would be better off using something else.

You should be able to do it with dbmail, it has options to include the results of a query in either the body or as an attachment. Just set...

Don't feel stupid for not knowing bit wise operators, they're an elegant weapon from a more civilized age.

Actually they're mostly just an archaic tool from when programmers were fighting over...

Ask him why he's ever want to try to parse a 200+ column X however many rows array to get the data he wants instead of just parsing a 5...

Just out of curiousity but if you're out of back up space isn't that problem a little bit more important to resolve quickly than worrying about whether checkdb or index...

I suppose this would depend on the nature of the SP's you need to run on the 2000 server, are these once a day batch jobs that are run, are...

Those are good starting points, but if you're willing to work saturdays can you get someone to call you when an application is actually experiencing a problem?

Heh, I'd be willing to bet C# becomes obsolete long before relational databases 🙂

Well based on your criteria that you never want your queries going to disk you would need enough memory to hold your entire DB....

A good starting point might...

xddevv (5/1/2015)

---

hey guys so I think I figured it out.

My last question, when I ask for permissions to the specific folder, do persmissions also have to apply to the...