Viewing 15 posts - 33,376 through 33,390 (of 59,102 total)
amit_adarsh (7/4/2011)
How to change the view definition ?
I have a table with all columns having not null values when I create a view on this my all columns...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2011 at 8:09 am
bhargava.sumansiram (7/4/2011)
here the tables
In table t1
columns : sys_id (char)= abc , abc
product_code (char)=0.000 , 0.000
...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 4, 2011 at 8:06 am
Lynn Pettis (7/3/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2011 at 4:48 pm
Thanks for the feedback.
You did perfect except for one thing... it's a "Pass-Through View"... there is absolutely no need to index the view because any query you use...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2011 at 4:46 pm
bitbucket-25253 (7/3/2011)
Jeff Moden
None of these restrictions or limitations are new to us old farts. The only real difference that I can see between the Cloud and an old IBM Mainframe...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2011 at 4:39 pm
BWAA-HAAA!!! Ok, Craig... you started this. 😛 What are the answers to the two questions above?
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2011 at 4:29 pm
PaulB-TheOneAndOnly (7/3/2011)
Onwership of the data does not equates with ability to manipulate the data; morevoer,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2011 at 4:27 pm
You posted an SQL Server 2000 problem on an SQL Server 2008 forum and that's part of the reason you're not getting much help. Also, if it were a...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 3, 2011 at 8:49 am
Unfortunately, I won't be at the Summit this year. None of my abstracts were accepted as "primaries" and, since I pay my own way, I can't afford to go...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 2, 2011 at 11:36 pm
as2higpark (7/2/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 2, 2011 at 10:49 pm
Martin Grape (7/2/2011)
Takes under a second for 1 millon rows and returns gaps size sorted 😉
Change tables and fields surrounded by...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 2, 2011 at 10:35 pm
ruby.malik (7/2/2011)
It is SQL
It is Oracle SQL, though. SQL Server has no NVL function nor a SYSDATE function.
It would also be helpful if we knew what you thought needed...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 2, 2011 at 10:10 pm
If it were Cross-Server calls, then I'd be might concerned. 🙂 But, for Cross-Database calls, there's no concern about performance issues.
First, you posted a query for a Cross Database...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 2, 2011 at 9:22 pm
None of these restrictions or limitations are new to us old farts. 😀 The only real difference that I can see between the Cloud and an old IBM Mainframe...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 2, 2011 at 8:18 pm
YSLGuru (7/1/2011)
Jeff Moden (7/1/2011)
Craig Farrell (6/30/2011)
Jeff Moden (6/30/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 2, 2011 at 4:40 pm
Viewing 15 posts - 33,376 through 33,390 (of 59,102 total)