Viewing 15 posts - 91 through 105 (of 1,354 total)
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
March 1, 2019 at 6:52 am
February 25, 2019 at 6:48 am
Actually it's the other way around. DST saves daylight in the evening, and steals it from...
February 18, 2019 at 5:54 pm
Viewing 15 posts - 91 through 105 (of 1,354 total)