Viewing 15 posts - 6,736 through 6,750 (of 59,070 total)
That was the exact scenario I had with the log file blow out that I described. It was an ever increasing index that suffered only from DELETEs. It wasn't an...
July 17, 2020 at 4:28 pm
Thanks for taking the time to explain that, Julian.
Shifting gears a bit, since none of the VARCHAR(3500) columns are actually worth a hoot in an index, you might want to...
July 17, 2020 at 3:35 pm
Yes I was intending to convert to sqlserver.
I managed to figure this out. Ts_summary was a custom function. All sorted.
Thanks.
Awesome... can you post the code so we can do...
July 17, 2020 at 3:01 pm
Hi
I have below query.
Select EmpCode,Deptt,EmpName from Employee
I want if Date is 16th then record from Day 1 to Day 15 should get displayed.
If Date is 1 then record's from...
July 17, 2020 at 2:57 pm
Totally agree with Grant. Insitu code will run differently than dedicated code a whole lot of the time.
July 17, 2020 at 2:51 pm
We will have backup server maintenance with the outage between 15mins to 1 hr. So there won't be log backups during that time and business is aware of that....
July 17, 2020 at 2:49 pm
It can also easily cause extreme usage of the log file. For example, I had (it's grown since the test) a 146GB Clustered Index that was only 12%...
July 17, 2020 at 2:44 pm
Shifting gears a bit, Julian... I'm curios as to what you would be putting into the OldValueDescription and NewValueDescription columns. I've not seen anyone have such columns on this type ...
July 17, 2020 at 2:37 pm
... and it also comes up with correct answers.
(As Brian admitted in a later post) my solution did provide the correct answers!
It's definitely on the right track and does...
July 17, 2020 at 1:07 pm
Ah... bugger. I thought one of Steve's submittals worked just as well but it misses correct output on some of the items I had in my test table and so...
July 17, 2020 at 12:47 pm
Just to be sure, are you trying to convert Oracle to SQL Server?
July 17, 2020 at 12:46 am
Heh... this is why I hate tests. While I knew the correct answer you were expecting, it's not actually the correct answer. It can be done through a stored procedure...
July 17, 2020 at 12:25 am
Since you aren't actually using the count for anything other than measuring if the count is greater than "0", just do a check for existence instead of a count... that'll...
July 17, 2020 at 12:19 am
I'll get quite a bit of argument from a lot of folks but I've found that REORGANIZE frequently does NOT do a very good job at fixing page density problems...
July 16, 2020 at 11:40 pm
Totally agreed on the Modified_By and Created_By columns being fix length like an INT column with an FK but, if an application has a generic login, that would mean that...
July 16, 2020 at 11:17 pm
Viewing 15 posts - 6,736 through 6,750 (of 59,070 total)