Forum Replies Created

Viewing 15 posts - 31 through 45 (of 162 total)

  • RE: Servr patching install

    As already stated, I would be certain that you have an actual issue that the CU will fix (read the release notes for the CU). Microsoft do not fully...

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: sql version

    Interesting. Can't see this version on the sql server build list:

    http://sqlserverbuilds.blogspot.co.uk/

    whats the output of SELECT @@VERSION?

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: Convert Varchar to Date??

    I prefer this method (sql 2008 + )

    SELECT CONVERT(DATE,'Jul 24 2013 8:05AM')

    Gives the result:

    2013-07-24

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: Identifying SQL Agent Job Name based on the job id.

    Looking in the following msdb tables is usually a good place to start:

    msdb.dbo.sysjobs

    msdb.dbo.sysjobsteps

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: Where is Left table in Left Join ???

    It's the table left of the JOIN operator for a left join and right of the JOIN operator in a right join.

    SELECT *

    FROM Table1 -- <-- Left Table (data...

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: SQL Server Startup Options

    GilaMonster (6/9/2013)


    -f on the SQL Server executable is not a format file setting. It's minimal configuration startup option.

    The -f parameter on BCP.exe specified a format file, and on BCP.exe -F...

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: SQL Server Startup Options

    -F

    Im not sure it even exists if i'm honest. I know -f but that's for BCP format file....

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: TVCs

    I wrote a little blog on this a few weeks ago:

    http://loundonsql.com/?p=16

    Hope this helps 🙂

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: Creating two databases at the same time, strange behavior

    Has the recovery model of the "model" db changed? New dbs get their recovery model initial setting from the model db. Could this have changed in between creating...

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: Decimal(18,0) or int?

    maybe I should learn to read 🙂

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: Decimal(18,0) or int?

    wouldn't it also cause all values to round down? i.e 5.5 to 5, 6.1 to 6 etc....?

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: cluster

    sqlfriends (5/24/2013)


    I will.

    Yes, I think what we have created two instances on node 1, one is for pro, th other is for qa, then we added the same two instances...

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: SQL Consulting Help

    s_osborne2 (5/24/2013)


    Hi,

    I'd fully endorse Coeo too if you're in the UK. We've had them in twice and they were really superb.

    Thanks,

    Simon

    There not just UK based - there international based :)...

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: SQL Consulting Help

    There are loads out there, first one that came to mind was Coeo - http://coeo.com/

    [font="Times New Roman"]There's no kill switch on awesome![/font]
  • RE: Databas Shrink

    Paul Treston (5/24/2013)


    Loundy (5/24/2013)


    its unlikely to shrink while there is an active connection, try disabling the account that's connecting and try again. Ensure you are aware of the impact...

    [font="Times New Roman"]There's no kill switch on awesome![/font]

Viewing 15 posts - 31 through 45 (of 162 total)