Viewing 15 posts - 3,166 through 3,180 (of 9,725 total)
John Mitchell-245523 (8/15/2014)
BrandieIs it a witness you're looking for?
John
I wish. Corporate set up the mirroring without a witness server. @=(
August 15, 2014 at 7:27 am
I think it would help us to know what your replication set up is.
What type of replication?
What is the latency / timing?
Approximately how many subscriptions do you have...
August 15, 2014 at 7:23 am
Our business has 2 data centers. We replicate every single backup (including the system DBs) to the other data center. If we lose the server, there are two places we...
August 15, 2014 at 7:16 am
matt6749 (7/30/2014)
After shrinking I will rebuild the indexes to help reduce the fragmentation.
I have some pretty bad news for you. Rebuilding the indexes will reduce fragmentation, but will increase the...
July 31, 2014 at 7:01 am
samanta0rodriges (7/30/2014)
why won't Shrinkfile help?
If you are not regularly backing up the transaction logs, the log won't free up any space. It will hold onto all the space it has...
July 30, 2014 at 5:40 am
Chris Wooding (7/24/2014)
Why are duplicate companies a problem? I would expect at least a few cases where you have more than one contact at a particular company.
Or a situation where...
July 29, 2014 at 5:06 am
matt6749 (7/23/2014)
I think it's ok because the data is not mission critical and I back it up myself also with a console app I wrote. ?
Matt,
How is your console app...
July 29, 2014 at 5:03 am
So far as I know, explicit transactions vs implicit transactions will not affect how the transaction log grows. Here are a few links to read up on.
July 29, 2014 at 5:00 am
My advice is get to know what the business currently has set up (databases, data -- the why and wherefore of it, and business rules). Then see if you can...
July 23, 2014 at 9:19 am
Mark Harley (7/23/2014)
July 23, 2014 at 8:01 am
Not to provoke debate (but I'm gonna anyway @=), I generally use surrogate Identity columns as singular, non-composite PKs because if I used natural composite keys, I'd be including half...
July 23, 2014 at 7:56 am
ChrisM@Work (7/23/2014)
At a guess, you have 741 duplicated rows, 73 triplicated, and 1 quadruplicated.
Give the man a cookie for doing the actual math work! 😀
July 23, 2014 at 7:50 am
Mark Harley (7/23/2014)
July 23, 2014 at 6:42 am
BTW...
mickyT (7/17/2014)
This query will not perform the best in 2008 as it will not use spatial indexes, however in 2012 it should use them. You will need to make...
July 23, 2014 at 6:20 am
What do the indexes on your tables look like?
July 23, 2014 at 6:19 am
Viewing 15 posts - 3,166 through 3,180 (of 9,725 total)