Viewing 15 posts - 2,311 through 2,325 (of 22,214 total)
But could the same thing be done with a UDF?
I'd say no. Not the same way as stored procedures. An inline UDF (heck, even a multi-statement UDF) are treated...
October 30, 2019 at 12:29 pm
Maybe OP re-creating index, not rebuilding it? Last sentence ("i have application which drops indexes") kind of implies that?
Could be, but recreating an index after data changes requires pretty...
October 29, 2019 at 7:05 pm
To the person with the crystal ball, any prediction when SSIS projects will work properly in Visual Studio 2019?
BWA-HA-HA-HA-HA!!!!!
Oh, wait. You were serious?
October 29, 2019 at 4:54 pm
Stored procs are fine. Great way to exercise MORE control and avoid all the issues we've listed with joining and nesting views. I don't object to using stored procs. I...
October 29, 2019 at 3:03 pm
Also, which would be preferable for report sources -- UDF or stored proc?
Not a comparison I would make. They do different things and will have different uses. Stored procedures...
October 29, 2019 at 2:47 pm
Same issue on the differentials. If you run a restore and allow recovery, you can't apply a differential.
October 29, 2019 at 12:11 pm
On the reset, I mean re-restore. To do the log shipping, you can't have recovered the database. It has to be left in recovery. If you already recovered the database,...
October 29, 2019 at 12:10 pm
Some good info, let me add a couple of more wrinkles.
First, an inline UDF has a nickname, a parameterized view. It's way to set up a query, with parameters, to...
October 29, 2019 at 12:05 pm
It is an interesting question. I suppose if there were zero data changes, you probably could just restore the index in a piecemeal restore if it's on a different file...
October 29, 2019 at 11:58 am
As you've defined it, can you just capture the delta? No.
Instead, you have to look at additional processes or methods to arrive at this. For modern servers, I recommend looking...
October 29, 2019 at 11:45 am
If you're rebuilding all the indexes, stats are not a worry. However, since you're doing a bunch of partial updates, I'd be a bit more concerned that simply enabling indexes...
October 29, 2019 at 11:27 am
This is why we should comment our source code and version control checkins - so those who follow us can better understand why we did things...
October 28, 2019 at 3:51 pm
This is why we should comment our source code and version control checkins - so those who follow us can better understand why we did things the way we...
October 28, 2019 at 1:50 pm
erm…. I picked up on one word - "weekend"
so is there any possibility that it's a rebuild index with "Sort in tempdb" option enabled... we all know which jobs...
October 28, 2019 at 1:45 pm
Viewing 15 posts - 2,311 through 2,325 (of 22,214 total)