I just use the db_owner database role for our developers, and all objects that are created are owned by dbo by default.

The execution plan for a stored procedure is built the first time it is executed.  So, what may happen is that the optimizer will produce a plan that is only...

The previous post about the SQL cache is something not to ignore.  Fix any network problems first.

After you have eliminated the network as a possibility, try running your tests again,...

We have a scanning system that runs a named instance of SQL (that is what your second instance is) that is locked down to enforce their licensing scheme. 

I use the maint plans.  They work reliably, and have all the options I care about.  I supplement them with a couple of other jobs, such as log shipping and...

The general idea is to subtract 2 days for the number of weeks between the dates.  If you know that the start and end dates are always weekdays, that is...

What happens in a normal database?

That's on the same line as my thought.  It would make sense to test this using a normal user account, rather than the administrator account.

What about something like:

     @query = 'Select trim(customername) + '' '' + custno + '' '' + dateregistered as customer_info From Customers WHERE IsPendingEmail =1',

You will need to add convert if...

According to salary.com, the range of salaries in Richmond is $70,430 to $94,080 for a database administrator.

Somewhere in the forum there was a post about the registry entry that determined the security mode: SQL or Mixed.

That might be the place to start.  If you can get the...

Probably most of us have assigned ourselves "db_owner" in the database role area.  This would explain why tables we create use dbo as the owner, while those others create may...

A common source of Overflow errors is the implicit conversion of a string to a number.  If you have a where condition such as "WHERE integerfield = stringfield" SQL will...

The job specifies "on site" but there is no indication where that site is.

I'd like to see the answer to that as well.  We're going to purchase a large system for Medical Records that uses both Microsoft and Oracle servers.  I can handle...