Forum Replies Created

Viewing 15 posts - 6,481 through 6,495 (of 7,164 total)

  • RE: Join a query to a table

    Jason, your solution, while it may produce the correct result, will inevitably perform very poorly when run against a large set of data. I would offer one tweak to trade...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 11, 2011 at 6:07 am

    #1322891

  • RE: Performance Issues with High Volume Inserts and Selects on same table

    Rob Schripsema (5/10/2011)

    To piggy back a little on what opc.three was saying...

    You have relatively wide records with clustered indexes. If the order of the data in the clustering index fields...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 10, 2011 at 4:50 pm

    #1322682

  • RE: Join a query to a table

    PHXHoward (5/10/2011)

    Thanks Jason.

    I gave the row a name 'test' and then it ran.

    It adds a new row for each application.

    instanceid application

    417row test=",Application1

    417row test=",Application2

    418row test=",Application3

    instead of

    417 ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 10, 2011 at 2:58 pm

    #1322652

  • RE: Copy database in sqlserver 2008

    armm1388 (5/10/2011)

    but source bank is sqlserver 2000 and destination is sqlserver 2008.

    therefor by backup and restore . it can't be done . system give error.

    what is the solution?

    It can be...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 10, 2011 at 2:36 pm

    #1322645

  • RE: Getting SQL Server version from multiple servers.

    Yep, that works as well.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 10, 2011 at 2:09 pm

    #1322632

  • RE: Getting SQL Server version from multiple servers.

    Try this:

    $dt | select-object Name,Version,ServicePack,Edition | Export-csv C:\DBAScripts\Test.csv -NoTypeInformation

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 10, 2011 at 11:11 am

    #1322516

  • RE: Security Best Practice

    Syed Jahanzaib Bin hassan (5/10/2011)

    If you dont want to require an audit and specific user actions then create SQL server role for the specific group as SALES and create sales...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 10, 2011 at 10:41 am

    #1322488

  • RE: Batch File For Executing Multiple SP's

    kr.nithin (5/5/2011)

    Hi,

    The scenario is that I have got around 30 SP's to be executed & my manager wants me to create a single batch file for all the SP's. Please...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 10, 2011 at 9:02 am

    #1322382

  • RE: Performance Issues with High Volume Inserts and Selects on same table

    facticatech (5/10/2011)

    - How many tables?

    6 . Already mentioned.

    You did, sorry I missed that.

    facticatech (5/10/2011)

    - How are the inserts being done? OLE DB destination, Calling a stored procedure for each...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 10, 2011 at 6:56 am

    #1322249

  • RE: Batch DOS-special characters and SQL 2005

    freewarefw (5/10/2011)

    Hi,

    here the order of execution :

    1)-run file migrate_all.cmd that execute the command :

    call CheckSQLVersion %1 %2 %3 %4 %5

    @if %errorlevel%...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 10, 2011 at 6:45 am

    #1322243

  • RE: Calculating Median and Percentiles

    I was just researching Median on SQL Server last week. Here is a good series of articles from some very qualified folks where a back-and-forth discussion broke out on the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 9, 2011 at 9:45 pm

    #1322076

  • RE: T-SQL equivalent for group_concat funtion

    apat (9/10/2010)

    select group_concat (Col1 order by field(Col2,8,13,15,53,55,6,73)) as FinalColumn from TestTable

    Are you sure that's your SQL statement on MySQL? GROUP_CONCAT is an aggregate function so the SELECT statement that makes...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 9, 2011 at 9:36 pm

    #1322072

  • RE: Performance Issues with High Volume Inserts and Selects on same table

    You will have to provide a lot more detail before anyone will be able to provide a solid recommendation on how to improve your situation.

    Here are some initial questions...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 9, 2011 at 1:52 pm

    #1321974

  • RE: Batch DOS-special characters and SQL 2005

    Have you tried surrounding the parameter values with double-quotes?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 9, 2011 at 1:10 pm

    #1321958

  • RE: Deleting Files older than n days using SSIS

    Dave23 (5/4/2011)

    I needed similar functionality, to remove files older than 14 days old. I wound up using the following, based on the DOS ForFiles command:

    Forfiles -p E:\backups\test /m *.bak...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    May 6, 2011 at 7:14 pm

    #1321347

Viewing 15 posts - 6,481 through 6,495 (of 7,164 total)