Viewing 15 posts - 511 through 525 (of 2,660 total)
What is the business case here for replication? HADR? Readable copies for reporting etc?
With replication, you can always start the subscriber from a backup, rather than doing a snapshot....
May 15, 2023 at 1:48 pm
you do need to have those 2 props to 1, and you also need a login setup if not mistaken.
and you need to ensure that the...
May 12, 2023 at 3:50 pm
you do it as part of the create table - or you specify every single field on your select.. into and on that you do a convert(decimal(19, 6), fieldx) as...
May 12, 2023 at 2:10 pm
issue you have is that your TotalAmount column is a decimal (18, 6) - the PIVOT sum then outputs this as decimal(38, 6) which takes 17 bytes each.
so 597 *...
May 12, 2023 at 12:15 pm
Jet is a 32 bit technology - won't work with newer versions of SQL (which are all 64 bit)
you need to use Microsoft ACE instead https://www.microsoft.com/pt-pt/download/details.aspx?id=50040
May 11, 2023 at 8:54 pm
May 11, 2023 at 2:21 pm
if not mistaken on this case the index spool is because your archive table is partitioned (on a column other than GSN_ID, most likely TNR_DATE) and SQL creates the spool...
May 10, 2023 at 8:28 am
how big is the table?
if only a few thousand rows then a script with insert statements would likely work fine as mentioned before.
but for anything with volumes BCP or powershell...
May 5, 2023 at 4:20 pm
Another option if you don't want to be moving data between your local and the prod server, creating temp tables, CTE's etc... would be to use SSIS and just...
May 1, 2023 at 4:13 pm
replacing the CR + LF on a text field IS losing data - maybe not important on your case, but it is still data.
In one of the migrations on my...
April 27, 2023 at 3:00 pm
Thank you for you input, that actually worked for me.
what worked? creating a valid CSV file or removing potentially valid data from your output? and if removing valid data...
April 27, 2023 at 1:35 pm
not as easy as that. the environment within a SQL job step is a number related to the number of the environment on that particular server.
trying to recreate the same...
April 26, 2023 at 8:37 pm
SSL error - encryption needs to be setup correctly or disabled on the client connection string
trust server certificate below may need to be ticked if this was a SSMS connection.
for...
April 26, 2023 at 10:00 am
assuming the recipient of the file is able to correctly process a CSV file you need to ensure that the SSIS flat file destination is set to Quote the fields...
April 25, 2023 at 9:37 pm
I would say that you have a trigger on that table that is removing seconds from the column.
and I also assume you are clearing that table in order to do...
April 24, 2023 at 8:06 pm
Viewing 15 posts - 511 through 525 (of 2,660 total)