Viewing 15 posts - 121 through 135 (of 174 total)
I just use the db_owner database role for our developers, and all objects that are created are owned by dbo by default.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
March 22, 2005 at 11:33 am
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
March 15, 2005 at 11:00 am
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,...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
March 9, 2005 at 10:44 am
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.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
March 8, 2005 at 11:04 am
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
March 4, 2005 at 10:34 am
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
February 18, 2005 at 1:28 pm
What happens in a normal database?
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
February 17, 2005 at 2:05 pm
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.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
February 17, 2005 at 2:04 pm
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
February 17, 2005 at 1:33 pm
According to salary.com, the range of salaries in Richmond is $70,430 to $94,080 for a database administrator.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
February 16, 2005 at 11:14 am
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
February 16, 2005 at 11:11 am
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
February 16, 2005 at 11:01 am
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
February 15, 2005 at 11:10 am
The job specifies "on site" but there is no indication where that site is.
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
February 15, 2005 at 11:05 am
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...
So long, and thanks for all the fish,
Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3
February 15, 2005 at 11:03 am
Viewing 15 posts - 121 through 135 (of 174 total)