Babin Joshi
Life is a cruel prank played on the living - Charles Boyle
HOME
CATEGORIES
TAGS
ARCHIVES
ABOUT
Home
Tags
Tags
Cancel
Tags
1nf
1
2nf
1
3nd
1
abs
2
activation functions
1
after
2
alter column
1
alter function
1
altering triggers
1
ann
2
avg
4
Begin a transaction
1
between
1
cascade
1
case
2
cast
3
ceiling
1
charindex
2
cheat-sheet
1
cnn
2
coalesce
1
commit a transaction
1
common table expressions
1
computed columns
1
concat
1
concat_ws
1
concurrency
1
convert
3
count
4
count distinct
1
count(distinct)
1
count_big
1
create
1
create procedure
1
create table
1
create view
1
cte
2
curl
7
current_timestamp
1
Data Anomalies
1
Data Integration
1
data lakes
1
data type precedence
1
data types and conversion
1
data warehouse
1
databse roles
1
date manipulation
1
dateadd
3
datediff
3
datefrompart
1
datefromparts
1
datename
2
datepart
3
datetime2fromparts
1
datetimefromparts
1
datetimeoffsetfromparts
1
DDL triggers
1
de-normalization
1
declare
2
delete
1
deleted tables
1
deleting and altering triggers
1
Deletion Anomaly
1
dense_rank
1
derived tables
1
dimension tables
1
disabling triggers
1
distince
1
distinct
2
downsampling
1
drop column
1
drop trigger
1
drop view
1
elt
1
enabling triggers
1
er-diagram
1
error anatomy
1
error handling
2
error_line
1
error_message
1
error_number
1
error_procedure
1
error_severity
1
error_state
1
etl
1
exec
1
fact tables
1
first_value
2
floor
1
foreign keys
2
format
1
formatmessage
1
getdate
2
getutcdate
2
grant
1
grant privilege
1
group by
2
grouping sets
1
having
2
Horizontal Partitioning
1
in
1
information schema
1
inner join
1
insert
1
insert into
1
insert select
1
inserted tables
1
Insertion Anomaly
1
instead of
2
is not null
1
is null
1
isdate
1
lag
3
last_value
2
lead
3
left
2
left join
1
len
2
like
1
log
1
Logon triggers
1
loops
1
lower
1
ltrim
1
materalized views
1
max
4
min
4
missing values
1
mongodb
9
month
1
no action
1
non-materialized views
1
normal forms
1
normalization
1
not null
1
olap
1
oltp
1
order by
2
over
1
pandas
1
partition by
2
partition limits
1
patindex
1
percent
1
power
1
primary keys
2
python
27
query a view
1
raiserror
1
range
1
rank
1
read committed
1
read uncommitted
1
redefine view
1
references
1
referential integrity violations
1
rename column
1
repeatable read
1
replace
2
restrict
1
revoke
1
revoke privilege
1
right
2
right join
1
rollback a transaction
1
rollup
1
round
2
row_number
2
rtrim
1
savepoints
1
schemabinding
1
select
1
serializable
1
set
2
set dateformat
1
set default
1
set language
2
set null
1
sign
1
smalldatetimefromparts
1
snapshot
1
snowflake schema
1
sql
37
sqrt
2
square
2
star schema
1
stdev
2
stdevp
1
stored procedures
1
string_agg
1
string_split
1
sub query
1
substring
2
sum
3
surrogate keys
1
switchoffset
1
sysdatetime
2
sysdatetimeoffset
1
sysutcdatetime
2
t-sql
37
Table Partitioning
1
table valued udf
1
temporal eda
1
temporary tables
1
throw
1
timefromparts
1
timezones
1
todatetimeoffset
1
top
1
transactions
1
trigger
1
trigger alternatives
1
trim
1
troubleshooting triggers
1
truncate
1
try...catch
1
try_cast
1
try_convert
1
try_parse
1
types of trigger
1
udf
1
union
1
union all
1
unique
1
update
1
Update Anomaly
1
upper
1
upsampling
1
var
1
varp
1
Vertical Partitioning
1
viewing views
1
views
1
wget
7
where
1
while
1
wildcard characters
1
window functions
1
year
1
Recently Updated
Wild Cards Tutorial
Basic Linux Commands
Window Functions
Introduction to Pandas
4. Patterns 2
Trending Tags
sql
t-sql
python
mongodb
curl
wget
avg
count
max
min
Trending Tags
sql
t-sql
python
mongodb
curl
wget
avg
count
max
min
