Viewing 15 posts - 46 through 60 (of 1,311 total)
March 19, 2019 at 2:52 pm
For all of you advocating encryption, how do you stored SSNs? Fortunately I don't deal with data requiring this level of protection, but I'm curious how you do it.
March 19, 2019 at 1:30 pm
I like to practice "defensive" programming and so I want the system to fail if I accidentally hit "execute".
Just having CREATE prevents this accidentally replacing the original version...
March 14, 2019 at 2:11 pm
I'm assuming you're also only talking about the starting BEGIN and ending END around the whole procedure.
Yes. I certainly use the combination as part of portions of...
March 14, 2019 at 7:24 am
The begin/end optional (usually) syntax makes me crazy. I only use it when required, it just adds noise.
Agreed. However, same for the NO COUNT ON. I don't use...
March 14, 2019 at 6:58 am
Why do so many people think that "doing it right" is at odds with pragmatism? THAT's a major part of the problem!
Nobody said that. Sometimes there is...
March 13, 2019 at 2:21 pm
I definitely am with Jeff, too. My customer is willing to accept (in my opinion) quite a lot of debt as long as things run smoothly. We've been through...
March 13, 2019 at 7:30 am
All this very thought provoking. We've all experienced it, but now there's a name for it.
March 12, 2019 at 11:23 am
Gosh MS really has made this one fun. My version is 12.0.2000.8 and it gets only one. I just used another machine which has 12.0.4100.1 and it returns both...
March 8, 2019 at 2:24 pm
Weird. I tried this on a 2008R2 instance and a 2014 and in both cases when I choose modify in object explorer I get ONLY the first version not...
March 8, 2019 at 7:13 am
I'm really glad we do not have to do this any more - using schemas makes life so much easier
This approach to stored procedures has nothing to...
March 8, 2019 at 6:53 am
March 1, 2019 at 8:30 am
I put all my translation tables into the etl schema and kept the facts and dimensions in dbo.
Consider using a more elaborate schema for...
March 1, 2019 at 8:18 am
Viewing 15 posts - 46 through 60 (of 1,311 total)