How do you view ALL text from an NTEXT or NVARCHAR(max) in SQL Server Management Studio? By default, it only seems to return the first few hundred characters (255?) but sometimes I just want a quick way of viewing the whole field, without having to write a program to do [...]
Useful SQL to check your indexes. If avg fragmentation is larger than 15% consider rebuilding the indexes: SELECT OBJECT_NAME ( object_id,database_id), * FROM [sys].dm_db_index_physical_stats, NULL, NULL, NULL, DEFAULT) AS ddips order by avg_fragmentation_in_percent desc [...]
When trying to import a local SQL database to an Azure SQL Database using SQL Enterprise Manager you can see this error. This is a know issue on Enterprise manager and nothing wrong with your database or connection. To resolve you need to use a different tool to migrate your [...]
A bit of a long post today, but worth it, because probably the only thing more complicated than SharePoint…Microsoft Licensing: For most organizations, there are four editions of SQL Server 2012 to consider when using the product in its primary roles of database server, reporting server, or analysis or data-mining [...]
