Forum Replies Created

Viewing 15 posts - 2,251 through 2,265 (of 2,603 total)

  • RE: formatting T-SQL

    Eric M Russell - Friday, August 3, 2018 8:25 AM

    Even better, you can enforce your T-SQL formatting standard using SQL Server's...

  • RE: BCP Error

    you running that on your machine or on the server through cmdshell or sql server agent job? if on the server the files need to be on the server C:...

  • RE: formatting T-SQL

    Free versions already mentioned.
    For paid versions
    RedGate - SQL Prompt 
    DevArt - SQL Complete
    Neither completely good, one better on particular things, the other better on other things. DevArt...

  • RE: SSIS decimal conversion working funny

    can you post the sql you using as your source on the dataflow mentioning which column is giving you the undesired result.

  • RE: SSIS decimal conversion working funny

    Taking in consideration what the output is I do not believe that you are doing a convert to decimal 38,10 on source, neither is the output defined with the same...

  • RE: OLEDB and Attunity both are slow with CLOB IN SSIS

    Could you post the C# code here so we can have a look at it and eventually suggest any modification.

    And it will always be slow - just not...

  • RE: OLEDB and Attunity both are slow with CLOB IN SSIS

    Trick is "do not use SSIS".
    SSIS is very slow with clobs regardless of the driver used (possible exception of third party ones like CozyRoc and similar as i do...

  • RE: How to pass and use Variable on CTE

    Luis, I think you failed to understand what others were trying to explain but as I may be wrong can you explain to us how you will determine the content...

  • RE: Left padding a FLOAT type with zeroes

    perfectly normal - floats do not convert to varchar the way you expect.

    DECLARE @myInt float = 5555555;
    SELECT CAST(@myInt AS VARCHAR(12)), RIGHT(REPLICATE('0',8) + CAST(cast(@myInt as int) AS VARCHAR(8)),8)

  • RE: NULL Tests

    small error on it as first 2 options are the same - did pick up one of the 2 set nulls off and got the wrong one

  • RE: Error Powershell

    This really should not be sent to standard output but rather redirected to a database or a file as volumes can be quite high.

    Import-Module sqlps -DisableNameChecking

  • RE: Error Powershell

    try

    Import-Module sqlps -DisableNameChecking
    $path='C:\localhost\serveur.txt'
    $serveurs=Get-Content -path $path

    $query="exec xp_readerrorlog 0,1"

    foreach ($server in $serveurs) 
    {
    invoke-sqlcmd -Query $query -ServerInstance $server
    }

  • RE: Update Test data from Production

    you also need to take in consideration licensing - if your dev boxes are using a SQL Server Developer license (being it a MSDN one or not) they can not...

  • RE: Push data from on-prem sql server view into cloud based MS Dynamics CRM database

    Issue with MS CRM is that you cannot insert data directly onto their tables as doing so will void the maintenance contract.
    if this is a PasS or SaaS you...

  • RE: Backup/Restore optimization using MAXTRANSFERSIZE, BUFFERCOUNT, BLOCKSIZE

    1 - and how many files you backing up to?
    2 - Using backup compression or not?
    3 - How many cores on the server?
    4 - Server Memory?

Viewing 15 posts - 2,251 through 2,265 (of 2,603 total)