What is Normalization in SQL ?
=> What is normalization ?
Defination :Normalization is the process of efficiently organizing data in a database. There are two goals of...
2010-09-07
303,348 reads
=> What is normalization ?
Defination :Normalization is the process of efficiently organizing data in a database. There are two goals of...
2010-09-07
303,348 reads
Sometimes we need to generate the INSERT script in sql server. When, we need to insert bulk of data from...
2010-08-26
3,161 reads
1. SQL Objects
a. Stored Procedures : a bunch of SQL statement which can be stored under one name.
Adventages :
can be used...
2010-07-02
1,032 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
By Steve Jones
Today’s coping tip is to be gentle with yourself when you make mistakes. I...
I have a two-replica SQL Server Availability Group running on Windows VMs in the...
I have a SQL agent job which starts the trace (for audit purpose) everyday...
I have a number of databases on a sql server 2017 instance. For most...