Forum Replies Created

Viewing 15 posts - 4,216 through 4,230 (of 5,356 total)

  • RE: Indexes

    Hi Marco,

    quote:

    I've got some problems with SQL Server 2000 SP3: some stored procedures have got strong degradation in performance; the problem seems...

    August 18, 2003 at 4:04 am

    #470241

  • RE: Concatenation

    Hi Andrew,

    quote:

    Preethi's suggestion worked, cheers Preethi

    didn't you say the LTRIM, RTRIM doesn't work for you?

    Cheers,

    Frank

    August 18, 2003 at 4:00 am

    #470240

  • RE: Reindexing the system tables

    Hi Gabor,

    another forward

    quote:

    Originally posted by eyechart

    First, a couple of comments:

    quote:

    Originally posted by shsmonteiro

    Just a...

    August 18, 2003 at 12:52 am

    #470227

  • RE: Reindexing the system tables

    Hi Gabor,

    forwarded!

    ...

    BTW, this is an answer from Paul Randal DBCC Technical Lead, Microsoft SQL Server Storage Engine

    in sqlserver public forum

    "It's not possible to defragment system tables in SQL Server...

    August 18, 2003 at 12:52 am

    #470228

  • RE: SQL Server Tools

    Hi Brian,

    quote:

    Would a typical SQL Server DBA or database developer ever be willing to buy a coherent and comprehensive package of advanced...

    August 18, 2003 at 12:07 am

    #470226

  • RE: Microsoft - Looking for Devs, Testers, and PMs

    To piggy-back on Andy, here in Germany you are expected to contact the company first to show engagement, motivation, interest in the company, and not wait till you see an...

    August 17, 2003 at 11:55 pm

    #470225

  • RE: pass list of values as parameter to stored proc

    Hi Naveen,

    unfortunately it is not possible to pass something like ParamArray in VB to a sproc.

    However, you have two option available. Split string before passing. I think you can...

    August 15, 2003 at 2:28 pm

    #470154

  • RE: Tools to calculate db size

    Hi Gabor,

    quote:

    What do you meen by estimating the db size?

    Size of the existing or a planned db?

    August 15, 2003 at 1:27 pm

    #470147

  • RE: How to extract time part of a datetime field

    Hi Patrick,

    quote:

    I wonder how long CONVERT will be around now that CAST is available. I've heard in other forums that CONVERT will...

    August 15, 2003 at 1:21 pm

    #470146

  • RE: Do you think DBA is a desirable job?

    Hi there,

    anyone of you affected by the power shortage ?!?

    Cheers,

    Frank

    August 15, 2003 at 1:16 pm

    #470145

  • RE: Help with query

    Hi myoldhouse,

    for relating you can use 'Outer Join'.

    But, as Andrew said, what do you want to do? Can you post an example with 'real' data?

    Cheers,

    Frank

    August 15, 2003 at 8:01 am

    #470115

  • RE: Concatenation

    Maybe this thread can help

    http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12594

    Cheers,

    Frank

    August 15, 2003 at 7:14 am

    #470103

  • RE: Concatenation

    Hi Dan,

    funny things happen, when you think too long on an answer

    Cheers,

    Frank

    August 15, 2003 at 6:58 am

    #470098

  • RE: Concatenation

    and what does DATALENGTH show you?

    Is cust_id large enough to take all the data?

    What about converting to varchar and then updating?

    Cheers,

    Frank

    August 15, 2003 at 6:57 am

    #470097

  • RE: Concatenation

    quote:

    I can see what the function does by your example, but as far as I can see it returns an obvious answer,...

    August 15, 2003 at 6:35 am

    #470092

Viewing 15 posts - 4,216 through 4,230 (of 5,356 total)