Hello all,

I recently worked with a company that created insurance company policy management and claims software.  Our platform was SQL Server.  It was the second generation on the product.  The...

Another possibly less conventional solution would be to see if there are just one or two WRNotes entries that cause the whole row to exceed maximum length.  If so, can...

It must be 8 characters long, include upper and lower case and at least one special character with no common words to meet the complexity requirements.

Even though there is an SA password, it is possible that either the SA password, or the domain password is too short or not complex enough.  I believe that would...

Actually, to back up the database and all its data you do not have to stop the service.   There are a couple of approaches that you can take to accomplish...

Is data being entered?  If so, what mechanism is entering the data?, Is there an application that connects that has had recent configuration changes?

I won't claim to have spent enough time on this to do it justice.  However, the use of the cursors seems like it would be an expensive process.  Ideally you...

Sorry, one other note,  in SQL 2005 you can split clustered indexes on partioned tables.  If there is a set of older data or unused data to partition to a...

A couple of thoughts.  First, you can get a performance boost by putting tables on their own disk subsystem.  The obvious move is the log file, which should still be...

In today's market it is very common for DBAs to wear two hats, an administrative hat and a programmers hat.  There are quite a few DBAs that do ETL with...

If you run sp_monitor you should get a baseline and perhaps enough information to determine it you need to go onto more specific IO stats. 

It will provide CPU%, number...

I don't know that this is what you are looking for but the following will create a database, its schema, a table and add a user such that...

I don't agree with the answer.  Yes it would work for Bob, but other members of HR that get cross-trained would have to have the same steps performed and once...

Using an identity column will work fine until you have deleted a number of rows, then the line numbers will no longer be sequential.

Keith

For those that want the hard and slow way to do this, here is a cursor that will number each row as it is produced in the result...