Forum Replies Created

Viewing 15 posts - 331 through 345 (of 360 total)

  • RE: Kindly help me in this simple query

    If you add more columns you need to expand your group by clause as well

    select 1,2,3,4,5, max(6)

    from table

    group by 1,2,3,4,5

  • RE: IIS feature not known on Windows 2008 x64

    It's been a while since I installed, but isnt' that just a "warning"?

    If you don't need it, skip past it. If you don't know if you need it,...

  • RE: T-SQL sql server 2005

    I think the proposed solution will work.

    You're fortunate that a good SQL Scripter was reading the "backups" forum, because that might not always be the case.

    You'd have had a more...

  • RE: Copying database backup to another server

    Robocopy is fine and isnt' the issue.

    The earlier posters that hinted about compression is more likely it.

    If you're going to need to do this frequently, you might consider log shipping...

  • RE: Tsql question

    That's a tall order, but I can help you.

    read up on Create Trigger

    http://msdn.microsoft.com/en-us/library/ms189799(SQL.90).aspx

    and using the inserted and deleted tables

    http://msdn.microsoft.com/en-us/library/ms191300.aspx

    so once you know how to create a...

  • RE: SQL Server 2005 Job For Database Schema Comparison

    If you're talking about schema and not data, and want something cheap and easy I have something for you:

    try running a checksum_agg(binary_checksum(*)) from the sysobjects, sysusers, sysprotects, and sysmembers files.

    If...

  • RE: Tsql question

    What you need is a trigger that reorders the case_seq after an insert or update of case_cred.

    This will solve your problem.

    Good luck!

  • RE: Model database: default user rights and files

    1. You are correct. If you grant people into model, they will have access in model as well as being granted into any newly created db. ...

  • RE: Tsql question

    Clarifying:

    If you insert them out of alphabetical order, you want the sequence number to also change?

    ~Craig

  • RE: Log file size growth

    2. every time i set the file growth to be restricted for both db and log files.

    But after every restore it is being changed to unrestricted . why it is...

  • RE: Moving Large Table to Different File Group

    I'm not 100% sure, but I don't think that matters.

    The error I was referring to happens when you drop the PK to which the other table's FK's are pointing.

    You end...

  • RE: Moving Large Table to Different File Group

    Somebody mentioned the CREATE INDEX WITH DROP EXISTING, and I remember trying that and the answer is yes... and in EE you can do it online... it's pretty sweet... except...

  • RE: DTS on SQL2005 cluster

    I have several DTS packages running on the same sort of cluster environment (2k3 and sql 2k5) with no problems needing to specify the hostname instead of the virtual server...

  • RE: Analyzing indexes

    Yes, you are correct.

    CONTROL and VIEW DATABASE STATE are all you need for sys.dm_db_index_physical_stats run (if you're not wildcarding the first argument with NULL)

    ~Craig

  • RE: Analyzing indexes

    select * from sys.dm_db_index_physical_stats(db_id(),null,null,null,'detailed')

    ^can get your free space and fragmentation percentage among other things.

    select object_name(p.object_id) as Table_Name

    ,ISNULL(name, 'THIS IS A TABLE') as 'Index name'

    ,CAST(used_pages as decimal(12,2))/128 as 'Used Size...

Viewing 15 posts - 331 through 345 (of 360 total)