Forum Replies Created

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

  • RE: Rowcount of the biggest table

    Richard Fryar (12/19/2012)

    This should work in SQL Server 2000 (not tested though):

    select o.name, i.rows

    from sysindexes i

    join sysobjects o on i.id = o.id

    where i.indid in (0, 1)

    order by 2 desc

    I tried...

    December 19, 2012 at 11:07 am

    #1570225

  • RE: Rowcount of the biggest table

    MyDoggieJessie (12/19/2012)

    The fastest (and most accurate) is to query sys.indexes - example:

    SELECT

    c .row_count AS [RowCount]

    FROM

    sys. objects a

    JOIN

    sys. indexes...

    December 19, 2012 at 10:54 am

    #1570215

  • RE: Security question

    Is it possible to create a sql job which runs every 15 mins to check if any user is added to the db_datareader database role?

    November 5, 2012 at 9:48 am

    #1556131

  • RE: Security question

    anthony.green (11/5/2012)

    If you impliment the right security at the login level to prevent people adding people into the role then yes, but remember if a user has sysadmin rights they...

    November 5, 2012 at 9:03 am

    #1556101

  • RE: Access question

    opc.three (10/31/2012)

    sunny.tjk (10/31/2012)

    I can think of DENY SELECT but not sure how to implement it. I'd like to accomplish DENY SELECT to everyone except to the members of the approved...

    November 1, 2012 at 1:57 pm

    #1555181

  • RE: Access question

    opc.three (10/31/2012)

    sunny.tjk (10/31/2012)

    I can think of DENY SELECT but not sure how to implement it. I'd like to accomplish DENY SELECT to everyone except to the members of the approved...

    November 1, 2012 at 8:15 am

    #1555025

  • RE: Access question

    I can think of DENY SELECT but not sure how to implement it. I'd like to accomplish DENY SELECT to everyone except to the members of the approved group.

    October 31, 2012 at 1:26 pm

    #1554757

  • RE: Job History

    I'm not sure if it could be done for one particular job but you can check "SQL Server AGent Properties" and then going to HISTORY tab.

    October 31, 2012 at 11:05 am

    #1554714

  • RE: Backup size estimation

    Thanks Gail.

    October 31, 2012 at 11:01 am

    #1554711

  • RE: Remove Key lookup

    Thanks Gail.

    October 31, 2012 at 7:40 am

    #1554593

  • RE: Performance question

    Sean Lange (10/29/2012)

    sunny.tjk (10/29/2012)

    Would there be any slowness in performance if a query involves dateadd(day,datediff(day,1,GETDATE()),0) in the WHERE clause?

    There of course is some impact to performance but it is actually...

    October 30, 2012 at 7:38 am

    #1554161

  • RE: Size of an index

    GilaMonster (10/22/2012)

    No, it means the size of the columns you've chosen as key columns. If it meant the size of the index (which we're trying to calculate) it would be...

    October 22, 2012 at 1:47 pm

    #1551622

  • RE: Size of an index

    GilaMonster (10/22/2012)

    Yup.

    (Size of index key + size of clustered index key) * number of rows / 8196 = number of leaf level pages required. It's an under-estimate, but it'll be...

    October 22, 2012 at 9:33 am

    #1551459

  • RE: Index question

    GilaMonster (10/18/2012)

    Of course they are. Just as useful as on an int, date, decimal, numeric or any other data type that's legal for index key.

    Please read the links I posted.

    Got...

    October 18, 2012 at 7:38 am

    #1550484

  • RE: Index question

    Suresh B. (10/18/2012)

    sunny.tjk (10/18/2012)

    So, indexes can be applied only on columns with integer values?

    If it were so, SQL Server would not have allowed you to create index on char...

    October 18, 2012 at 6:55 am

    #1550438

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