Viewing 15 posts - 5,986 through 6,000 (of 59,070 total)
fnTally function is not available. Can you help me? - I'm intended to get Thursday of a month which is followed with 2nd Tuesday
See above.
Steve, if you're going to...
November 30, 2020 at 3:43 pm
Sorry... had to take down this post because I found a bug in the formula.
November 30, 2020 at 3:41 pm
I think he came up with this from watching movies and TV shows. "Office Space" is one example of employees doing bad things to get back at the company.
Yowch......
November 30, 2020 at 2:50 pm
25 years in IT. Laid off: 2. Brought back at 20 times the old salary: 0.
20 Times the salary??? How much did that amount to?
November 30, 2020 at 2:49 pm
I'm thinking "Ok... Catch 22". IMHO, the more quickly you move, the more likely you are to make a mistake and that's not limited to what most people consider to...
November 30, 2020 at 1:48 am
Great question, Steve. I have to admit that I had to look this one up. Now I know what my next task will be... determine the ramifications of that file. ...
November 30, 2020 at 1:19 am
The things you mention don't typically cause the crazy increase you speak of. And I just told you a "good way" to find it so someone can fix it. 😉 ...
November 30, 2020 at 1:08 am
Frankly, you're still totally missing the point of q, thus your qs are misdirected. Performance does not matter here, since the company you're interviewing for is a commercial business,...
November 30, 2020 at 12:58 am
I totally agree with you that a lot of half full pages is bad for disk storage, memory consumption and reading a lot of extra pages due to the...
November 29, 2020 at 10:39 pm
I provide the table structure, that's it. They are in SSMS session, so they can use whatever SSMS tools there are to view that structure.
Ah... therein lies...
November 29, 2020 at 10:10 pm
Crazy increases in size are normally due to a query that has one or more "accidental Cross Joins" in the form of "Many-to-Many" results. They typically contain a DISTINCT or...
November 29, 2020 at 9:45 pm
I provide the table structure, that's it. They are in SSMS session, so they can use whatever SSMS tools there are to view that structure.
Ah... therein lies the key. ...
November 29, 2020 at 9:22 pm
I have a major problem with ego-maniacs that like to hijack meetings. Which is what we had here. I asked for a few practice tests so I can prepare...
November 29, 2020 at 9:18 pm
Jeff - I am going to create another thread on this issue. Could you please do me a favor and NOT participate? I would really appreciate it.
Your original reply...
November 29, 2020 at 5:34 pm
@Lord Slaagh ,
You asked "Jeff - Do you have any challenge queries that you can provide for practice?"
Yes I do. Anywhere from "pretty simple" to "OMG! How can this possibly...
November 29, 2020 at 3:57 am
Viewing 15 posts - 5,986 through 6,000 (of 59,070 total)