Viewing 13 posts - 46 through 58 (of 58 total)
The data belongs to the data owners, not to the developers of some application. I would not allow any database that "only my application" can access. And SQL...
March 28, 2005 at 3:38 am
Our users (and they are the data owners) want to refresh the data when they want to refresh the data. SQL Server Agent scheduled jobs that include DTS packages...
March 3, 2005 at 1:04 pm
I agree with tijoj-- look at the MS-Query option first to determine whether it meets your need. It saves me a TON of time. Start with a blank...
March 3, 2005 at 11:07 am
Lots of data exists in the world outside real (that is, normalized and managed by a DBMS) databases. The big ETL (extract, transform, load) task is to load this messy...
December 21, 2004 at 12:57 pm
Clue: Anyone who begins by thinking "SQL Server doesn't have what Oracle has" is going to arrive at a solution that fails to make best use of SQL Server. Simply...
December 20, 2004 at 4:40 am
Whatever reporting tool you use, whether Access or Crystal Reports (shudder), let SQL Server do all the joining and qualifying (filtering) and use the reporting tool for formatting and display...
December 17, 2004 at 1:32 am
The data belongs to the data owners. The database design belongs to
the owners of the data resident in the database. The business
process logic implemented in the stored procedures belongs to...
February 11, 2004 at 7:50 am
What is the purpose of segregating data by month/year into separate databases? I can't think of a business situation for which that's a good solution. Years ago, I...
October 16, 2003 at 12:45 am
"...interesting maps for the DBA to ponder on heavy OLTP database schemas..." There is a lot of work here, but what is the point? I'm a DBA who...
October 16, 2003 at 12:27 am
When I have to be sure there will not be a performance issue, I do this
create table #notInTbl2 (id int)
insert into #notinTbl2 select ID from tbl1
delete from #notInTbl2 where id...
September 25, 2003 at 9:59 am
Interesting and useful DTS behavior, SQL Server 2000 (8.00.818 SP3). (As pointed out elsewhere, capture what DTS is doing using a SQL trace (Profiler tool) and make T-SQL...
September 24, 2003 at 9:04 am
Thank you, davidburrows. From all I have read, I thought this IIS and .Net framework should be included in Windows or downloadable (free) but I was not finding it because...
September 22, 2003 at 10:40 am
I was an Ingres expert. Then I was a **CA-OpenIngres** expert, employed by Computer Associates Professional Services to teach Ingres and to troubleshoot at client sites willing to pay...
September 19, 2003 at 9:44 pm
Viewing 13 posts - 46 through 58 (of 58 total)