Steve Jones - Editor (8/18/2008)

---

The kids do get loud. Last summer, when we had them home part of the summer, it was hard to work. Ended up working at night...

mtassin (8/8/2008)

The Square Root of -1 is i, which is an imaginary/complex number. It cannot be returned as a float data type because it is out of the domain...

Good article, Ian. Ignore those ignorant enough to criticise without giving a reason. And to those who carp about bugs in the code, I say this: Debug it...

Charles

I didn't realise anybody even used FAT any more! MDF files have the potential for fragmentation, as you say, but in general the data in them doesn't grow and...

Nobody has yet mentioned another reason for not shrinking the log on truncate: physical file fragmentation. If, when the log grows, it can't find a contiguous area on the...

For enlightenment, read this article and then wade through the discussion:

http://www.sqlservercentral.com/articles/Miscellaneous/2748/

John

You can look in sys.indexes to find the name of the index. You can then either script the view through SSMS, or join to sys.objects to find out what...

majorbloodnock (6/2/2008)

---

For instance, I found out that, in the UK, when Christmas falls on a Saturday, the following Monday is the Boxing Day bank holiday and the bank holiday in...

Very interesting. But I think I'm happy enough just looking it up in a diary!

Actually, I think it failed for me because my default language is British English. ...

Perhaps they were thinking of the distribution database, which may be created when you configure replication.

John

Didn't work for me, I'm afraid. Tried to calculate this year's Easter date.

Msg 242, Level 16, State 3, Procedure fcn_FindEasterSunday, Line 39

The conversion of a char data type to...

Scott

I don't know how the port selection is made, but I do know that you can fix the port if you go into SQL Server Configuration Manager.

John

preetha.sathyamoorthy (6/2/2008)

---

Hi John,

I tried your query. It's giving the correct output. The output is starting with 0 only, If the id is starting with 1. If it is starting with...

Rajan John (6/2/2008)

---

try some form of this -

select a.id - 1 from table_name a where not exists( select b.id from table_name b where a.id = b.id + 1)

the first...

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/29248949-325b-4063-9f55-5a445fb35c6e.htm