Viewing 15 posts - 3,946 through 3,960 (of 59,067 total)
I used powershell to create a script that prepares the files for bulk insert. it ensures that the columns match with the destination table. works beautifully.
You mean a poweshell...
February 4, 2022 at 12:05 am
To wit... 10GB is only a physical limit. With the likes of Partitioned Views, you can get around that although that might be a good time to try and sell...
February 4, 2022 at 12:01 am
Please Suggest
February 3, 2022 at 11:57 pm
@jeremyu ,
I'm curious... what is the underlying datatype of the RCLDTE column and what does a good or bad date look like in that column?
Also, are you using the [Saturday]...
February 3, 2022 at 9:34 pm
Yes, and the history table should be a single table with columns that indicate the start and end times of a state of being of the data element being modeled....
February 3, 2022 at 8:46 pm
ROFLMAO!!!!! This is exactly why they hired me. They don't even currently have backups, let alone test them. All of their databases are managed solely by their hosting company....
February 3, 2022 at 8:34 pm
It's not how you're using it or the fact that supposedly nothing can get to it. Not all attacks are from the outside world and there's no guarantee that someone...
February 3, 2022 at 7:31 pm
Notifications should be working again. I caught this as I was heading out on holiday and filed the issue.
What I got back over the last few days (while gone),...
February 3, 2022 at 4:15 pm
Just a test here... did anyone get an email notification of this post?
February 3, 2022 at 2:54 pm
you also can't have extra columns on the destination table
With the understanding that I've not read all the posts in this thread, you actually can. Then you can do...
February 3, 2022 at 5:55 am
The first obvious question is why do you think a current receipt is a totally different kind of data element from a historical receipt?
I guess you've never heard of...
February 3, 2022 at 5:49 am
Thanks Jeff and Grant for responding. I now have two articles waiting for Steve's approval.
Don’t know if those will make the cut. Let’s see.
As the old saying goes, "The...
February 3, 2022 at 5:44 am
SQL Server does not all "FROM @FILENAME", only "FROM 'data_file_name'". Google the syntax of the command.
You'll need to use dynamic SQL if you want to feed in a...
February 3, 2022 at 5:43 am
There is no need to use the old DATETIME...
That's what so many people say but that's seriously wrong. Although DATETIME doesn't meet some of the ISO 8601 standards,...
February 3, 2022 at 2:57 am
Heh... it's why I complain... "A happy sailor is a bitchin' sailor". 😀
February 3, 2022 at 12:15 am
Viewing 15 posts - 3,946 through 3,960 (of 59,067 total)