Viewing 15 posts - 20,791 through 20,805 (of 26,490 total)
Allister Reid (5/26/2009)
I've tried solving this with quirky update method, but having some difficulties!
Can't figure out how to add index to table variable? create index throws an error,...
May 26, 2009 at 10:59 am
When creating a partitioned view in SQL Server 2000, you also need to place a constraint on each table that ensures a record belongs to only one table, for example...
May 26, 2009 at 10:55 am
middletree (5/26/2009)
If I am reading you correctly, this should do what I need:USE CHEMPAXDW
GO
DBCC SHRINKFILE('CHEMPAXDW_Log', 10000)
BACKUP LOG WITH TRUNCATE_ONLY
DBCC SHRINKFILE('CHEMPAXDW_Log', 10000)
GO
Not quite.
BACKUP LOG [CHEMPAXDW] WITH TRUNCATE_ONLY
BACKUP DATABASE [CHEMPAXDW]
DBCC SHRINKFILE('CHEMPAXDW_Log',...
May 26, 2009 at 10:50 am
george sibbald (5/26/2009)
middletree (5/26/2009)
Wow. That could be a problem. The whole issue here is that there is no disk space. I don't have a place to back it up to.
then...
May 26, 2009 at 10:35 am
Noticed you are using SQL Server 2000. Any chance of upgrading in the near future? Partitioned tables in SQL Server 2005/2008 would greatly simplify your problem, IMHO.
May 26, 2009 at 10:30 am
Given the follwoing table:
create table dbo.MyTable (
DataCol1 int,
DataCol2 datetime,
DataCol3 varchar(25)
);
The new table would be like this:
create table dbo.MyNewTable...
May 26, 2009 at 10:28 am
middletree (5/26/2009)
I know this sounds weird, but I have...
May 26, 2009 at 10:23 am
Looks to me like the IDENTITY column should be a SID. It should have NO RELATION to the data being inserted other than providing a unique ID for each...
May 26, 2009 at 10:19 am
We are approaching the next big Party Time for The Thread. I suspect we'll hit 5,000 posts early in June with a possibility of it occuring by May 31st.
May 26, 2009 at 10:14 am
middletree (5/26/2009)
Helpful article, Lynn, but reading it makes me think we need to stay in Full Backup mode.
If you need point in time recovery, then yes you do.
Now that you...
May 26, 2009 at 10:11 am
Bob Hovious (5/26/2009)
They need a new how-to book: SQL for Window-Washers.I keep telling you Lynn, just don't look at his stuff and you will enjoy much more serenity.
😛
It's...
May 26, 2009 at 9:50 am
Damus (5/26/2009)
- real foreach loops through table rows.
Why use RBAR when set based solutions work much better and efficiently?
May 26, 2009 at 9:46 am
middletree (5/26/2009)
May 26, 2009 at 9:24 am
Damus (5/26/2009)
I withdraw all comments I previously posted on this discussion.I appologize to anyone who was offended. Did not mean anything wrong.
Peace (white flag)
I wasn't offended. I am...
May 26, 2009 at 9:19 am
Damus (5/25/2009)
May 26, 2009 at 8:16 am
Viewing 15 posts - 20,791 through 20,805 (of 26,490 total)