|
|
-
Olga Medvedeva Commented 1 Months ago through Blogs
No, they are not the same in terms of consuming space. varchar(1) takes more space. The storage size of varchar is the actual length of the data entered (1 byte in our case) + 2 bytes. So it takes 3 bytes. char(1) takes only 1 byte....
|
-
Olga Medvedeva Liked 1 Months ago through Blogs
If you ever need to get a list of installed SQL Server features and their respective patch levels, the Installed SQL Server Feature Discovery Report bundled with the SQL Server installer can be used. This post gives a step-by-step guide about using this...
|
-
Olga Medvedeva Liked 1 Months ago through Blogs
When working on development projects, one may need to restart servers and/or workstations often. When working from remote locations or on virtual machines hosted on the network, this often becomes a challenge. Today, I will show how to shutdown or resta...
|
-
Olga Medvedeva refreshed 1 Months ago through Blogs
When working on development projects, one may need to restart servers and/or workstations often. When working from remote locations or on virtual machines hosted on the network, this often becomes a challenge. Today, I will show how to shutdown or resta...
|
-
Olga Medvedeva Liked 1 Months ago through Blogs
Although one of the most robust change and tamper detection mechanisms available in Microsoft SQL Server, HASHBYTES suffers from a limitation that it cannot handle more than 8000 bytes of input, which translates to 4000 NVARCHAR characters....
|
-
Olga Medvedeva Liked 2 Months ago through Blogs
MySQL provides top 6 commands to maintain database table more efficiently. These six commands enable users to analyze, backup, optimize, check, repair and restore MySQL database tables...
|
-
Olga Medvedeva refreshed 2 Months ago through Blogs
MySQL provides top 6 commands to maintain database table more efficiently. These six commands enable users to analyze, backup, optimize, check, repair and restore MySQL database tables...
|
|
|
|
|
|
|