Forum Replies Created

Viewing 15 posts - 301 through 315 (of 612 total)

  • RE: use sql server client 2012 32 bit against sql server 2014 64 bit

    I have never had any problems but I need to ask why you need to do that?

    Secondly, backward compatibility is normally not too much of a problem but going forward...

  • RE: Slow Database and Big number of Blocked Spid

    sm_iransoftware (2/2/2015)


    Hi

    Our DB was slow from yesterday.

    (some times is good and some times long waits)

    I Run sp_who2 And many Blocked spid found.

    Such as : n spid blocked by 54

    When...

  • RE: Sql Server licensing

    Firstly, a development license cannot be used on a production machine.

    Secondly, before you worry about licensing consider which version of SQL Server will be used? Would the Express version...

  • RE: What are First Steps for a dba in new Office?

    GilaMonster (1/15/2015)


    The backups.

    Definitely but more importantly, the restoration process.

  • RE: Restore 2014 to 2008

    Not using traditional backup and restore methodology but it could work with BCP.

  • RE: Downgrade SCOM Database

    hcip.77 (3/4/2015)


    First why you need to go back with SQL 2012 standard from SQL 2012 Enterprise.

    Licensing costs is a good reason. Especially if the machine is running on a...

  • RE: Downgrade SCOM Database

    Hi,

    as long as you aren't using any features associated with the Enterprise version you could simply take a backup and restore it on the downgrade machine.

  • RE: Server/database consolidation questions

    How many software installations of differing versions on one box: 1

    How many instances? 1 if it is possible. I have instances that require different collations for example.

    How...

  • RE: Restore

    ramyours2003 (3/5/2015)


    from one of my colleague he said by changing the compatibility mode while restoring the backup from sql 2014 to sql 2012

    Your colleague is most definitely wrong. ...

  • RE: Restore

    ramyours2003 (3/5/2015)


    Thanks for the reply , I know its not possible but if it is possible would like to know the procedure of restoring from higher to lower version...

  • RE: BULK INSERT with a format file

    Hi Gianluca,

    brilliant! Thanks for the link. I'll post again with my solution.

    As for your suggestion......

    It would be a good one in most cases but unfortunately for us it...

  • RE: compatability level question

    GilaMonster (2/24/2015)


    kevaburg (2/24/2015)


    So I migrate a 2008R2 database to 2014 and do not alter the compatibility mode. I have in end effect a database running on a 2014 Server...

  • RE: compatability level question

    GilaMonster (2/5/2015)


    Only reason would be if you want some older behaviour of the query execution engine. An example there was that the *= join syntax is only available in compatibility...

  • RE: BCP reports no errors but inserts no rows

    Jim Mackenzie (2/20/2015)


    Jeff Moden (2/20/2015)


    Jim Mackenzie (2/20/2015)


    However I can't help but think this would be better handled in Powershell?

    Do you happen to have a working example of such a thing?...

  • RE: BCP reports no errors but inserts no rows

    Hi Folks!

    Firstly, thanks for all the Input. I decided to try the same procedure as a Loop using BULK INSERT.

    It isn't perfect, but it works!

    create procedure sp_Ladung_OptionGroesseKollektionStatistik

    as

    --Create a holding...

Viewing 15 posts - 301 through 315 (of 612 total)