Viewing 15 posts - 8,431 through 8,445 (of 59,078 total)
I don't share your optimism nor point of view here, Steve. We've seen MS remove functionality from SSMS with absolutely no warning. We seen MS publish cumulative updates that that...
November 2, 2019 at 1:20 am
This reminds me of a certain well known personality that denounces the use of engine-proprietary functionality because someone somewhere someday may have to use the code in another RDBMS and...
November 1, 2019 at 6:45 pm
I guess I don't understand why anyone would write software based on the knowledge of novices. If it's important for a novice to be able to maintain something a bit...
November 1, 2019 at 5:38 am
Eirikur Eiriksson, sorry to hear about your crystall ball. I hope it cristallizes again. Perhaps with the hourglass bbq of Steve.
This is how it looks like, kind...
October 31, 2019 at 7:47 pm
by the way - has anyone twigged that permission management for SSIS is a pile of garbage?
Not in that vein but I have said that it's an unnecessary expansion...
October 31, 2019 at 7:42 pm
If I can ever get SSIS to work, I'm hoping to start using it, I used to love bcp, other forms of bulk loads etc, but our systems got...
October 31, 2019 at 2:11 pm
SSIS is not as bad as people make out, purely because people don't know how to use it. I think DTS was better (but im an old guy) -
Spot...
October 31, 2019 at 1:44 pm
I once told a friend, I aim to please... I sometimes miss but I'm always aiming. I'm humbled by your comment. Thank you for the very kind feedback.
October 31, 2019 at 1:19 am
This should not be a problem at the database tier in your tiered architecture. Do this in the input, before it even gets near the tables. You'll find ETL...
October 30, 2019 at 6:54 pm
Or re-create the index so that it allows multiple NULLs but no other dups.
Apparently, the morning coffee hasn't kicked in for me yet today... what would the CREATE INDEX...
October 30, 2019 at 5:47 pm
What is the datatype of the original data you want to convert?
October 30, 2019 at 5:39 pm
Haha Jeff. I do spend a lot more time than I would like writing managed code. But this is the same third party vendor's code who has this as...
October 30, 2019 at 5:34 pm
Oh yah. Had this. Only to be told by the Lead Developer that its a 'best practice' and that 'I wouldn't understand'
So, I made my case and then let...
October 30, 2019 at 4:02 pm
best of luck - if you have the chance, try both methods, ignore us all and go with the one that best suits you
Ditto dat!
October 30, 2019 at 3:49 pm
Before and after backup log, can you run this command and post the result here?
dbcc sqlperf(logspace)
this command could return the physical and logical size of actual log. Sometime, the...
October 30, 2019 at 3:44 pm
Viewing 15 posts - 8,431 through 8,445 (of 59,078 total)