Viewing 15 posts - 166 through 180 (of 411 total)
Thanks everyone. I prefer the indexed view option as that returns the best results I've seen yet, but it causes some issues for the developpers.
The nonclustered index Gail suggested...
December 16, 2008 at 6:30 pm
washingtonen (12/14/2008)
December 14, 2008 at 10:04 am
GilaMonster (12/14/2008)
timothyawiseman (12/13/2008)
December 14, 2008 at 9:57 am
washingtonen (12/13/2008)
SELECT
case when failed = 'N' then
(select * from dim_concept)
else
(select * from vw_dim_concept)
end
FROM
flagsta
and those the errors when i execute...
December 13, 2008 at 6:25 pm
Depending on exactly what you are trying to do you may want to look at one of two approaches:
You may wish to consider a table valued function instead of a...
December 13, 2008 at 4:44 pm
Michael Earl (12/11/2008)
December 13, 2008 at 3:47 pm
Steve Jones - Editor (12/13/2008)
For the first, if you had an index...
December 13, 2008 at 3:41 pm
Joseph M. Steinbrunner (12/5/2008)
December 8, 2008 at 11:24 am
Jeff Moden (12/6/2008)
December 6, 2008 at 10:25 pm
Jeff Moden (12/6/2008)
timothyawiseman (12/5/2008)
To slightly modify a quote from Larry Wall, "SQL is designed to give you several ways to do anything, so consider picking the most readable one."
I'm definitely...
December 6, 2008 at 2:38 pm
Steve Jones - Editor (12/1/2008)
I'm with Jack. #2 is easier to read, but I'd suspect that #1 works better.
While I know this is a matter of opinion, I found 1...
December 5, 2008 at 5:57 pm
G Bryant McClellan (12/1/2008)
Jeff Moden (12/1/2008)
December 5, 2008 at 5:50 pm
GilaMonster (12/2/2008)
The DBA job is broadening, for sure, but going away? I doubt it.
I completely agree with Gail. My job title is DBA, but I automated most of the...
December 3, 2008 at 11:54 pm
Douglas Osborne (12/3/2008)
Tim,Why use LIKE if you are not adding % - shouldn't you just say = instead then?
Doug
For flexibility, I wanted to be able to use a wildcard such...
December 3, 2008 at 1:08 pm
Douglas Osborne (12/3/2008)
This didn't work for me until I added a % at the end of the first dynamic SQL statement:
SELECT @sql = CASE
WHEN...
December 3, 2008 at 10:01 am
Viewing 15 posts - 166 through 180 (of 411 total)