Viewing 13 posts - 46 through 59 (of 59 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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
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...
_________________
"Look, those sheep have been shorn."
data analyst replies, "On the sides that we can see.."
September 19, 2003 at 9:44 pm
Viewing 13 posts - 46 through 59 (of 59 total)