Jobs normally run in the context of the SQL Server Agent service.

Edit:

Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service

http://support.microsoft.com/kb/942176

Google is your...

That may be of...

A snapshot is the database as it existed at the point in time the snapshot was created, including the schema.

“Cloud Computing”?

I guess someone came up with a new BS name for external hosting and/or timesharing.

Wake me when the next “next big thing” comes along.

It appears from this that only dbcreator and securityadmin are required:

SharePoint Server 2007

Plan for administrative and service accounts (Office SharePoint Server)

http://technet.microsoft.com/en-us/library/cc263445(office.12).aspx

I never looked into this before. I just insisted...

We have a number of Sharepoint servers, and we have never used the SA login or used an account in the sysadmin role for the Sharepoint account.

I just checked one...

They will more than likely have identical execution plans.

You should look at the query plans for both so that you can tell for yourself.

David O (7/9/2010)

---

Grant makes an interesting point. I still remember the launch event for Sql 7 and the presenter saying that new features eliminated the need for the DBA...

This conversion looks close to what you want:

select

*,

MyDateTime =

dateadd(mi,convert(bigint,a.MyTime-998799780)%convert(bigint,1440),dateadd(dd,(a.MyTime-998799780)/1440,0))

from

( -- Test Data

select MyTime = convert(bigint,1056915413)union all

select MyTime = 000001056915413+(00000000001440*2918000)

Results:

MyTime ...

and it wouldn't be hard for the optimizer to know that information for built-in functions

and there could be a hint for user-defined functions"

That is just your opinion. Had you...

You didn't post any evidence to support your contention that IO is an issue. Perf mon counters, etc. What are the results you saw when you ran standard...

Has anyone implemented table compression in conjunction with TDE?

What was the impact of compression and TDE on database size, compared to a database with just TDE or just table compression?

It...

TravisDBA (7/6/2010)

---

I am talking about compressing the backup, not compressing the database then encrypting it,, But anyway, I don't remember seeing that anywhere in SQL 2008 BOL? That would be...

Since you...

You cannot use IF in a DML statement. You should use a CASE expression.

Example:

case when TRXAMT = CURTRXAM then 0 else CURTRXAM end