Viewing 15 posts - 2,836 through 2,850 (of 59,067 total)
If your "TVF" has the word BEGIN in it, that'll make a world of hurt no matter how you're using it. That would make it an mTVF (Multi-statement Table Valued...
September 1, 2022 at 2:05 am
I guess I don't understand why you need to do this. The role grants those privs. Why do you want/need to do it separately?
September 1, 2022 at 1:50 am
What I'd really like to see are companies that stop punishing people for not taking time off. I've had more vacation just vanish because I had more on the books...
September 1, 2022 at 1:32 am
Here's a sample table and the corresponding view, with one non-nullable datetime and one non-nullable int column that have placeholder values that return NULL when querying the table.
For now,...
September 1, 2022 at 1:25 am
I've done some things using the "RegEx" button (which is a serious misnomer of it's own) on Search'n'Replace in SSMS but nothing like this. I can see other uses for...
August 30, 2022 at 8:20 pm
You might want to use the Lead version of the splitter
I absolutely agree. In fact, my personal copy of DelimitedSplit8K has Eirikur's wonderful performance improvement in it (and has...
August 30, 2022 at 4:32 am
To add to Jo's and Scott's good suggestions, check on MAXDOP while you're at it If it's set to "0" (something can use ALL the CPU's at the same time),...
August 30, 2022 at 4:29 am
Just do a BULK INSERT to import the XML file as a BLOB and parse it with the normal XML tools.
August 30, 2022 at 12:44 am
You state, "A monster index will have to be rebuilt where it may not have been fragmented at all without compression." What is the basis for that...
August 30, 2022 at 12:40 am
Would like to post the data but I have a solution now. This will run once a quarter at night so it is not a huge hit on processing....
August 29, 2022 at 6:01 pm
I'd like to setup a test table to do the some testing on for all of this. With in mind...
Could you tell us what is meant by "This table only...
August 29, 2022 at 5:50 pm
You state, "A monster index will have to be rebuilt where it may not have been fragmented at all without compression." What is the basis for that claim?
Same as...
August 29, 2022 at 5:37 pm
Ok and what about Python? I heard somewhere that it can also be used as an alternative of SSIS tasks?
Yes it can... so can C#, Visual Basic, PowerShell, a...
August 29, 2022 at 5:05 am
It was not "obvious" that you were speaking of VARCHAR because they are NOT affected by row compression at all. Only CHAR is affected by row compression and you clearly...
August 29, 2022 at 5:01 am
When you read this, Scott, remember that I LOVE page compression...
You say the following but you need to qualify, especially to a person who might not know what compression is...
August 29, 2022 at 12:09 am
Viewing 15 posts - 2,836 through 2,850 (of 59,067 total)