Forum Replies Created

Viewing 15 posts - 541 through 555 (of 806 total)

  • RE: Record Size Limitation

    You can use TEXT which can hold upto 3GB of data.

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    January 2, 2004 at 1:09 am

    #488442

  • RE: Cluster size on SAN.

    Thanks Mike.

    Why do you say I might end up with worse performance?

    If IO is only done for pages then a 8k cluster would be best(?)

    Although, having a 64k cluster would...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    January 1, 2004 at 11:02 pm

    #488438

  • RE: Cluster size on SAN.

    quote:

    Crispin -

    I don't have numbers to back this up. But I found better performance when I formatted my SAN with 64k...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    December 30, 2003 at 10:38 am

    #488235

  • RE: Resizing tables and rows to better fit into pages

    Gabor, thanks for the info.

    quote:

    You can create a table having a larger row size as 8060 but you will have an error...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    December 30, 2003 at 10:30 am

    #488228

  • RE: decrypting an encrypted view

    http://www.sqlservercentral.com/scripts/contributions/622.asp will do it.

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    December 10, 2003 at 11:25 pm

    #485654

  • RE: Group By Possible?

    Thanks!

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    December 9, 2003 at 11:18 pm

    #485468

  • RE: Dynamic Order By problem

    Thanks!

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    November 20, 2003 at 12:19 am

    #482791

  • RE: Number Format

    Select Convert(Decimal(10, 2), 12.23653)

    You can replace the number with the coulmn name.

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    November 19, 2003 at 5:08 am

    #482589

  • RE: Installing SQL Server on client system

    From a cost point of view, I would not roll out Enterprise edition to clients.

    Have a look at MSDE which is on the Office 2000 CD.

    This is a brokendown version...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    November 19, 2003 at 1:06 am

    #482557

  • RE: Newbie to analysis service

    Thanks. Will have a look

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    November 18, 2003 at 10:05 pm

    #482542

  • RE: Specifing Index to be used in From clause

    -- Use the specifically named INDEX.

    USE pubs

    SELECT au_lname, au_fname, phone

    FROM authors WITH (INDEX(aunmind))

    WHERE au_lname = 'Smith'

    See BOL: Select > Examples.

    Why would you want to force it? Does the optimiser not...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    November 18, 2003 at 11:06 am

    #482485

  • RE: can u Alter a table (add a field)

    Create Table Test (

    Col1Varchar(200),

    )

    Go

    Alter Table Test Add Col2 Varchar(200)

    Go

    See "ALTER TABLE" in BOL for more options. ie NULL, NOT NULL, DEFAULT etc etc

    Cheers,

    Crispin

    Edited by - crappy on 11/18/2003 10:27:46...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    November 18, 2003 at 10:27 am

    #482475

  • RE: Calculating Distance

    Credit to Neil.

    http://www.sqlservercentral.com/scripts/contributions/660.asp

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    November 17, 2003 at 10:16 pm

    #482355

  • RE: Can UD Function be called from SQL

    Not that I am aware of.

    I am assuming you are calling the function from a proc.

    Could you not insert the row into the table from within the proc, use the...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    November 17, 2003 at 10:39 am

    #482252

  • RE: Can UD Function be called from SQL

    I sort of misread your post.

    No, procs cannot be called from within a function.

    Yes, functions can call functions.

    Functions can call extended procs.

    To get this to work, either copy the code...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

    November 16, 2003 at 10:35 pm

    #482160

Viewing 15 posts - 541 through 555 (of 806 total)