Viewing 15 posts - 2,626 through 2,640 (of 19,564 total)
Sean Lange (7/17/2014)
SQLRNNR (7/17/2014)
The Dixie Flatline (7/16/2014)
July 17, 2014 at 8:09 am
Hany Helmy (7/17/2014)
Jamsheer (7/15/2014)
Thanks.. But still confused:-P.. need to work on it..Same confusion here, really. :w00t:
The problem is that tinyint is an unsigned datatype (unlike smallint, int, and bigint).
Because it...
July 17, 2014 at 8:07 am
Jack Corbett (7/17/2014)
SQLRNNR (7/17/2014)
Eirikur Eiriksson (7/16/2014)
Jack Corbett (7/16/2014)
Eirikur Eiriksson (7/16/2014)
July 17, 2014 at 8:03 am
Eirikur Eiriksson (7/17/2014)
Grant Fritchey (7/17/2014)
Threadizens!Make sure we talk if you're Telford this week. The Red Gat Army is travelling up there this afternoon.
Would that be this bunch?
😎
That looks eerily like...
July 17, 2014 at 7:56 am
Eirikur Eiriksson (7/16/2014)
Jack Corbett (7/16/2014)
Eirikur Eiriksson (7/16/2014)
July 17, 2014 at 7:47 am
So a total database size of 3gb is fairly small.
With the affected rows to be roughly half of the database, that is about 1.5GB which is still pretty small.
Take into...
July 17, 2014 at 7:45 am
The Dixie Flatline (7/16/2014)
July 17, 2014 at 7:34 am
Ed Wagner (7/16/2014)
TomThomson (7/16/2014)
SQLRNNR (7/16/2014)
Ed Wagner (7/16/2014)
TomThomson (7/16/2014)
BWFC (7/16/2014)
Ed Wagner (7/14/2014)
SQLRNNR (7/14/2014)
Revenant (7/14/2014)
Ed Wagner (7/14/2014)
SQLRNNR (7/14/2014)
BWFC (7/11/2014)
Venusdesire
Want
Wanton
Pork
Launch 😀
Dinghy
wherry
Row
Tuple
Sequence
Fibonacci
spiral
July 16, 2014 at 11:52 am
Lynn Pettis (7/16/2014)
TomThomson (7/16/2014)
Jack Corbett (7/16/2014)
Steve Jones - SSC Editor (7/16/2014)
GilaMonster (7/16/2014)
Jeff Moden (7/15/2014)
July 16, 2014 at 10:29 am
What is the size of the database?
What is the speed of the connection between servers?
What is the record count to be deleted?
Those answers will help to understand a better approach.
July 16, 2014 at 9:39 am
Jack Corbett (7/16/2014)
SQLRNNR (7/16/2014)
The Dixie Flatline (7/15/2014)
Sometimes I think MVPs are a real pain in the ***. Present company excepted.I agree
I wouldn't except present company all...
July 16, 2014 at 8:51 am
Ed Wagner (7/16/2014)
TomThomson (7/16/2014)
BWFC (7/16/2014)
Ed Wagner (7/14/2014)
SQLRNNR (7/14/2014)
Revenant (7/14/2014)
Ed Wagner (7/14/2014)
SQLRNNR (7/14/2014)
BWFC (7/11/2014)
Venusdesire
Want
Wanton
Pork
Launch 😀
Dinghy
wherry
Row
Tuple
July 16, 2014 at 8:45 am
sknox (7/16/2014)
Koen Verbeeck (7/16/2014)
Raghavendra Mudugal (7/16/2014)
Koen Verbeeck (7/16/2014)
Unless a clustered index was already defined. 🙂
how you mean? "already"
this simple statement creates a clustered index
CREATE TABLE TT1
(
ID INT...
July 16, 2014 at 8:41 am
The Dixie Flatline (7/15/2014)
Sometimes I think MVPs are a real pain in the ***. Present company excepted.
I agree
July 16, 2014 at 7:49 am
Viewing 15 posts - 2,626 through 2,640 (of 19,564 total)