Viewing 15 posts - 121 through 135 (of 2,838 total)
Just found a surprising test result. Well surprising to me at least.
Testing on an Azure DS-series "Premium iops" machine. All SSD drives. SQL Server 2014.
Index rebuild of 1 million records,...
January 29, 2015 at 8:52 am
hans.reidt (1/28/2015)
Something to keep in mind of course, is the number / complexity of indexes.
A possibility is to disable all indexes, remove...
January 28, 2015 at 9:27 am
hans.reidt (1/28/2015)
My way of working:[font="Courier New"]
BEGIN TRAN
SELECT DISTINCT *
INTO #tempTable
FROM myTable
TRUNCATE TABLE myTable
INSERT INTO myTable
SELECT *
FROM #tempTable
COMMIT TRAN
DROP TABLE #tempTable
[/font]
That certainly is a way you can do it,...
January 28, 2015 at 9:04 am
Koen Verbeeck (1/27/2015)
So it seems the snow blizzard of the century in New York was just a mild breeze?
Not from what I've heard out of NYC. And here in Boston...
January 27, 2015 at 1:23 pm
Jack Corbett (1/26/2015)
Grant Fritchey (1/26/2015)
What it's like, at this exact moment, everywhere in Massachusetts.
That's awesome. Of course, last night I told my wife, "make sure you fill...
January 26, 2015 at 10:40 am
Grant Fritchey (1/23/2015)
Steve Jones - SSC Editor (1/23/2015)
Sioban Krzywicki (1/23/2015)
GilaMonster (1/23/2015)
January 23, 2015 at 11:55 am
I think some people who comment on articles never read past the title.
January 23, 2015 at 11:41 am
PHYData DBA (1/23/2015)
If the table is a true Heap with no PK and the records in every column match you would have...
January 23, 2015 at 11:40 am
pmusiej (1/23/2015)
Hi,I some times use cte to delete duplicates. It works fine.
Paul
Sure! That's a way you can do it. Want to post some code to share with people? I find...
January 23, 2015 at 9:44 am
Jeff Moden (1/23/2015)
Shankar Walvekar (1/23/2015)
http://deleteduplicaterecords.blogspot.in/You get all answers here
Why? Sioban's article has all the answers along with reasons why it works.
Thanks Jeff.
I feel like I always see someone self-promoting...
January 23, 2015 at 9:30 am
GilaMonster (1/23/2015)
Luis Cazares (1/22/2015)
Brandie Tarvin (1/22/2015)
rodjkidd (1/22/2015)
Steve Jones - SSC Editor (1/21/2015)
What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for...
January 23, 2015 at 8:06 am
nicolas_johnson 52979 (1/23/2015)
January 23, 2015 at 8:03 am
Grant Fritchey (1/22/2015)
Sioban Krzywicki (1/22/2015)
Grant Fritchey (1/22/2015)
Steve Jones - SSC Editor (1/21/2015)
What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for...
January 22, 2015 at 9:02 am
Grant Fritchey (1/22/2015)
Steve Jones - SSC Editor (1/21/2015)
What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for the Friday night party.
Need...
January 22, 2015 at 8:01 am
rodjkidd (1/22/2015)
Brandie Tarvin (1/22/2015)
rodjkidd (1/22/2015)
Steve Jones - SSC Editor (1/21/2015)
What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for the Friday...
January 22, 2015 at 7:13 am
Viewing 15 posts - 121 through 135 (of 2,838 total)