Viewing 15 posts - 301 through 315 (of 631 total)
Ed Wagner (9/3/2014)
Luis Cazares (9/3/2014)
Eirikur Eiriksson (9/3/2014)
Koen Verbeeck (9/3/2014)
TomThomson (9/3/2014)
Luis Cazares (9/3/2014)
xsevensinzx (9/3/2014)
Koen Verbeeck (9/3/2014)
xsevensinzx (9/3/2014)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
September 4, 2014 at 5:44 am
Gazareth (9/3/2014)
I've just been told: "We don't recommend running SQL commands against the database"Right. May as well go home then!
You know Chris Date? Cool
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
September 4, 2014 at 5:31 am
Ed Wagner (8/22/2014)
Lynn Pettis (8/22/2014)
And Mr. Celko is back with his baseball bat. :Whistling:In more than one thread. :Whistling:
Hey, don't forget that it's an ANSI baseball bat that conforms to...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
September 1, 2014 at 5:29 am
Lynn Pettis (7/30/2014)
Really?? Let's put a 500 million row table into an in-memory table.
Hey, if it's still slow, you can also add an index on every column ...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
August 14, 2014 at 2:32 am
jay-h (8/11/2014)
Andrew..Peterson (8/11/2014)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
August 13, 2014 at 4:54 am
Jim P. (8/5/2014)
lshanahan (8/5/2014)
I can imagine managers and directors saying, "What? You want another SQL Server license just for testing?"
I've always have gotten the reading from our legal staff that...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
August 6, 2014 at 3:53 am
Gary Varga (8/5/2014) "I don't need to comment my code because I named everything well and used simple well named methods so it is all obvious".
Usually followed by something like...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
August 6, 2014 at 3:35 am
Gary Varga (7/21/2014)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
July 25, 2014 at 8:02 am
For me, the concern would be the underlying subsystem. That database has become corrupted for a reason, and in this case I would be looking at the IO systems.
Have...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
July 25, 2014 at 7:02 am
andrew gothard (7/25/2014)
marco.msantana (7/25/2014)
Yes. All tlogs until now.
In that case, I'd try restoring from the last good full backup and roll the logs forward.
Preferably to a different location (incidentally, have...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
July 25, 2014 at 5:54 am
marco.msantana (7/25/2014)
Yes. All tlogs until now.
In that case, I'd try restoring from the last good full backup and roll the logs forward.
Preferably to a different location (incidentally, have you checked...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
July 25, 2014 at 5:51 am
Do you have tLog backups?
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
July 25, 2014 at 5:07 am
SQLRNNR (7/17/2014)
Jack Corbett (7/17/2014)
Sean Lange (7/17/2014)
Sadly I will not. I need to find a way to get to one though. It is a large chunk of change for...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
July 21, 2014 at 5:43 am
Off the top of my head, probably recursive CTE.
Recursive processes in POSH, .Net or VBS - say to explore a directory structure - clear as a bell. But for...
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
July 18, 2014 at 2:39 am
thomashohner (6/25/2014)
andrew gothard (6/25/2014)
thomashohner (6/13/2014)
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
July 17, 2014 at 1:51 pm
Viewing 15 posts - 301 through 315 (of 631 total)