Thre's other insurance. Workman's comp, payment if you get injured on the job, isn't provided. Possibly you could sue the company, but this is basic insurance that every business with...

TOAD has been a load on workstations before for me, but it's a good tool. I have lots of Oracle/DB2 friends that love it.

Embarkadero has ER/Studio that's a good reverse...

Bob, that's an interesting solution, but it has the problem of you constantly having to read and store back more information on a regular basis. That could end up being...

Sorry, Gail. Appears that eWeek messed it up as even Google shows that link.

The story is also here: http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9056778

I think you mean "no one is disrespecting"

That's a good example of where mis-communications occur. It is important to try and learn from your mistakes when you're working in another...

Tony,

thanks and glad you like them. I'll try to keep them coming and hopefully pick interesting topics.

You could script out the indexes, save this. Then do a search and replace for the indexes, choosing the new filegroup as the new location.

Mixed mode means you can use either SQL or Windows authentication. It doesn't mean you are using one or the other.

If you are using SQL authentication, you can only base...

Very nice 🙂

:), actually I should see who 666 was!

Anytime. I am usually busy, so I don't worry about the stuff that isn't being queried. Who knows how many tables are old, never deleted, out of date, etc. Same...

I'm with Jeremy. I'm sure there's a good set based way to do this, but to just get it done, I'd rip through the table based on time and process...

It's not completely clear what results you are looking for and what the data means from your explanation. Please clarify with a simpler example using the fields you need and...

You can use Local System, but if you do need to access, the network, don't put the service account into the admin group. Instead create a regular user account, no...

Is there anything ever written to the SQL Server error log or the Windows Event Log?

It's strange to see this type of error. I have no idea why you'd be...