Hi there

I started an Ebook on this a while ago, but thats not going to help you too much 🙂

Anyhow, to be honest, it takes a lot of...

Hi all

A popular DB vendor has a product in Beta (along with some other great functionality) that does most of the functions I described. Im not sure if I...

Hi there

Good thinking, i tried this at the column level:

CREATE TABLE [dbo].[cktest] (

[id] [int] NOT NULL ,

[col1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL

) ON [PRIMARY]

GO

going for the "AI" (accent...

Hi there

Good point actually! 🙂 I was more interested in the underlying architecture of SQL Server purely from a "i wonder" point of view initially. I also like...

Hi

16 users hey, DSS or OLTP, what sort of read/write activity are you looking at. To be honest, unless is really intense access and its a large db, you...

Hi there

Can you explain the errors you are getting? perhaps a rebuild is uncalled for and the fix is quite simple.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Hi there

I like to use the read and write queue length counters for each array (divide my disks in the array) when measuring IO, run this for some time though...

Not that im aware of. This is a fundamental requirement for transaction consistency.

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Hi there

Please email the exacte messages in the log.

Also, what does the database show up as in EM?

Run this query and post the results:

select name, dbid, mode,status,status2

from master..sysdatabases

Your db...

Hi there

Nice article, ive used similar code before to locate email columns etc when organisations change email address structures etc, all very handy indeed and damn site easier than...

Hi

SQL Server cant be used unless you have a Windows licence. So, if your running CALS on the OS, one gets chewed here and again for the user accessing...

if you want to go cludgy and nasty, try system architect 🙂

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Try:

'"word"'

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"

Well, this is an open question 🙂

I like Visio, not really a db design tool as such, more a diagrammer, but great all the same. I would also consider...

Hi

Please dont double post. Makes life harded when tracking your problem/responses.

Cheers

Ck

Chris Kempster

http://www.chriskempster.com

Author of "SQL Server 2k for the Oracle DBA"