Viewing 15 posts - 76 through 90 (of 478 total)
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...
October 27, 2003 at 8:27 am
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...
October 27, 2003 at 6:47 am
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...
October 22, 2003 at 8:37 pm
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...
October 16, 2003 at 1:12 am
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...
October 13, 2003 at 8:29 pm
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
Author of "SQL Server 2k for the...
October 5, 2003 at 8:32 pm
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...
September 24, 2003 at 7:33 pm
Not that im aware of. This is a fundamental requirement for transaction consistency.
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
September 19, 2003 at 1:58 am
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...
September 18, 2003 at 11:39 pm
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...
September 18, 2003 at 11:29 pm
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...
September 17, 2003 at 9:09 pm
if you want to go cludgy and nasty, try system architect 🙂
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
September 17, 2003 at 8:25 pm
Try:
'"word"'
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
September 17, 2003 at 6:39 pm
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...
September 17, 2003 at 6:38 pm
Hi
Please dont double post. Makes life harded when tracking your problem/responses.
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
September 17, 2003 at 4:42 am
Viewing 15 posts - 76 through 90 (of 478 total)