SQL SERVER – Retrieve All the Data from VARCHAR(MAX) Column
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 …
SQL Slow Performance
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 …
Could Not Import Package…Unable to connect to target server
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 …
Selecting the right edition of SQL 2012 for the task
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 …