sql server

chapter contents

• backup restore script
• create schema specific role
• datetime trim hours milliseconds
• delete duplicate rows
• delete millions of rows
• find large tables
• find view function or sproc
• first day of month
• format datetime yyyy-MM-dd
• format your queries
• histogram
• inline min
• last monday
• Log Message During LongRunning Proc
• mismatch between estimated and actual
• outer apply
• pivot
• run a command against each table
• scalar function AfterChar
• select top with dynamic limit
• slow and long running queries
• split string
• sp heltpext
• start time
• trailing cr lf
• Weibull Function
• with common table expression
• xtype