Search results for #SQLProTip
#SQLProTip: Use the "NOT IN" operator to exclude specific values from a query. ```sql SELECT * FROM table_name WHERE column_name NOT IN (value1, value2, value3); ``` This trick helps filter out unwanted records and retrieve the desired data efficiently. #SQL #DatabaseQuery
#ProTip #SQLProTip In #SQLServer, taking a database offline will either take 1 second or 6.5 months. You have no way of knowing which one you'll get.
#SQLProtip Pro Tip 1: Do NOT make a logon trigger with an execute as and then DROP the user by which it executes. Nuh uh.... oops
Pro Tip: Give all users full control to the master database. that's the only place they run their queries anyways #sqlprotip
@tameraclark #SQLProTip? I trhink You are on to something make it so :) #JustTheTip
Avoid functions on columns in where clauses #sqlbits #sqlprotip
Make sure you have unique constraints on lookup tables #sqlprotip #sqlbits
Avoid functions on columns in where clauses #sqlbits #sqlprotip
When dividing column x by col Y, always* wrap with a NULLIF unless col Y has a > 0 Check Constraint #sqlProTip *YMMV