Viewing 15 posts - 16,861 through 16,875 (of 26,489 total)
GT-897544 (2/17/2010)
Yes\No, because it is very rare you restore system databases, but no harm in taking system databases as they take little space. Include them in maintenance job.EnjoY!
Backing up the...
February 17, 2010 at 4:35 pm
Alvin Ramard (2/17/2010)
Roy Ernest (2/17/2010)
Alvin Ramard (2/17/2010)
GSquared (2/17/2010)
It's all part of The Thread's plot to take over the world. You may very well be the only defense we have...
February 17, 2010 at 3:59 pm
It would help if you would provide table defs (CREATE TABLE statements), sample data (series of INSERT INTO statements for the tables), expected results based on the sample data, and...
February 17, 2010 at 1:37 pm
And nested cursors don't scale very well at all.
If you provide the info requested, we could probably provide you with a much more scalable and mainatainable set based solution.
February 17, 2010 at 1:22 pm
GilaMonster (2/17/2010)
Lynn Pettis (2/17/2010)
Shoot-Ready-Aim must work in a perfect environment where the right people always know when things go wrong and communication actually works the way it should.
and DBAs know...
February 17, 2010 at 12:54 pm
CirquedeSQLeil (2/17/2010)
Alvin Ramard (2/17/2010)
Twitter certainly is entertaining today.Thanks Alvin - I would like to see what is going on - but twitter is blocked by websense.
I catch it on my...
February 17, 2010 at 12:48 pm
Alvin Ramard (2/17/2010)
Twitter certainly is entertaining today.
Sheep, goats, and wet suits. Definitely interesting...
February 17, 2010 at 12:47 pm
First, you really should look for a set-based solution to this problem. The cursor-based just won't scale well. We don't have enough info to help you write a...
February 17, 2010 at 12:43 pm
Alvin Ramard (2/17/2010)
Lynn Pettis (2/17/2010)
Alvin Ramard (2/17/2010)
A wise person once told me:
[font="Comic Sans MS"]"Do not argue with a fool. People may not know which...
February 17, 2010 at 12:37 pm
CirquedeSQLeil (2/17/2010)
February 17, 2010 at 12:29 pm
Alvin Ramard (2/17/2010)
Changing subject for a second.A wise person once told me:
[font="Comic Sans MS"]"Do not argue with a fool. People may not know which one is the fool."[/font]
Pretty...
February 17, 2010 at 12:26 pm
Shoot-Ready-Aim must work in a perfect environment where the right people always know when things go wrong and communication actually works the way it should.
February 17, 2010 at 12:21 pm
GT-897544 (2/17/2010)
Lynn Pettis (2/17/2010)
GT-897544 (2/17/2010)
February 17, 2010 at 12:18 pm
If the table is 1 TB in size, you will want to break the update into chunks or you could end up locking the entire table during the update.
Some idea...
February 17, 2010 at 11:53 am
cmallain (2/17/2010)
Alvin Ramard (2/17/2010)
cmallain (2/17/2010)
February 17, 2010 at 11:45 am
Viewing 15 posts - 16,861 through 16,875 (of 26,489 total)