Viewing 15 posts - 6,886 through 6,900 (of 7,187 total)
Chris
Just to add to what Wesley said:
If you can afford the disk space, a 10GB log is not going to impair performance. If you can't, then change to simple or...
August 9, 2006 at 3:45 am
Norman
I don't really agree with what Andrés suggests. Basically what he's saying is that you should run the first script to free space and shrink the log, then after any...
August 9, 2006 at 3:11 am
Harsh
Try the script below (not tested). Somebody else may be able to come up with something that doesn't involve a temp table...
John
CREATE TABLE #Table (TableID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, Event VARCHAR(50), MyTimestamp datetime)
INSERT INTO August 9, 2006 at 2:16 am
Joseph
More information needed, please. What type of replication are you using, and in what topology? What database are you trying to restore (publication, disribution, subscription)? Are you restoring from a...
August 9, 2006 at 1:38 am
Glenn
Not the version, the edition. You can get this by right-clicking on the server name in Enterprise Manager and choosing Properties. There are also functions in T-SQL you can use. ...
August 8, 2006 at 9:50 am
John
For tables with a clustered index, drop the clustered index and recreate it on the new filegroup. For tables without a clustered index, create one on the new filegroup. Then...
August 8, 2006 at 9:42 am
Have a look at SET DATEFIRST in Books Online. Then you can use CASE and the DATEPART function to subtract the correct number of days from the date.
John
August 8, 2006 at 9:36 am
Glenn
Also, you don't say whether you're using SQL Server 2000 Standard or Enterprise Edition. If it's Standard, you're stuck with 2GB whatever you do.
John
August 8, 2006 at 9:31 am
To add a column to your table:
ALTER TABLE MyTable ADD Cash_WTD_Min INT
To populate the column:
UPDATE MyTable SET Cash_WTD_Min = (SELECT MIN(Cash_WTD) FROM MyTable)
You would need a trigger to keep all of this current. However, I wouldn't recommend that...
August 8, 2006 at 9:28 am
Fredrik
Something like the script below will generate some SQL that you can inspect and then run against your database.
John
SET nocount ON
SELECT 'DROP TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME + ']'
FROM information_schema.tables
WHERE TABLE_SCHEMA =
August 8, 2006 at 9:16 am
Martin
That's strange. I think you're right - the next thing you need to look at is the regional settings of the computer on which you're running the import. I think...
August 8, 2006 at 4:14 am
Martin
Did you try changing the default language of the login? Having reread your original post more carefully, I think that this is the only thing it could be. The data...
August 8, 2006 at 3:34 am
You don't give many details. Have a read about merge replication and transactional replication with updating subscriptions and see if either of those meets your needs.
John
August 8, 2006 at 3:03 am
The dates you are importing are in the UK format. So, in order for SQL Server to interpret them as UK-format dates, I would have thought that the user who...
August 8, 2006 at 2:47 am
Rudy
PAE/AWE won't have any effect if you have 4GB of RAM or less. Only the /3GB switch is required here.
I will also add that if Alex does decide to use...
August 8, 2006 at 2:36 am
Viewing 15 posts - 6,886 through 6,900 (of 7,187 total)