Forum Replies Created

Viewing 15 posts - 211 through 225 (of 2,640 total)

  • RE: "Report Services instance could not be found".

    it's probably a silly question but did you check the service was running?

    Can you connect locally on the box?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: SET ISOLATION LEVEL - Proper usage?

    I don't think you need to be so harsh about serialisable transactions, you just need to explain that it effectively puts the database into single user mode - you'd need...

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: SSRS Configuration

    hmm interesting - I'm running under domain accounts but our datacentre don't support Kerberos so I don't know why it all works for me to be sure. I made no...

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: Logging Foreign Key violations

    enable logging for the error numbers so it's written to the sql error log.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: SSRS Configuration

    name/reports should do it.. If I remember correctly using the ip address usually forces a login.

    I seem to remember that sometimes the first time you connect a login box...

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: DB mirroring /Reporting Environment

    snapshots are fine - most of my servers have lots of power to spare, the problem I had was that nearly all the reports had to do a load of...

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: DB mirroring /Reporting Environment

    note that you can't issue any writes and your mirror server must be licensed. ( normally failover/standy servers don't require sql licenses )

    I will say I did some tests with...

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: Migrate Server 2008 R2 from VM to physical

    sorry didn't fully answer your question - there are no real pitfalls to moving san volumes about - BUT - I'd make a backup somewhere else first just in case....

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: Migrate Server 2008 R2 from VM to physical

    you can't just detach and attach system databases - you'll need to find the relevent kb article.

    The quickest way to move mdfs or backups when you have a san is...

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: Any views on GreenSQL ?

    It's not so much how much much you spend on security as how much it will cost you if your security fails!

    I must admit to always having hardware firewalls...

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: SQL Server 2008 R2 Max Memory Settings

    I'd suggest you start with 56GB out of 64GB for SQL Server max memory and work from there. There have been so many blog posts from the microsoft teams over...

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: Linked Server Difference between Openquery /Exec At/Four part Linked Server

    yup I agree with you opc.three. You can't just declare replication will solve this that and the other. when databases/tables are large making changes or re-initialising the objects...

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: SSRS Report VERY slow

    hmm that's interesting, I did at one stage try gauges on my dashboards but they took up too much room compared with the normal pie or bar charts - I...

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: Constraints Check

    I so love following this type of post because it's real world practical stuff that it's good to know as who knows what the business/developers are going to throw at...

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • RE: TImeStamp

    ah .. but have you tried to use rowversion?

    http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/09/30/rowversion-vs-timestamp-what-s-the-word-then-microsoft.aspx

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 15 posts - 211 through 225 (of 2,640 total)