Thanks Razvan

I will check out single quotes, could be a nasty bug...

Hi there

Actually, its the first ive seen the MSDN link, and there is no problem I see it using this method also. Its like all things tech, 101 different solutions...

Great article David, I know zero about stats functions, great intro.

Cheers

Ck

Hi there

What do you see when you run DBCC LOGINFO ?  how many of the virtual logs are of status 2 (aka inuse by the engine, either checkpointing or writing...

Hi there

A tad short! 🙂 but a very interesting topic that ill have to explore a little more, thanks for the article.

Have a good xmas mate

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server...

hi there, very observant actually, this is a bug, we altered it just the other day to 2000, the size really blows out for large search strings... thanks again.

Chris Kempster

http://www.chriskempster.com

Author...

Hi there

Calvin - interesting script.

So the script for example tells me this:

CREATE STATISTICS [hind_119723529_2A_9A] ON [dbo].[Address] ([address_addresstype_id], [address_org_id])

is a duplicate with:

CREATE INDEX [addrtype_orgid_ix] ON [dbo].[Address]([address_addresstype_id],...

Hi all

Your not going to believe this, good ople SQL Server Yukon Beta 1 is only avail for MSDN Universal subscribers in the US (on request), us Aussies were given...

Hi Frank

I hear you loud and clear 🙂

Thanks for the article btw, I actually did enjoy it along with your others... I have a real admiration of Codd et al...

With the é (accented characters). No matter the language settings for the character fields (ie. accent insensitive), we found the é and other such characters wouldnt translate, so café...

For those interested, alter the final @search assignment to this:

SELECT @search = 'ISABOUT("' + @rawsearch + '" WEIGHT(.8), ' + @search2 + ' WEIGHT (.7), ' + @search + '...

Hi there

Very nice indeed, I will alter the routine with a new parameter for this option and see how it goes in test.

Thanks again.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for...

Hi there

(2) Yes, and updated on subsequent log shippings. Check your recovery model on your source DB, if bulk-logged ensure the selected operations are fully logged so changes...

Hi there

Ok article, not sure what I got from it though 🙂 Codd and co had his day, and the pioneer work done in and around this era was...

Hi there

The federation concept (via the linked servers and unioned views etc) is the architecture im saying is not worth the trouble. I can think of some rare cases,...