Viewing 15 posts - 61 through 75 (of 824 total)
Just for good measure, I'll include the view creation statement:
create view dbo.iv_SystemTransactionCardFund
with schemabinding
as
select
SystemTransactionID = st.ID,
c.CardNumber,
...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 19, 2009 at 4:00 pm
I've checked the stats and they all seemed to be up to date (we have auto create and update stats on) But just to be sure, I forced an...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 19, 2009 at 2:52 pm
Here's the estimated execution plan for the view (sans index of course...)
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
June 19, 2009 at 1:04 pm
It kind of reminds me of several systems I've looked at that try to protect their "IP" by naming tables and columns like tbl1.col12 and not using any declarative integrity....
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 10, 2009 at 2:43 pm
Over the years I have evaluated many software systems for purchase and I have yet to recommend one that used encrypted procs. I assume that if they encrypt their...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 10, 2009 at 7:34 am
Encrypting stored procedures is almost as annoying as it is pointless.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 9, 2009 at 9:42 pm
steve dassin (4/3/2009)
DCPeterson (4/3/2009)
Chris Date's incoherency principle is in full force...
Now that's funny! 🙂 The sql community has ignored someone whose spent a lifetime trying to explain why there's nothing...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 4, 2009 at 12:03 pm
Chris Date's incoherency principle is in full force...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 3, 2009 at 11:49 am
If you like cursors so much, why not use ORACLE instead, it works well with cursors. MS SQL Server was developed to work well using sets, and it works...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
April 3, 2009 at 8:51 am
I can't be the only one who's seen this problem can I?
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 10, 2009 at 1:49 pm
I'm sure this is more work than you want, but you could create staging tables for those tables (hopefully not the majority of them) and load into the staging tables...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 9, 2009 at 3:45 pm
Not to my knowledge...
Just curious why you can't do the explicit conversion using SQL? There may be another way to skin this cat...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 9, 2009 at 3:19 pm
Use the round function to explicitly control this behavior.
declare @Num decimal(6,3)
set @Num = 3.289
select round(@Num, 2, 1)
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
March 9, 2009 at 2:57 pm
Nice article Andy, I never really understood what the data viewers were. I sure wish I'd had this information a year ago...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 11, 2009 at 8:52 am
This is just one reason why change control is SO important. If you have a method of testing and documenting all changes made in your enviornment then it becomes...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
December 17, 2008 at 12:32 pm
Viewing 15 posts - 61 through 75 (of 824 total)