What do you mean by 'trying access with' the hard drive? Are you using MS Access? Is this a database question or a general problem with just using...

Since all I have is a dev server I wish the logs would go away automatically. I understand the importance of production systems' logs but I have no need...

Jeffrey Williams-493691 (9/21/2009)

---

No, BackupExec and other utilites like that won't backup SQL Server database files that are open. SQL Server locks the files and will not allow them to...

Three options for not having to convert your FAT32 drive to NTFS and also not having to truncate the log file on the original to save space:

1. Detach and copy...

The most important thing to have when using a SAN is a good SAN administrator. The things are convoluted pieces of equipment with a lot of options and while...

Thanks for the explaination!...

I supposed this is a dumb newbie question but I have to ask: Why use a stored procedure for such a simple select? Wouldn't a view be better...

Sorry, I don't know...

As soon as there is more than 1 app then...

Sorry, I missed the 's' in my original post - yes, all the services are running as show in task manager (and in the services control panel app).

GilaMonster (5/13/2008)

---

Sorry it wasn't clear enough that I was just trying to...

A variant on this idea does work nicely.  However, it requires being bounced through a temp table:

create table #foo (id_key int identity(1,1), source_id_key int);

insert into #foo select distinct source_id_key from dbo.Stage_Source;

select source_id_key...

It makes sense but it also makes very uneven groupings.  Trying that on a test case put 4 sources into the first thread, three in the second, none in the third,...

In case anyone is interested, the solution turned out to be:

declare

@datefirst int

select

@datefirst = @@datefirst

set

...

Thanks, using:

set

datefirst 4

update dim_date set load_week = datepart(week