Viewing 15 posts - 3,151 through 3,165 (of 9,720 total)
GilaMonster (8/15/2014)
Evil Kraig F (8/15/2014)
August 16, 2014 at 8:13 am
Evil Kraig F (8/15/2014)
Brandie Tarvin (8/15/2014)
August 16, 2014 at 8:11 am
I'm thinking about the original post and I think I'd ask questions like this:
It's Wednesday. 3 people walk up to your cube. One is from the QA team, one is...
August 15, 2014 at 12:37 pm
GilaMonster (8/11/2014)
paul.knibbs (8/11/2014)
Jeff Moden (8/9/2014)
With the understanding you have of that counting problem and the additional understanding that I don't ask "trick" questions or questions based on trivia, explain or...
August 15, 2014 at 12:29 pm
Have you tried connecting to SQL without the ",<portnumber>" yet?
At my workplace, we had an issue way back when where the port number was required until our networking team fixed...
August 15, 2014 at 12:18 pm
Igor Micev (8/15/2014)
Brandie Tarvin (8/15/2014)
What about DDL Triggers? Could those rollback any attempt at renaming a database?
I have already tried with a DDL trigger on instance level to catch the...
August 15, 2014 at 12:13 pm
Why not just use a LEFT OUTER JOIN to check for existence?
DECLARE @LogId INT, @L INT, @E INT;
SET @LogId = NULL;
SET @L = 17;
SET @E = 9999;
INSERT INTO t...
August 15, 2014 at 12:11 pm
What about DDL Triggers? Could those rollback any attempt at renaming a database?
August 15, 2014 at 12:03 pm
I'm not even seeing the logic between the 3 columns of the original data and the rows that appear to have more than three values.
Please post your table DDL and...
August 15, 2014 at 12:01 pm
lptech (8/15/2014)
At least in SQL Server 2014, SSIS packages all won't have to be modified
YIKES! I forgot about mentioning this. NAS shares, SSIS packages saved on the File level...
August 15, 2014 at 8:59 am
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
Viewing 15 posts - 3,151 through 3,165 (of 9,720 total)