The example/code above is code for a...

Short answer: No

Long answer: Why would you want to? If you're running an O/S other than Windows there are plenty of alternatives to SQL Server, ranging from...

Maybe it's time to evaluate the viability of switching over to integrated security?

The difference between the two is pretty straightforward:

Server side cursor - data remains on the server until requested by the client application; results are kept on the server and only...

One of the advantages of stored procedures is that they can/will use the same query plan repeatedly based on the assumption that the stored procedure will be doing pretty much...

Emmanuel -

What exactly did you do to the windows/AD account? Whether changes are replicated/carried over into SQL server, Exchange, etc. are largely a matter of what changes are made...

I'm going to go with Brian on this one - MySQL is a serious contender in the database space that will only get better with time and depending on your...

Giraffe (don't think I've ever called anyone by that name but here goes) -

One thing not addressed so far is that backup exec, etc. are often used to take daily/weekly...

Rudy -

One comment - have you looked at that I/O patterns of your existing databases? CPU/RAM are important, but unless you can load entire databases into memory high speed...

Many ETL tools (e.g. SSIS, Informatica) allow you to specify the "batch size" to be used during inserts which causes the tool to send X number of rows to the...

Bill -

You don't say whether you're on a 64 bit or 32 bit version of SQL Server... assuming you're on a 64 bit machine you may well need to install...

Any chance there is another table of the same name in your schema (e.g. username.table rather than dbo.table)?

MARS works with regular c# outside of SQL Server so I would assume that it should work inside as well... can you give us an example of your code?

I can think of several instances where versioning a database as described might be useful if done carefully. For example, if you had a series of read only databases...

Kathy -

Take a look at a server trigger... you'll probably need something much more than this but here's a real simple one, when I tested using ODBC manager on...