Viewing 15 posts - 1 through 15 (of 80 total)
Jacob,
That worked nicely, thank you very much.
Mark
January 27, 2016 at 1:24 pm
My apologies on the AcctNo column, it should have been VARCHAR(50), that was a typo. The source data for both seqno and acctno is character data and not intergers.
January 27, 2016 at 1:22 pm
The computed column is persisted.
[jobdescription_short] AS (CONVERT([varchar](350),[jobdescription],(0))) PERSISTED,
January 10, 2011 at 6:32 am
Here's a caveat you can add to running sp_who2 to get just the running processes.
exec sp_who2 active
May 9, 2008 at 7:18 am
Good article Steve, your research always helps the rest of us.
Mark
May 15, 2007 at 9:25 am
Is the Distributed Transaction Coordinator service running?
Mark
February 7, 2007 at 10:09 am
That's what I'm hoping to get across to you. You can't apply any differential backup that was taken prior to the full backup you've restored from 11/21. As long as...
December 12, 2006 at 8:26 am
You're trying to apply a differential backup that was taken prior to the full backup you've restored. You can't do that, they're out of sequence.
HTH
Mark
December 12, 2006 at 8:12 am
So are you saying you have tried to restore the full backup from 11/21 and the differentials prior to your delete on 11/28 and the data is not there?
Mark
December 12, 2006 at 7:36 am
Janet,
It sounds to me like you are better off for moving on. From what you described, my perception of the problem is somebody was threatened by your abilities. It's sad...
December 5, 2006 at 7:11 am
I was all ready to start trying this until I read:
3. Performance of the source database is reduced, due to increased I/O on the source database resulting from a copy-on-write...
November 27, 2006 at 7:47 am
There is an initiative here to get rid of the UDFs and rewrite them and make them stored procedures. I can thankfully say this app was before my time here...
November 21, 2006 at 7:01 am
We have an application that was written by a consulting firm; they wrote a ton of UDFs that utiliize Table Variables. We had one report in particular that was really...
November 21, 2006 at 6:27 am
I appreciate articles like this; even though I've been a DBA for a while I almost always see something in this type of article that I didn't know. I think it's...
October 20, 2006 at 7:14 am
Viewing 15 posts - 1 through 15 (of 80 total)