Jeff Moden (6/28/2008)

---

That's kinda what I thought you were going to say.

What I was suggesting is that the distance from Point A to Point B is exactly the...

Grant Fritchey (6/30/2008)

---

One thing not mentioned is the use of copy & paste. We have a project that's actually, honestly, a little complex. In one place, we found we needed...

I generally use Windows domain security, and don't use mixed-mode. That means the sa account isn't active.

When I have had to use mixed security, I've used different, extreme passwords...

Try replacing your "print" commands with "raiserror", and use the "with nowait" option.

raiserror('aaa', 10, 1) with nowait

Print commands often wait till a buffer fills up before they send them to...

You can delete with a join.

delete Table1

from dbo.Table1

inner join dbo.Table2

on Table1.a = Table2.a

and Table1.b = Table2.b

left outer join dbo.Table3

on Table1.a = Table3.a

and...

You could do a join between the table and itself, something like:

;with

CTE1 as

(select client_id, t1.effective_date, t2.effective_date as end_date

from dbo.temp_census t1

inner join dbo.temp_census t2

on t1.client_id = t2.client_id

and t1.effective_date < t2.effective_date

and

(t1.event_description =...

I'm going to hazard a guess that the code is doing a lot of inserts and/or updates, because of the page splits. Beyond that, it's kind of hard to...

I don't know a way to find that automatically.

You can add the table names to your Where clause, and narrow down the search. But so far as I know,...

Numeric (also called Decimal) has a defined precision and scale. Float just uses defaults for that.

You can end up with overflow errors because of this.

For example, if you define...

I used Access 2003 on an SQL 2000 database for 6 years for a small company. Worked great. Definitely go with the adp (project) option, rather than the...

You have to capture them in the calling procedure or code. Currently, there's no real error handling in T-SQL UDFs.

You need to cast/convert at least one of the numbers to either float or decimal (or money, I guess) before you do the division.

Count returns an integer value. Math...

Well, off the top of my head, you could do something like:

select *

from sys.all_objects

inner join sys.sql_modules

on all_objects.object_id = sql_modules.object_id

where definition like '%nolock%' -- Put the hint(s) you're looking...

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

These two articles and their discussions have a bunch of data on how to implement logging, pros and cons of different methods, etc.

Have you tried adding a select after the exec command?

exec sp_Addnewsletter @IDSite, @name, @email, @Invalue output

select @Invalue as Invalue