Viewing 15 posts - 4,876 through 4,890 (of 6,041 total)
Deleting rows in chunks is the way to go, but you also need to perform a checkpoint and transaction log backup between each iteration. That will insure that the inactive...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 12, 2013 at 11:02 am
Revenant (6/11/2013)
Steve Jones - SSC Editor (6/11/2013)
. . . I could see all kinds of quick analysis stuff moving because it's easier or quicker to throw something up in a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 11, 2013 at 12:59 pm
Gary Varga (6/11/2013)
chrisn-585491 (6/11/2013)
I can see a scenario where organizations turn to cloud based services to host their e-commerce database or quickly spin up some one-off analytical solution requested by...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 11, 2013 at 9:46 am
chrisn-585491 (6/11/2013)
Perhaps the death of WinForms is more than the passing of a reworked old technology but more the true passing of the client\server age.
It's funny that WinForms is still...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 11, 2013 at 8:01 am
Richie T (6/7/2013)
Any Ideas what the best way would be to perform this update?
UPDATE
D
SETTrack_ID= P.Track_ID,
Territory_ID= P.Territory_ID,
Major= P.Major
FROMStaging.Track_MappingP
INNER JOINStaging.Track_PlayD
ONP.ISRC= D.ISRC_Code
ANDP.Event_Date= D.Event_Date
Both tables have around 63 million rows and have numerous...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 11, 2013 at 7:35 am
How long before Microsoft has a similar service that might troubleshoot issues with products, perhaps even working with developers to find bugs and workarounds. I'd imagine that this service would...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 11, 2013 at 7:20 am
jcrawf02 (6/10/2013)
Grant Fritchey (6/10/2013)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 10, 2013 at 8:28 am
Failover clusters are a good idea, but don't let your SAN be a single point of failure. Years ago, I worked at a place which actually had invested in a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 10, 2013 at 7:44 am
L' Eomot Inversé (6/8/2013)
mtillman-921105 (6/8/2013)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 10, 2013 at 7:14 am
Brian Carlson (6/6/2013)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 6, 2013 at 11:03 am
krowley (6/6/2013)
Put the files on a USB drive and drop it in the mail or get in your car and drive them to the other location. :hehe:
I was about to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 6, 2013 at 7:44 am
Brian Carlson (6/5/2013)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 6, 2013 at 6:20 am
You can use REPLACE() function to strip character sequences from a varchar column like so:
select replace( col1, '@DAR', '' );
You can also use the LIKE operator to return (or check)...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 5, 2013 at 10:28 am
From my experience, it's a waste of time to allow non-technical users to run ad-hoc queries against a database. What will typically happen is that they'll run a bunch of...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 5, 2013 at 10:07 am
Viewing 15 posts - 4,876 through 4,890 (of 6,041 total)