I work in a Fortune 10 company with an installed base of nearly 1000 SQL Servers, and DBAs all have local administrator rights.  I'm in the server support group, and...

I work in a Fortune 50 company, and the tide has definitely turned in favor of the DBA in recent years.  Most of our enterprise level applications are written by...

Any db object created by a member of the systemadministrators server role shows dbo as the owner by default.  A member of the systemadministrators server role may also change the...

I didn't realize that Manchester and Portland, OR have the same weather forecasting techniques.

First, I have never used a cursor in 13 years of SQL Server support - doesn't mean that they don't have their place, but I've never used one.  Moreover, they...

In response to your specific question, I do not know the answer but would like to know.

OTOH, you can control access to the MDF file in similar fashion to using...

We've addressed this same kind of problem in two different ways - both have been less than 100% satisfactory:

1- Best way so far is to execute Java or C# executable...

Oh, I will go much farther.  Including this article on this site is incompetent and irresponsible in the extreme.  A site is either political, or it's not.  In an intensely...

IMHO, there are serious issues for SQL Server with RAID 5.  It has the worst sequential write performance (e.g. tran logs) of any RAID configuration, and it's performance in transaction...

The question is not really clear.  If the requirement is to lock out a user account after n failed logins, SQL Server does not provide this facility.  SQL Server also...

Over the last 10 years, I've had databases marked suspect for a variety of reasons:

- Memory access violations

- Corrupt data

- Corrupt indexes

- Variety of allocation errors

- Missing files

- Others

I've never...

If I understand your question correctly (obtain 50 rows via email), have your 'partner' export the 50 rows to a comma or tab delimited text file, zip it and then...

Although I use cursors regularly when they seem to apply, the most prevalent performance issue that I get called in on for vendor applications is the use of cursors for...

One followup:  you might also create an UPDATE trigger on the Tasks table to scan the resolution status of all taks associated with a TT ID and, when all are...

You could also use a 'Tasks' table creating a one to many relationship between the TT and the sub tasks.  Each row in the Tasks table could contain whatever information...