Viewing 15 posts - 1,801 through 1,815 (of 59,061 total)
@JeffModen: I wasn't trying to spam - I just search for salary comparison and that site came up showing me the levels. That's why I referenced it.
Thanks for the...
February 23, 2023 at 8:34 pm
I don't have an answer. "Bumping" this bad boy for you.
February 22, 2023 at 9:20 pm
That's handy, Michael, but we're not ready as a company to embrace the use of PowerShell. I'm going to create a new table that we can refresh via a...
February 22, 2023 at 8:53 pm
Hi, thank you for your replies.
We already have a legacy software to keep track of time/attendance. But it has some limitations.
It can monitor employee hours, absence , overtime, etc.
The...
February 22, 2023 at 7:01 pm
Thanks Jonathan. A followup question, why shouldn't care about index fragmentation on indexes which has 1000-5000 page count ? I have read somewhere or some video, i dont remember. ...
February 22, 2023 at 6:46 pm
Just to be sure....
For the love of all that is holy in SQL Server, do not give individual users privs to execute xp_CmdShell in an unsupervised manner. Have them write...
February 22, 2023 at 6:08 pm
Awesome and thank you kindly for the feedback. Nicely done on your part, as well.
February 22, 2023 at 5:12 am
If this isn't a prelude to spam (like I think it may be), then don't target salary... target what you like to do because you're going to have to do...
February 22, 2023 at 2:09 am
Right - but only the checksum column is keyed. With the number of collisions in checksum I would think you would hit a point of maximum entropy in index...
February 22, 2023 at 12:50 am
I am skeptical that pre-fragmenting the index to 20% fragmentation with the 80% fill-factor is preferable to a relatively small amount of fragmentation that would result from changes to...
February 21, 2023 at 5:20 pm
You'll find that logical fragmentation just doesn't matter that much. Since you lowered the FILL FACTOR as you would for a Random GUID (which the BINARY CHECKSUM resembles in nature),...
February 21, 2023 at 3:02 pm
This is the code which is creating the problem (bridgid is bigint ,remaks is varchar(250) status smallint) in both the tables mentioned below. INSERT INTO KKR (BridgID,Remarks,Status) SELECT DISTINCT...
February 21, 2023 at 2:53 pm
I did some experiments with BINARY_CHECKSUM and I think that'll do for me and for my needs, it's good enough and simple to implement.
Also, if that solution works for...
February 21, 2023 at 2:34 pm
I did some experiments with BINARY_CHECKSUM and I think that'll do for me and for my needs, it's good enough and simple to implement.
That's not going to help you...
February 21, 2023 at 2:28 pm
Thank you very much. The "MAX" worked.
Awesome. Now, check the MAX(LEN() of the column so you can right-size it. It may still need to be a MAX but maybe...
February 21, 2023 at 12:08 am
Viewing 15 posts - 1,801 through 1,815 (of 59,061 total)