Viewing 15 posts - 3,376 through 3,390 (of 9,720 total)
At risk of starting another rant, if you're already updating the stored procedure, variables are easy enough to rename.
September 26, 2013 at 7:33 am
Data Mirroring is also an option. But...
You broke replication for an upgrade. Why did you not upgrade the other server? If you did, why did you not rebuild / reinitialize...
September 26, 2013 at 7:05 am
george sibbald (9/26/2013)
you can upgrade just one instance.
Really?
I don't remember seeing that available in my install files. Now I'm going to have to go try it...
Hrm. Something else to learn...
September 26, 2013 at 7:01 am
Oh, dear... Yes, I have been down this road before (old employer). If you are going to have multiple clients on the same box, do absolutely make sure they are...
September 26, 2013 at 6:56 am
You can't upgrade an instance separately from other instances. It's all or nothing.. Or a side by side install.
I would recommend installing a brand new R2 instance in a different...
September 26, 2013 at 6:42 am
My comments vary. Usually we start off with the following:
/****************************
InstallDB: MyDB1
CreatedBy: Brandie
CreatedOn: 2012.09.26
Description: This proc pulls the orders made within the last week that were not
...
September 26, 2013 at 6:39 am
Daniel,
I would agree with Andrew. This sounds like a case of your services running under a local account instead of an plain vanilla Domain (Active Directory) account. Local accounts can...
September 26, 2013 at 6:27 am
Bhuvnesh (9/24/2013)
Brandie Tarvin (9/24/2013)
September 24, 2013 at 8:24 am
Hrmm... You know, you're right. I can't think of any reason why it wouldn't work in the INCLUDE list...
Thanks.
September 24, 2013 at 7:19 am
The thing I'm concerned with is R2's extra capabilities. I'm developing stuff, but our environment is all regular 2008 (and the R2 is my personal copy that I have on...
September 24, 2013 at 6:35 am
mar1jxm (9/20/2013)
September 24, 2013 at 6:15 am
GAH. I keep forgetting that I can't create an index on the Extract column because the column is too big.
I guess I'll have to live with the Key Lookup after...
September 24, 2013 at 6:07 am
mister.magoo (9/20/2013)
Query 4 is RBAR on acid!
Tell me about it.
Triangular join from hell with over 500 billion rows in one section. The comment says you are linking "3" records to...
September 24, 2013 at 6:00 am
wolfkillj (9/20/2013)
In just a quick review of your DDL, I didn't see an index that would cover this query. FIDX_StagingRecID2 comes close but it doesn't include the Extract_RI column.
*headdesk*...
September 24, 2013 at 5:55 am
This is no real best practice. And most people don't worry about the Transaction logs hitting at the "same time" as the Differential or Full backups because they deliberately create...
September 23, 2013 at 11:48 am
Viewing 15 posts - 3,376 through 3,390 (of 9,720 total)