|
|
-
Sergejack interesting 10 Months ago through Just Learned | 1 Point
New feature "**Code Clone Analysis**" in introduce in Visual Studio 2012
You can find clones of specific code by selecting the segment you are interested then right click on the selection to choose Find Matching Clones in Solution from the context...
|
-
Sergejack Commented 11 Months ago through Just Learned | 1 Point
There's actually not much difference of memory usage for @tmp in the insert approach and the merge approach in those examples we used.
But check that one out:
(Note: I reduced the count of articles to a tenth (34.000) of the count you used)
SET...
|
-
Sergejack Commented 11 Months ago through Just Learned | 1 Point
There's actually not much difference of memory usage for @tmp in the insert approach and the merge approach in those examples we used.
But check that one out:
(Note: I reduced the count of articles to a tenth (34.000) of the count you used)
SET...
|
-
Sergejack Commented 11 Months ago through Just Learned | 1 Point
Here you are.
SET NOCOUNT ON
SET STATISTICS TIME OFF
SET STATISTICS IO OFF
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[t388Part]') AND type in (N'U'))
DROP TABLE [dbo].[t388Part]
G...
|
-
Sergejack Commented 11 Months ago through Just Learned | 1 Point
Here you are.
SET NOCOUNT ON
SET STATISTICS TIME OFF
SET STATISTICS IO OFF
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[t388Part]') AND type in (N'U'))
DROP TABLE [dbo].[t388Part]
G...
|
-
Sergejack Commented 11 Months ago through Just Learned | 1 Point
Here you are.
SET NOCOUNT ON
SET STATISTICS TIME OFF
SET STATISTICS IO OFF
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[t388Part]') AND type in (N'U'))
DROP TABLE [dbo].[t388Part]
GO
...
|
-
Sergejack Commented 11 Months ago through Just Learned | 1 Point
Here you are.
SET NOCOUNT ON
SET STATISTICS TIME OFF
SET STATISTICS IO OFF
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[t388Part]') AND type in (N'U'))
DROP TABLE [dbo].[t388Part]
GO
...
|
-
Sergejack Commented 11 Months ago through Just Learned | 1 Point
You got me wrong, I don't disrespect your saying I'm just not willing to discuss it and I gave you my feelings as an invitation to check what may be said about it by people that actually wanted to discuss it....
|
-
Sergejack Commented 11 Months ago through Just Learned | 1 Point
You got me wrong, I don't disrespect your saying I'm just not willing to discuss it and I gave you my feelings as an invitation to check what may be said about it by people that actually wanted to discuss it....
|
-
Sergejack Liked 11 Months ago through Just Learned | 1 Point
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
[SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...
|