Viewing 15 posts - 1 through 15 (of 33 total)
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...
November 17, 2009 at 11:51 pm
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...
November 7, 2009 at 8:00 am
Jeffrey Williams-493691 (9/21/2009)
September 23, 2009 at 6:25 pm
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...
April 18, 2009 at 3:40 am
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...
January 8, 2009 at 3:03 am
If you were using a SELECT statement as a data source, you would have to re-build and re-deploy your SSIS, which is a bit of a pain
Thanks for the explaination!...
December 28, 2008 at 6:38 pm
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...
December 28, 2008 at 4:47 am
Grant Fritchey (12/22/2008)
Take the time & trouble to create the databases, keep them small and then copy and use attach scripts to put them onto the server.
Sorry, I don't know...
December 22, 2008 at 6:46 pm
Thayal Muhunthan (8/21/2008)
Maximum we have 1500 users, might use 2/3 applications connecting to different DBs on the same SQL server.
As soon as there is more than 1 app then...
August 22, 2008 at 8:08 am
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).
August 14, 2008 at 4:32 pm
GilaMonster (5/13/2008)
Perhaps I should have said, policy is for servers to use SAN storage for everything except the C drive.
Sorry it wasn't clear enough that I was just trying to...
May 13, 2008 at 7:47 pm
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...
January 26, 2006 at 12:07 pm
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,...
January 26, 2006 at 11:43 am
In case anyone is interested, the solution turned out to be:
declare
@datefirst int
select
@datefirst = @@datefirst
set
...
January 23, 2006 at 1:05 pm
Thanks, using:
set
datefirst 4
update dim_date set load_week = datepart(week
January 23, 2006 at 12:41 pm
Viewing 15 posts - 1 through 15 (of 33 total)