Viewing 15 posts - 331 through 345 (of 470 total)
It actually is possible to change a scalar function to a inline table valued function in some cases. I've done it before to improve performance and it requires not...
May 25, 2011 at 2:55 pm
Ninja's_RGR'us (5/25/2011)
My issue with it is that if you kill periodically then possibly DTA will auto-reconnect.
Another issue is that this could leave hypothetical indexes in the database. I'm not...
May 25, 2011 at 2:38 pm
You don't need to use a view to see data that you're not currently trying to modify. You can just select from the table:
create table product (
id int identity(1,1)...
May 25, 2011 at 2:25 pm
sknox (5/25/2011)
May 25, 2011 at 8:51 am
PhilDaniels (5/24/2011)
May 24, 2011 at 1:53 pm
Personally, I would love to be making enough money where an extra couple hundred dollars a month doesn't mean anything. I do agree that 2% is more of a...
May 23, 2011 at 1:57 pm
I don't think the first step is to threaten to leave. That can very easily go poorly and burn bridges if it's not done right. And sometimes even...
May 23, 2011 at 11:32 am
My favorite was when I was changing positions right around review time. I jokingly told my manager that she should give me the biggest raise possible since it wouldn't...
May 23, 2011 at 7:15 am
Take a look at the link. It's a list of the different editions and a comparison of them. For the most part a database coded for one edition...
May 20, 2011 at 2:54 pm
In my last position we had a number of bugs due to all sorts of reasons. Scope creep (more like scope sprint). Poorly defined requirements. Inexperienced off-shore...
May 20, 2011 at 11:35 am
Part of this is going to be balancing the risk between turning off functionality that you're not familiar with and how much damage can happen if you don't. There...
May 18, 2011 at 10:59 am
roger.plowman (5/17/2011)
Think about it. Would *you* want somebody who enjoyed high-stakes risk taking being a DBA? Really? (laughing)
Depends. I take risks all the time, just not with the data....
May 17, 2011 at 8:45 am
Christian Buettner-167247 (5/13/2011)
Text Data is stored on data pages
is "it depends".
Either that Text part of the question should be removed completely, or the...
May 13, 2011 at 9:23 am
Hugo Kornelis (5/13/2011)
Again: WHAAT???I don't have the time right now to read the entire discussion....
If you don't have time to read the entire discussion please don't go on a rant...
May 13, 2011 at 8:56 am
I can't say I'm surprised I got this one wrong. I kept going back and forth between LOB data including the row overflow pages (which it technically doesn't) and...
May 13, 2011 at 6:47 am
Viewing 15 posts - 331 through 345 (of 470 total)