Comments
Sort by recent activity
Script the tables out from both sides and check for differences. My guess would be the Primary Key - it won't be present in the table that you created via the export functionality. Where Compare can't find a common Primary Key, it can't compare, until you manually tell it what to use as a comparison key. / comments
Script the tables out from both sides and check for differences. My guess would be the Primary Key - it won't be present in the table that you created via the export functionality.Where Compare can...
Yes, that is essentially it. The 'max' value is 2GB, regardless of the data type. / comments
Yes, that is essentially it. The 'max' value is 2GB, regardless of the data type.
Don't forget that a varchar column uses 1 byte per character and nvarchar uses 2 bytes per character (not strictly accurate, but close enough). So, if you're moving 400 bytes of data from a varchar column to an nvarchar column, it will now take 800 bytes. The software is warning you of this, because if you have any data that is taking more than 50% of the capacity of a char(max) column, it will be doubled in size and therefore be too large for a nvarchar(max) column. You need to find the maximum length of your char(max) entries, before deciding to either ignore the warning or do something about the data. / comments
Don't forget that a varchar column uses 1 byte per character and nvarchar uses 2 bytes per character (not strictly accurate, but close enough). So, if you're moving 400 bytes of data from a varchar...
There is an old but still excellent article from Robyn Page, on various ways to manipulate data/time information - https://www.red-gate.com/simple-talk/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/ / comments
There is an old but still excellent article from Robyn Page, on various ways to manipulate data/time information - https://www.red-gate.com/simple-talk/sql/learn-sql-server/robyn-pages-sql-server-d...
Do you have more than one installation of Monitor? I had something similair some time ago. We have a four-node AG and Monitor is installed on all four - but three deactivated. If we lose the node that has the active installation I want to be able to switch another one on. We have a plan to move it to a new server that isn't part of the AG but can see it, but life keeps getting in the way of that. One time, when Monitor was upgraded on all four servers, they were all activated, which cased some fun. One Monitor running is barely noticable, but four all doing the same thing certainly made it's presence felt. / comments
Do you have more than one installation of Monitor? I had something similair some time ago. We have a four-node AG and Monitor is installed on all four - but three deactivated. If we lose the node t...
SQL Compare (as oppose to SQL Data Compare) - compares schemas and generates scripts for any modifications. It is available for a free trial period and worth a look. / comments
SQL Compare (as oppose to SQL Data Compare) - compares schemas and generates scripts for any modifications.It is available for a free trial period and worth a look.
Could we see the schema that you're creating data against, as well as the Data Generator project? I can use it to create several million rows of data in less time than that, so would be curious to see what the project looks like. / comments
Could we see the schema that you're creating data against, as well as the Data Generator project? I can use it to create several million rows of data in less time than that, so would be curious to ...
Outstanding. Congratulations to those that managed to organise this - I was wondering what would happen to the amazing wealth of data and presentations that SQLPass has. / comments
Outstanding. Congratulations to those that managed to organise this - I was wondering what would happen to the amazing wealth of data and presentations that SQLPass has.
I'll be there too. / comments
I'll be there too.
SQLPass was the organisation that gave me the confidence to actually join and contribute within a community and although I no longer feel that I need it quite as much, I do believe something of that ilk needs to be more obvious for those just starting within the SQL Server world. The scale of the annual conference was amazing and of exceptional quality but was a monster that required a lot of feeding and attention. It missed a meal and promptly died. The smaller scale meetings were probably more meaningful to the more regular enthusiasts amongst us and if something along the lines of SQL Saturday could continue I don't think the passing of SQL Pass would leave a huge gap in our community. Several people that I wanted to meet when I attended SQLPass now work with Redgate and most of the others have active sites and attend smaller conferences around the world. With the very fast evolution in video conferencing over the past year I believe it just needs ('just'!) somebody to act as a hub for these conferences and resources. As Redgate also owns SQL Server Central and absorbed Simple Talk, I believe this would be the ideal place to base a central 'hub'. Just in case you aren't busy enough.... / comments
SQLPass was the organisation that gave me the confidence to actually join and contribute within a community and although I no longer feel that I need it quite as much, I do believe something of tha...