sql server
chapter contents
- backup restore script
- bulk comparison with hashbytes
- case sensitive string comparison
- check if column constraint index exists
- collation find change compare
- convert hex varchar to bigint
- convert timestamp to varchar
- Create Schema Authorization
- create schema specific role
- CsvToHtml Function in SQL
- ctrl e execute
- data dictionary
- datetime trim hours milliseconds
- delete backup files
- delete duplicate rows
- delete millions of rows
- drive sizes
- find large tables
- find view function or sproc
- first day of month
- format datetime yyyy-MM-dd
- format your queries
- generate change script
- histogram
- how much space does my db use
- identity insert off
- import csv
- inline min
- last monday
- Log Message During LongRunning Proc
- mismatch between estimated and actual
- outer apply
- parse varchar into datetime
- pivot
- run a command against each table
- R Services and Regex
- scalar function AfterChar
- see wait times
- select top with dynamic limit
- simple recovery model
- slow and long running queries
- split string
- sp heltpext
- start time
- table re creation
- temporal tables
- trailing cr lf
- update millions of rows
- Weibull Function
- windowed functions
- with common table expression
- xtype