I always use

set statistics io on

set statistics time on

to get a grip rearding what SQLServer has to do for my query.

That in combination with the graphical execution plan opens...

can you post the query you're trying to execute (including the table ddl) ?

In many cases a "not exists" outperforms your in-list.

It's certainly worth the test !

select...

from bol:

-w column_width

Allows the user to set the screen width for output. The default is 80 characters. When an output line has reached its maximum screen width, it is broken...

Did you get to the MS licensing doc ?

http://www.microsoft.com/sql/howtobuy/sqlserverlicensing.mspx

SQLServer2005Licensingv1.1.doc

It has some scenarios that may help you figure it out.

IMO it's best to monitor for a while before getting proc. licenses.

(Also...

Don't you just love the way a simple question - with some context - with the possibility of being ambiguous triggers a bunch of discussions.

"Make it fool proof and they...

I just wonder:

- how many figures behind the decimal point is their working unit :w00t:

- do they have ctrl+alt+del :hehe:

- do they run on alpha software or RC-1 😀

- finally...

Lynn Pettis (9/11/2008)

---

Unfortunately (or not), I disagree. By specifying SQL Server 2005 in the question, that should automatically eliminate SQL Server 2000 tools from the equation. In my...

Emilio.Mendoza (9/10/2008)

---

Thanks for the reply I've already use those options, probably I didn't explain myself correctly, I need to have the DBO name and the login 'NT AUTHORITY\NETWORK SERVICE' I...

... I don't think that the database should be enforcing the front-end validations, since from a performance standpoint, this would initiate extra DB communication and network traffic if, for example,...

David Paskiet (9/10/2008)

---

UNfortunately, I am trying for the quick and lazy solution. Coding another solution is not my idea of fun to rehash work alreayd done. :: sigh...

1) you could install a connectivity client (but you'll have to check if that contains OSQL)

2) as a workaround, you could "remote submit" the bat file using sysinternals psexec.

1) what's the info in the job step history.

2) your first step should work, you'll need to add ", replace" if you want to overwrite the current db !

3) you...

how about...

declare @startdate datetime, @enddate datetime

SELECT @startdate = dateadd(dd, (-6 - DATEPART (dw, getdate())),DATEADD(dd,DATEDIFF(dd,0,getdate()),0))

, @enddate = DATEADD(dd,DATEDIFF(dd,0,getdate())+ 1 ,0)

print convert(varchar(26), @startdate,121)

select yourcolumn list

from yourtable

where thedatetimecolumn between...

proving once again one should provide index on a FK column,

unless actually tested that it hurts that particular system.