|
|
-
Patrick Lambin Liked 1 Years ago through Just Learned | 1 Point
With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')...
|
-
Patrick Lambin Liked 1 Years ago through Just Learned | 1 Point
With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')...
|
-
Patrick Lambin knew 1 Years ago through Just Learned | 1 Point
With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')...
|
-
Patrick Lambin knew 1 Years ago through Just Learned | 1 Point
With help of below query we can quickly find the node on which sql is currently running. This is useful in clustered environments.
Select serverproperty('ComputerNamePhysicalNetBIOS')...
|
|
|
|
|
|
|
|
|
-
Patrick Lambin Liked 1 Years ago through Just Learned | 1 Point
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...
|
-
Patrick Lambin Liked 1 Years ago through Just Learned | 1 Point
I learned about this from Pinal Dave's blog(You can see the original article in references.)
In SQL Server, while creating a table, we can give maximum length of 128 characters. However, while creating temp tables, maximum length can be of 116 chara...
|