Forum Replies Created

Viewing 15 posts - 286 through 300 (of 497 total)

  • RE: create a table with two primary keys.

    GilaMonster (1/31/2014)

    Ryan George (1/31/2014)

    Be a Professional, Man..!!

    Good idea. Maybe take your own advice? Would you tell someone that you've never met and that you asked for free advice from to...

    January 31, 2014 at 2:09 am

    #1684953

  • RE: Replication not workiing

    Yes, there would be a SQL Agent job for it. You only need to generate a new snapshot if you need to reinitialise a subscription, e.g. because a new article...

    January 30, 2014 at 9:36 am

    #1684738

  • RE: Replication not workiing

    MarvinTheAndriod (1/30/2014)

    The Publication that say "The initial snapshot for publication is not yet available." is the one that isn't working.

    Should I reintialise again. Is it worth starting the snapshot...

    January 30, 2014 at 8:59 am

    #1684717

  • RE: Comparing string with date

    Hmm, just to come back on this. I tested both solutions after running DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE each time (I'm using a test instance obviously!) and i got the...

    January 30, 2014 at 8:00 am

    #1684685

  • RE: Comparing string with date

    Thanks Jeff and I totally agree with you about doing this the proper way using DATETIME data type which is what I prefaced my first reply to the OP with.

    January 30, 2014 at 7:35 am

    #1684670

  • RE: SSAS Deployment Utility

    Andrew Notarian (1/30/2014)

    ...Yikes. It sounds like a nice idea but must take a lot of work.

    It does. 🙂

    Edit: changed 'is' to 'does'

    January 30, 2014 at 7:19 am

    #1684662

  • RE: SSAS Deployment Utility

    I don't disagree with you in general and that's the way I've worked in the past. I think it is a situation peculiar to my current place of work where...

    January 30, 2014 at 6:52 am

    #1684632

  • RE: SSAS Deployment Utility

    Andrew Notarian (1/30/2014)

    In that case I think you are not going to find too many people who have used that. I don't think most people deploy the whole solution...

    January 30, 2014 at 5:52 am

    #1684614

  • RE: SSAS Deployment Utility

    Andrew Notarian (1/29/2014)

    The Deployment Wizard is nice for generating XMLA scripts to hand off the DBA, but once you've got your script it's very easy to automate using the tool...

    January 30, 2014 at 2:25 am

    #1684559

  • RE: SSAS Deployment Utility

    sneumersky (1/29/2014)

    Unfortunately, I have not really bothered with it. I usually automate my Tabular Model Processing using XMLA called via a SQL Server Agent job or by using AMO.

    Sure, that's...

    January 30, 2014 at 2:11 am

    #1684552

  • RE: Comparing string with date

    Jeff Moden (1/29/2014)

    Too bad because I finally learned how to copy'n'paste my SARGable solution correctly. :blush:

    Could you post your solution anyway Jeff?

    Regards

    Lempster

    January 29, 2014 at 10:01 am

    #1684395

  • RE: Data flow task (OLE DB) does not fetch all the stored procedure data

    Just a thought and obviously you wouldn't do this in Production, but you might have taken a backup and restored to a Test/Dev database:

    what happens if you delete row 715...

    January 29, 2014 at 9:52 am

    #1684386

  • RE: Replication not workiing

    MarvinTheAndriod (1/28/2014)

    The publications were reporting errors in Server A

    What errors were reported?

    January 29, 2014 at 3:32 am

    #1684214

  • RE: what would be optimal event selection for SQL profiler?

    Unless you can narrow your trace down to a specific user login and you are only going to run the Profiler trace for a short period of time, I suggest...

    January 29, 2014 at 3:05 am

    #1684203

  • RE: Comparing string with date

    As the first reply states, it would be easier to this using date or datetime data types, but assuming that you are locked in to using the varchar data type,...

    January 28, 2014 at 8:43 am

    #1683966

Viewing 15 posts - 286 through 300 (of 497 total)