Viewing 15 posts - 7,756 through 7,770 (of 59,072 total)
Yes, a Deep Dive thread!
Do you can also comment of PAD_INDEX settings in this all POC discussion? Currently in either fill factor settings your script is setting PAD_INDEX=OFF .
And...
February 10, 2020 at 1:44 pm
I'm thinking that it should be the other way around... an SQL Server Agent job should be calling the PowerShell.
February 9, 2020 at 8:46 pm
p.s. Remember that the COPY command does NOT require you to provide a file name for the target. You only need to provide it with a directory name and it...
February 7, 2020 at 8:04 pm
With the understanding that I kept it super simple for understanding and haven't parameterized some of the things that could/should be, here's how to pull the full path name for...
February 7, 2020 at 7:58 pm
I was trying to copy the data from one column to another and then add X in front of it
Thanks a lot 🙂
I managed to do it with your...
February 7, 2020 at 7:11 pm
Yes, the OP should be doing that but you also presumed that the OP knows how to convert the data to a normalized form. In order for the OP to...
February 7, 2020 at 4:31 pm
Ah... finally found this post again. Like I said on my last, is there any chance at of of you attaching the first 10 or so line of one of...
February 7, 2020 at 6:45 am
>>
SELECT rm_id FROM Foobar
EXCEPT
SELECT rm_id FROM Vague_Relationships;
Since I DID provide the DDL and a substantial amount of readily-consumable data for anyone (including you) to test with, you should get...
February 7, 2020 at 5:54 am
Here's some test data... You'll need to build the fnTally function that I have a link for in my signature line below unless you already have one of your own.
February 6, 2020 at 5:25 am
You BCP format file says that the delimiter for the end of the 1st field should start with a pipe and end with a quote. It doesn't for the 2nd...
February 6, 2020 at 12:39 am
Ha it's the exact same query.
I left out "TYPE" because it was guaranteed to be integer digits and "TYPE" makes things a bit slower over the long haul but,...
February 5, 2020 at 7:39 pm
To the best of my knowledge, no such scripts exist.
February 5, 2020 at 2:11 pm
Check to see if the connections being made are using M.A.R.S (Multiple Active Result Sets). Connections are supposed to default to this being off but several of us have found...
February 5, 2020 at 2:09 pm
Please help us help you... in the future, please post readily consumable data. Please Read'n'Heed the article at the first link for how to help us help you more quickly...
February 5, 2020 at 2:04 pm
You should add the money data type to this - it shows that ISNUMERIC recognizes money formats and will convert those correctly.
I did. The 3rd value has a...
February 4, 2020 at 11:47 pm
Viewing 15 posts - 7,756 through 7,770 (of 59,072 total)