Forum Replies Created

Viewing 15 posts - 1 through 15 (of 16 total)

  • RE: Upgrading SQL 2005 to SQL 2008 (in place)

    I have tried doing the same with a Default Instance of SQL 2000 Standard, and have the same result.

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    December 23, 2009 at 10:08 am

    #1096029

  • RE: SQL Server 7.0 - Number of Databases

    Thanks...

    The most annoying performance issue reported to me was when accessing the server with Enterprise Manager, apparently some people still do . ...

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    March 26, 2007 at 4:37 am

    #696832

  • RE: SQL Server 7.0 - Number of Databases

    Please ignore this post, i just realised it is in the wrong category

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    March 26, 2007 at 2:29 am

    #696816

  • RE: Writing to Excel

    Do you have a "create table" SQL task before the pump task?

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    September 27, 2006 at 12:06 am

    #662634

  • RE: Extracting data from multiple tables, avoiding duplicates.

    Try this, should be a lot more effective...

    Create table TblPublisher (Pub_ID int identity(1, 1) constraint PK_TblPublisher primary key(Pub_ID), Publisher nvarchar(255))

    go

    create unique index IX_TblPublisher on TblPublisher(Publisher) with ignore_dup_key on primary

    go

    insert into...

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    September 8, 2006 at 1:07 am

    #659277

  • RE: Summarizing Several Fields of a table.

    You can also a query Sreejith's statement, using a case statyement, that should properly pivot the data, if that is what you need.

    It is probably not the best way of...

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    September 4, 2006 at 1:09 am

    #658262

  • RE: Query Analyzer / Enterprise Manager Window Switching

    We have just re-installed the whole machine from scratch, windows, office, sql, etc and it seems to be working now.

    Thank you for your replies and patience...

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    December 8, 2005 at 11:35 pm

    #608583

  • RE: Several text files consolidate in one

    There is also a way of storing data about the different formats ("versions") of the files in a table.

    All you have to do then is to ensure that your DTS...

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    December 7, 2005 at 11:26 pm

    #608333

  • RE: Search date between mm1/yyyy1 and mm2/yyyy2

    Hi there

    This is basically what AJ also said... Try this:

    select * from TblName

    where

    convert(smalldatetime, cast(MonthField as...

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    October 14, 2005 at 12:57 am

    #597266

  • RE: set quoted identifier off in SQL

    Please post your "INSERT" statement...

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    September 12, 2005 at 4:51 am

    #589030

  • RE: Using EXECUTE with a Character for UPDATE and INSERT

    Happy to help.

    i had a lucky guess, i guess...

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    September 8, 2005 at 3:03 am

    #588339

  • RE: DTS job failing

    I had the same problem before as well.  I am not sure what your DTS does, but if for e.g. it exports to a file, the server will need to...

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    September 8, 2005 at 2:38 am

    #588333

  • RE: Using EXECUTE with a Character for UPDATE and INSERT

    I agree.  You either have the cat by the tailpiece, or you are giving us insufficient info, hehehe

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    September 8, 2005 at 1:56 am

    #588330

  • RE: Trim all user tables with nvarchar datatype

    There are actually a couple of ways to do this.  I use the folowing:

    declare TextColumnCursor cursor for select name from syscolumns

       where id in (select id from sysobjects where...

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    September 5, 2005 at 8:29 am

    #587601

  • RE: SQL Server Image Data Load

    Do you need to load image data into the database?  From personal experience and advice I received before I would think it better...

    <hr noshade size='1' width='250' color='#BBC8E5'>Kindest Regards,

    Roelof
    <a href='http://' class='authorlink' target='_blank'></a>

    --There are only 10 types of people in the world. Those who understand binary, and those who don't.

    September 1, 2005 at 7:48 am

    #586819

Viewing 15 posts - 1 through 15 (of 16 total)