Viewing 15 posts - 1 through 15 (of 27 total)
Hi Vicki,
I think you can potentially achieve what you need to do, without changing your result set, by getting familiar with the InScope function. I used it recently to stop...
March 11, 2009 at 3:43 am
Good work Adam. I spend a lot of my time authoring and maintaining Reporting Services reports, but my programming knowledge outside of SQL/T-SQL is VERY poor, and have therefore been...
March 5, 2009 at 2:31 am
With regards to the descriptive answers, I wonder if you could approach the problem slightly differently. Say for example a question (Q1) is "What constitutes a good response to a...
January 30, 2009 at 3:10 am
I don't like to call myself an "IT guy" because I am in denial about being a geek. That and I actually have no idea about how computers, printers, routers...
June 26, 2008 at 2:49 am
Hi again,
I have found that if I set the shared expiration schedule to run, say daily at 1am - or anything but ONCE - then it is fine. Not really...
November 16, 2007 at 2:52 am
Hmmm... how about another parameter which is hidden, which has a default value of "select count(*) from ..." so that it returns the total number of possible options.
Then you might...
September 26, 2007 at 10:04 am
I think the different results are possibly due to collation sequence differences between our servers.
Or at least, this guy seems to think so. Who am I to disagree?
September 21, 2007 at 2:44 am
It would be easier yes, but not always accurate. I've hit problems with both of these before - took ages to find the issue.
select
September 20, 2007 at 7:14 am
Aha! I like the EXCEPT operator very much in this case. I am stuck in SQL2000-land, and have not come across this before. I see there's an INTERSECT as well....
September 20, 2007 at 5:18 am
Hi Jennifer,
You might like to also try this:
select * from TableWithNewData n
where not exists (select 'x' from TableWithOldData o
where isnull(o.Column1,'AppropriateValueForDataType' = isnull(n.Column1,'AppropriateValueForDataType')
and isnull(o.Column2,'AppropriateValueForDataType') = isnull(n.Column2,'AppropriateValueForDataType')
...
and isnull(o.Column255,'AppropriateValueForDataType') = isnull(n.Column255,'AppropriateValueForDataType'))
That will give...
September 19, 2007 at 2:25 am
Thanks for this article Vincent, I think it sums up the role very well. As a datawarehouse developer/consultant, I am often asked to perform all of the tasks you mention....
September 17, 2007 at 2:27 am
Hi Stephanie,
I would suggest having columns "PaycodeA" and "PaycodeB" in your dimension table, and therefore storing both. This is because there isn't really a 'natural' key - particularly if you...
August 17, 2007 at 10:29 am
Great article. I just wanted to say that I have had some very large performance gains to query times when employing horizontal partitioning on biggish fact tables in a datawarehouse...
August 9, 2007 at 5:45 am
I'm not the smartest when it comes to the intricacies of SQL Server storage, but I *think* the consultant is right in saying that the 1020 doesn't matter because it...
August 3, 2007 at 2:12 am
Hmmm... seems you can't. It is not possible to alter the package that is running. Instead, you need to alter a package that is NOT running, via a script task,...
February 16, 2007 at 5:01 am
Viewing 15 posts - 1 through 15 (of 27 total)