Your SQLIO test file size is far too small to be a valid test. I prefer to make it something close to the size of the database or at...

Problem solving questions are good, but sometimes a couple of simple technical questions are enough to weed people out.

I asked a candidate what versions of SQL Server they had worked...

Lynn Pettis (4/15/2013)

---

Robert-378556 (4/15/2013)

---

First choice with such questions is in most cases google, then wiki, then forums, just because you have a high probability to get an accurate answer immediately.

OLTP...

The problem of “cooking” the data is hardly confined to healthcare.

Any time you are evaluating the performance of an organization with specific metrics you are giving people an incentive to...

You can use this script to fix this problem.

Change Maintenance Plan Owner

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=164441

Are you sure this is not a problem with your rebuild script or stored procedure?

What happens if you just run an index rebuild from a query window like this?

ALTER INDEX...

Images can vary greatly is size, so it depends on the type of images you are storing.

If you don't know the image sizes, then any estimate is just a wild...

UncleBoris (4/2/2013)

---

That is correct. We have one service account for each service type (SSIS, SQL etc) but the same account is used for multiple production servers.

No excuse but legacy and...

I recommend creating the clustered index before the load, and create the non-clustered indexes after the load. This saves the step of building the clustered index, which actually amounts...

The script on the link below can be used to determine the reference levels of all tables in a database in order to be able to create a script to...

Why would the service account get locked out? Are you using the same service account on more than one server?

To answer your question, we setup new service accounts for...

1. Shrink the database.

2. Reorganize (defragment) all tables.

3. Repeat 1 and 2 until there is no more progress.

Do not use rebuild (re-index), since that may cause the data file to...

GnuPG is a command line tool. It's open source and free:

http://www.gnupg.org/

You can only reference a column (or columns) that have a unique constraint or index.

If the column you want to reference is unique by itself, then you can add a...

One solution would be to change the DATATYPE of the IDENTITY column to BIGINT.

You would have to reload the table, and you would have to change foreign key columns in...