quote:

---

Also, there is a problem in SQL Server with identity column when recovering from crashes. This has existed in SQL Server...

Here is another way.

select DAY(DATEADD(d,-1,DATEADD(m,DATEDIFF(m,0,GETDATE())+1,0)))

The bennifit is it is just a bit shorter and requires replacing only 1 GETDATE().

Or this which is even shorter

select DAY(DATEADD(m,DATEDIFF(m,0,GETDATE())+1,-1))

-1 represents 12/31/1899 and since the...

Great resource is http://www.aspin.com/

Then say your column name is birthdate do like so

select birthdate, datediff(yyyy,cast(birthdate as datetime),getdate()) - (CASE WHEN dateadd(yyyy,datediff(yyyy,cast(birthdate as datetime),getdate()),cast(birthdate as datetime)) > GETDATE() THEN 1 ELSE 0 END) as...

I would definently bring this to their attention. Seems like a waste if they don't help you with their solution or take your findings into account. Otherwise sounds like a...

I use workstation a lot since I do app developement in VC++ and VB and need to be sure that I am able to run on key platforms. Plus I...

This is the way I get age.

DECLARE @d datetime

SET @d = '7/12/1974'

select datediff(yyyy,cast(@d as datetime),getdate()) - (CASE WHEN dateadd(yyyy,datediff(yyyy,cast(@d as datetime),getdate()),cast(@d as datetime)) > GETDATE() THEN 1 ELSE 0 END)

And...

I will say it would be nice if I could set a range to look for all the items I posted too. I have been in many conversations and have...

quote:

---

Nonclustered indexes can be defined on a table with a clustered index, a heap, or an indexed view. In Microsoft® SQL Server™...

If you are using SQL 2000 I would use bigint instead of varchar(10) which is 2 bytes large per row than bigint.

Why are you using unicode reference anyway when the...

I would also state that in doing that you need to explicitly issue a table lock to prevent other items from getting bad values.

You could create your own control table but what are you trying to accomplish?

Actually 1 is for SQL Server and 1 is for Programming. This does cause some confusion when both show up in Active Threads.

quote:

---

Hi James,

don't blame this on me. What I have written was taken word by word from a book about SQL Server Performance...

Understandable.

As for text link no. But you may not be familiar with Acrobat reader. If the data was text to begine with it is still text now. On the toolbar...