Migrating from MySQL to SQL Server needs identity, collation, paging, and date rules, with SSMA assessing and converting the bulk of the work.
SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database
My students got Msg 262, SHOWPLAN permission denied, when they tried to view an execution plan. One GRANT SHOWPLAN statement fixes it.
SQL SERVER – Find Location of Data File Using T-SQL
A short T-SQL script that finds where your SQL Server Data File folder is on disk, using master.sys.master_files. Handy when you forget where the files live.
SQL SERVER – Fix Error 1949, Level 16: Cannot create index on view. The function yields nondeterministic results
Fix Error 1949: cannot create index on view because a function yields nondeterministic results. A training attendee hit it; removing that function solved it.
Which Features You Lose When You Drop an Edition
Review SQL Server edition features before moving down an edition, check persisted dependencies, and test maintenance and availability behavior.
DATETIME2FROMPARTS: Match Fractions to Precision
DATETIME2FROMPARTS constructs a complete typed timestamp. Match fraction units to precision and preserve valid calendar components.
Prefix Searches: LIKE, LEFT and CHARINDEX
LIKE, LEFT and CHARINDEX can match the same prefix through different access paths. Compare complete matching rows and measured plans, then test literal wildcard characters and collation before choosing a search expression.