|
|
-
Andrey Gurinov Learned 11 Months ago through Just Learned
I found a very interesting and ingenious solution for the poster's problem in MSDN Transact-SQL forum by Peter Larsson (PESO) and it was so interesting, that I'd like to share this whole thing:
[code]
/*
I would like to insert information from table ...
|
-
Andrey Gurinov Learned 11 Months ago through Just Learned
I found a very interesting and ingenious solution for the poster's problem in MSDN Transact-SQL forum by Peter Larsson (PESO) and it was so interesting, that I'd like to share this whole thing:
[code]
/*
I would like to insert information from table ...
|
-
Andrey Gurinov Liked 12 Months ago through Just Learned
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')...
|
-
Andrey Gurinov Learned 12 Months ago through Just Learned
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')...
|
-
Andrey Gurinov Liked 12 Months ago through Just Learned
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')...
|
-
Andrey Gurinov Learned 12 Months ago through Just Learned
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')...
|
-
Andrey Gurinov knew 1 Years ago through Just Learned
I just was making some performance tests with some batches going one by one, that was returning only times of durations.
At start of every batch I called statements for cold start, so - in result - it added doubled
<pre class="brush: sql">
DBCC exe...
|
-
Andrey Gurinov knew 1 Years ago through Just Learned
I just was making some performance tests with some batches going one by one, that was returning only times of durations.
At start of every batch I called statements for cold start, so - in result - it added doubled
<pre class="brush: sql">
DBCC exe...
|
-
Andrey Gurinov knew 1 Years ago through Just Learned
I saw today, in someones code, something like this:
GO 100
At first, I thought that was some typing mistake, but then I found that GO has not only function of ending batch, but also it can execute that batch many times, as specified in:
GO...
|
-
Andrey Gurinov knew 1 Years ago through Just Learned
I saw today, in someones code, something like this:
GO 100
At first, I thought that was some typing mistake, but then I found that GO has not only function of ending batch, but also it can execute that batch many times, as specified in:
GO...
|