Forum Replies Created

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

  • RE: Recovery Model - SIMPLE V/S FULL

    I think the question(s) that you have missed is - Do you require a point in time restore? What is your recovery point objective on that datasbase?

    If you have...

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    June 17, 2013 at 5:11 am

    #1624541

  • RE: User (db_datareader) can't see tables in MS; can SELECT data!

    Roy gave the answer. This is expected behaviour if the login is not granted view definition

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    June 17, 2013 at 4:04 am

    #1624516

  • RE: Failover Clustering and AlwaysOn Availability Groups

    Many thanks for your comment - I had misinterpreted the clustering as being the same. Now that makes sense.

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    June 11, 2013 at 10:04 am

    #1623043

  • RE: Failover Clustering and AlwaysOn Availability Groups

    Thank you for your re-direction to another resource (much like BOL). I was just after a quick opinion as they seemed to contradict themselves, but nevertheless.

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    June 11, 2013 at 9:00 am

    #1622995

  • RE: Grant Control On Schema verses granting individual permissions on schema?

    BOL -

    Object owners can grant permissions on the objects they own. Principals with CONTROL permission on a securable can grant permission on that securable.

    Grantees of CONTROL permission on a...

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    June 10, 2013 at 9:58 am

    #1622510

  • RE: Querying sys.dm_db_partition_stats instead of sys.sp_spaceused

    How about using SP_MSFORACHTABLE 'EXEC SP_SPACEUSED [?]' and putting into a temp table/variable and running a select on that with a REPLACE on the size columns

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    June 7, 2013 at 9:14 am

    #1622108

  • RE: Profiler shows long duration for sp but actually it is not

    The version that you are running may well have a different query plan. You may have an issue with parameter sniffing.

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    June 7, 2013 at 7:10 am

    #1622053

  • RE: Database mail sending fails with SP_Send_DBmail.

    Check the account that the SQL Agent is running under and check that it has permissions to the server that you are trying to query.

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    June 4, 2013 at 2:39 am

    #1620826

  • RE: Process For Data Migration

    I may suggest views and leave the base data alone. This would cut down on project time and would only need to update the references in the Sprocs, functions, etc.

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    June 3, 2013 at 8:15 am

    #1620571

  • RE: Need to be alerted to disallowed email addresses being entered - Admin cleaning up after App programmers! :-)

    Could you not create a DML trigger(s) on the table to stop any inputs that you don't require? There would be an overhead but you would need to weigh...

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    June 3, 2013 at 5:47 am

    #1620479

  • RE: How to rollback an insert query on sql server ? , please suggest bit high priority .. thanks in advance

    AS long as your db has not got any other activity on it that is required then the restore is fine. If not and other activity since or during is...

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    June 3, 2013 at 5:39 am

    #1620474

  • RE: error in Micorsoft 70-432 book

    PearlJammer1 (5/16/2013)

    I am doing some practice exercises from Microsofts training kit for 70-432 Implementation and Maintenance 2008(written by Mike Hotek) and am running the following code from page 148...

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    May 16, 2013 at 3:43 pm

    #1616015

  • RE: Connection Manager Properties

    You should be able to use GETDATE()-1 of you are not worried about the time of day. If that does not work look at ...

    in SQL - select CONVERT(DATETIME, DATEDIFF(dd,...

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    May 16, 2013 at 9:10 am

    #1615857

  • RE: Management DataWarehouse

    If you have plenty of disk space. It grows quite quickly.

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    May 15, 2013 at 5:43 am

    #1615362

  • RE: Linked Servers - Link drops out intermittently..Grrrr

    thanks for all your suggestions

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

    May 14, 2013 at 1:06 pm

    #1615165

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