Forum Replies Created

Viewing 15 posts - 2,566 through 2,580 (of 7,164 total)

  • RE: New PAGING Funtion comparison with TOP

    e4d4 (1/2/2013)

    opc.three (1/2/2013)

    A slight tweak to your second query will show you how similar OFFSET and TOP can be:

    USE AdventureWorks2012

    SELECT TOP 100

    [TransactionID]

    ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 2, 2013 at 8:40 am

    #1572908

  • RE: DBCC_CheckDB Error in Index

    mvargas109 (1/2/2013)

    Executed as user: LAVOISIER\SQLAGENTACCOUNT. ...600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved.

    Started: 2:00:00 PM Progress: 2012-12-30 14:00:00.68 ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 2, 2013 at 7:58 am

    #1572890

  • RE: New PAGING Funtion comparison with TOP

    A slight tweak to your second query will show you how similar OFFSET and TOP can be:

    USE AdventureWorks2012

    SELECT TOP 100

    [TransactionID]

    ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 2, 2013 at 7:43 am

    #1572880

  • RE: How can i apply Deny Permission regarding sys.database and sys.tables etc to users ?

    By default all users are a member of the Fixed Server Role public, and this cannot be changed. Also by default, all members public can see all databases on the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 2, 2013 at 7:39 am

    #1572878

  • RE: Query for delete records between date range?

    Bhuvnesh (1/1/2013)

    opc.three (1/1/2013)

    With the query written this way I can highlight the SELECT statement in the USING clause to see what would be deleted without changing the query or carrying...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 2, 2013 at 7:12 am

    #1572869

  • RE: Grant create proc permission to a user-defined role

    n.heyen (1/1/2013)

    So the ALTER AUTHORIZATION statement made the [Developers] the owners of the schema?

    Exactly.

    Then I don't really need to add the rest of the GRANT statements since they are now...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 1, 2013 at 4:36 pm

    #1572716

  • RE: Grant create proc permission to a user-defined role

    This statement made the Developers role the owner of the Test schema. In being the owner, any grants you attempted to do that overlapped the permissions afforded by schema ownership...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 1, 2013 at 2:28 pm

    #1572712

  • RE: Upgrading to 2012?

    meridius10 (1/1/2013)

    Some of the databases I used were constructed by firms using SQL Server 2005 as a back end, so I guess it would be a major decision for them...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 1, 2013 at 2:11 pm

    #1572711

  • RE: Getting last ID in inserted trigger, howto ?

    What I provided is a set-based solution and it won't get much faster than that. If you want to store the current server name in the myIDnumber you could try...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 1, 2013 at 8:08 am

    #1572692

  • RE: Remove duplicate records?

    I think you have the DDL you posted mixed up with what you are after. The FK references BC_Display. Can you please post the table definition for both BC_ShiftSummary and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 1, 2013 at 7:29 am

    #1572685

  • RE: 2013 Goals

    1. Learn Extended Events well enough to where I never need to use Profiler/Trace again. That is, as long as I am working on a SQL Server 2012 instance.

    2. Learn...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 1, 2013 at 7:07 am

    #1572683

  • RE: How to do data quality ( name, address, account, data , matching/reconciliation) using SQL server 2008

    I have had good luck with MelissaData and they provide solutions for most of the areas you listed. They provide custom components as well so you can access their tools...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 1, 2013 at 6:52 am

    #1572681

  • RE: Birthdays in next 7 days

    Lynn Pettis (1/1/2013)

    opc.three (1/1/2013)

    Note: thread is 2+ years old :exclamation:

    Was noted, just responding to the alternate way the most recent responder posted. Plus, that is the beauty of this...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 1, 2013 at 5:36 am

    #1572674

  • RE: Query for delete records between date range?

    A DELETE-JOIN will work well. One other option I thought I would share. After working with it more and more I find the MERGE syntax to be quite intuitive and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 1, 2013 at 5:24 am

    #1572672

  • RE: Birthdays in next 7 days

    Note: thread is 2+ years old :exclamation:

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 1, 2013 at 5:04 am

    #1572668

Viewing 15 posts - 2,566 through 2,580 (of 7,164 total)