Forum Replies Created

Viewing 15 posts - 751 through 765 (of 921 total)

  • RE: NOT IN clause

    The NOTs are tying you up. Try using OR instead of AND. You need the row if either (or both) predicate is true, but not if they're both...



    --Jonathan

    October 8, 2003 at 10:32 am

    #477597

  • RE: grouping data 

    

    SELECT MIN(Id), Name

    FROM TheTable

    GROUP BY Name

    --Jonathan

    Edited by - jonathan on 10/08/2003 10:03:09 AM



    --Jonathan

    October 8, 2003 at 10:03 am

    #477584

  • RE: like keyword pattern matching on postcodes

    You cannot do this with just a simple LIKE, as that does a character by character comparison. If the codes never contain data after the numbers, perhaps something like...



    --Jonathan

    October 8, 2003 at 8:57 am

    #477567

  • RE: will sql server 7 run on windows xp?

    quote:

    will sql server 7 run on windows xp? is it compatible? if not, what OS would sql server 7 be compatible?



    --Jonathan

    October 8, 2003 at 8:28 am

    #477557

  • RE: To delete temp tables or not to?

    quote:

    So when a user opens the application in the morning and closes it at the end of workday, he/she uses the same...



    --Jonathan

    October 8, 2003 at 8:03 am

    #477551

  • RE: Increasing Disk Space

    quote:

    We currently have a SQL 2000 database server running various databases with a capacity of 30gb. It is anticipated that we need...



    --Jonathan

    October 8, 2003 at 7:37 am

    #477543

  • RE: Filegroup Backups

    No, as long as you've got the complete sequence of tran log backups covering the filegroup backups, you do not need to start with a full database backup.

    E.g., if you...



    --Jonathan

    October 8, 2003 at 7:22 am

    #477539

  • RE: MSDE backup goal: minimal space/time

    quote:

    The MSDE instances will not have connection to the home office so to distribute data I'll need to mail a cd or...



    --Jonathan

    October 8, 2003 at 7:13 am

    #477535

  • RE: Move table to different filegroup

    quote:

    Time wise...I'm referring to both. This system is 24x7 and downtime needs to be held to a absolute minimum. As...



    --Jonathan

    October 7, 2003 at 10:42 am

    #477430

  • RE: Calculate max number of bytes for a row

    quote:

    Thanks, guarddata and Johnathan. I ran both of your scripts against my table, and they both returned 7903 for the row size....



    --Jonathan

    October 7, 2003 at 10:08 am

    #477423

  • RE: Calculate max number of bytes for a row

    quote:

    Thanks Jonathan - I sometimes forget about the Information_Schema information ...but don't forget to GROUP BY Table_Name

    Guarddata-



    --Jonathan

    October 7, 2003 at 9:28 am

    #477413

  • RE: Calculate max number of bytes for a row 

    

    SELECT Table_Name, SUM(COL_LENGTH(Table_Name, Column_Name))

    FROM Information_Schema.Columns

    WHERE Table_Name = @TableName

    --Jonathan



    --Jonathan

    October 7, 2003 at 8:41 am

    #477398

  • RE: Move table to different filegroup

    quote:

    Is there no other way?? I've got 170 tables and 108 indexes to move. Creating a dummy index and then...



    --Jonathan

    October 6, 2003 at 3:26 pm

    #477274

  • RE: Move table to different filegroup

    quote:

    What if there is no clustered index on the table?? Is there any other way to accomplish this?



    --Jonathan

    October 6, 2003 at 2:07 pm

    #477264

  • RE: Dynamically Create a #table from existing Table

    quote:

    Thanks!! Is there a way to create the table without the data?



    --Jonathan

    October 6, 2003 at 12:30 pm

    #477251

    • Viewing 15 posts - 751 through 765 (of 921 total)