|
|
-
Kirti M.Darji Liked 3 Months ago through Just Learned | 1 Point
Until now, I always believed the maximum number of partitions a table could have was 1,000. This is correct for 32-bit SQL Server. In 64-bit, however, up to 15,000 are permissable....
|
-
Kirti M.Darji Learned 3 Months ago through Just Learned | 1 Point
Until now, I always believed the maximum number of partitions a table could have was 1,000. This is correct for 32-bit SQL Server. In 64-bit, however, up to 15,000 are permissable....
|
-
Kirti M.Darji Liked 3 Months ago through Just Learned | 1 Point
Be aware when you read XML data from Microsoft SQL Server by using the **SqlDataReader** object or **ExecuteScalar** method of SqlCommand class, the XML in the first column of the first row is truncated at 2,033 characters. To resolve this problem, u...
|
-
Kirti M.Darji Learned 3 Months ago through Just Learned | 1 Point
Be aware when you read XML data from Microsoft SQL Server by using the **SqlDataReader** object or **ExecuteScalar** method of SqlCommand class, the XML in the first column of the first row is truncated at 2,033 characters. To resolve this problem, u...
|
-
Kirti M.Darji Liked 3 Months ago through Just Learned | 1 Point
Earlier on Beyondrelational I read a tip, for the same topic.
combination of keys Shift + Print screen, allows us to take screen shot of Remote Desktop.
But recently I faced problem using these keys. It allowed taking print screen only once. Every ot...
|
-
Kirti M.Darji Learned 3 Months ago through Just Learned | 1 Point
Earlier on Beyondrelational I read a tip, for the same topic.
combination of keys Shift + Print screen, allows us to take screen shot of Remote Desktop.
But recently I faced problem using these keys. It allowed taking print screen only once. Every ot...
|
-
Kirti M.Darji Liked 6 Months ago through Just Learned | 1 Point
SQL Server interprets two-digit years based on a cutoff year of 2049. That is, the two-digit year 49 is interpreted as 2049 and the two-digit year 50 is interpreted as 1950.
SQL Server also provides cutoff configurations but Microsoft recommend usin...
|
-
Kirti M.Darji Learned 6 Months ago through Just Learned | 1 Point
SQL Server interprets two-digit years based on a cutoff year of 2049. That is, the two-digit year 49 is interpreted as 2049 and the two-digit year 50 is interpreted as 1950.
SQL Server also provides cutoff configurations but Microsoft recommend usin...
|
-
Kirti M.Darji Liked 6 Months ago through Just Learned | 1 Point
If you use "select * into" to create a new table from an existing table having a primary key, then the new table will not have a primary key by default....
|
-
Kirti M.Darji Learned 6 Months ago through Just Learned | 1 Point
If you use "select * into" to create a new table from an existing table having a primary key, then the new table will not have a primary key by default....
|