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...
-
RE: grouping data
SELECT MIN(Id), Name
FROM TheTable
GROUP BY Name--Jonathan
Edited by - jonathan on 10/08/2003 10:03:09 AM
-
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...
-
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? -
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... -
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... -
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...
-
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...
-
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... -
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.... -
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_NameGuarddata-
-
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
-
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... -
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?October 6, 2003 at 2:07 pm
-
RE: Dynamically Create a #table from existing Table
quote:
Thanks!! Is there a way to create the table without the data?
...but don't forget to GROUP BY Table_NameViewing 15 posts - 751 through 765 (of 921 total)