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
Generate Insert Query in SQL
Sometimes we need to generate the INSERT script in sql server. When, we need to insert bulk of data from...
2010-08-26
3,145 reads
SQL Blog (Basic)
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,030 reads
Blogs
Daily Coping 27 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 26 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Seeding an Availability Group Replica from Snapshot
Background If you’ve been using Availability Groups, you’re familiar with the replica seeding (sometimes...
Forums
Need to provide access to database without giving access to production
Hoping I could find some best practice answers here: We have analysts who need...
Fill missing rows in dataset
I have data in table like this. I want to fill/insert the rows with...
Sign all stored procedures with a Certificate.
Hello, My company is going about ever increasing our security on all our Servers/databases....
Ask SSC