Comments
Sort by recent activity
Yes you can - it's a setup that we have here. Not ideal but it works fine. / comments
Yes you can - it's a setup that we have here. Not ideal but it works fine.
Can I complete the survey a second time? I made the assumption that the holiday that we were about to book would take priority, but my amazing wife has just suggested that I go to the conference and we plan our holiday around that, instead! I need to change the options I chose, because I intend to be there. / comments
Can I complete the survey a second time? I made the assumption that the holiday that we were about to book would take priority, but my amazing wife has just suggested that I go to the conference an...
You'll need to treat it as a new installation. Because your current database is on 2017, you can't move it to a lower version of SQL. / comments
You'll need to treat it as a new installation. Because your current database is on 2017, you can't move it to a lower version of SQL.
I'm happy to give a hand with this. I manage licenses and hear enough from my manager about the purchasing experience. / comments
I'm happy to give a hand with this. I manage licenses and hear enough from my manager about the purchasing experience.
I shall be there. / comments
I shall be there.
A nice, clear, clean and uncluttered layout. I like it. / comments
A nice, clear, clean and uncluttered layout. I like it.
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...