Comments
Sort by recent activity
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 ...
You can download it from the 'Products' page of the Redgate site and it won't interfere with the other products that you already have. Or you could download the toolbelt and it will update the versions that you already have and also install Compare as part of that. / comments
You can download it from the 'Products' page of the Redgate site and it won't interfere with the other products that you already have. Or you could download the toolbelt and it will update the vers...
Can I ask for clarification? SQL Compare compares columns, not indexes. If a column has an index applied that doesn't change the comparison. What is that you are trying to achieve - in case I've misunderstood your question. / comments
Can I ask for clarification? SQL Compare compares columns, not indexes. If a column has an index applied that doesn't change the comparison. What is that you are trying to achieve - in case I've mi...
My understanding is that one licence for one installation and if that one installation can see all 8 servers then that is fine. We have one installation watching an AG group, which is four servers and two instances on each. / comments
My understanding is that one licence for one installation and if that one installation can see all 8 servers then that is fine. We have one installation watching an AG group, which is four servers ...
The 'normal' alert configuratuioin doesn't allow you to specify particular disks - it monitors all that it can see for a specified server. However, you could use the 'custom metrics' to write a process that returned the free space for a particular drive and add an alert to that. / comments
The 'normal' alert configuratuioin doesn't allow you to specify particular disks - it monitors all that it can see for a specified server.However, you could use the 'custom metrics' to write a proc...