Viewing 15 posts - 91 through 105 (of 2,854 total)
Multiple tools means more systems to administer and more tools to patch which also means more man-hours to keep your environment up to date.
I much prefer to get all of...
June 20, 2025 at 10:05 pm
Merge is generally a slow operation. I think if you are wanting fastest performance, your best bet is to grab all of the delta's that are going to be INSERTs...
June 20, 2025 at 9:48 pm
You say that he doesn't have cases where he would have 3 or more values needed for calculating the average, but that is current state. What happens in 5 years?...
June 19, 2025 at 9:42 pm
Without seeing your data (or sample or DDL or DML), I'm just guessing here but I see this as a multiple problem thing.
First you want to know if you need...
June 19, 2025 at 6:51 pm
My advice - sanitize the data before import. Use Excel to get the dates into one standard format (manual approach) if it isn't too time consuming. If it is too...
June 19, 2025 at 6:20 pm
Just want to add that even with 1 big server, I still like to have a minimum of 2. That way you get failover. If the server/VM needs a reboot,...
June 16, 2025 at 10:27 pm
Possibly a silly question Grant, but could you do that without the CTE? What I mean is something like:
SELECT (DATEPART(hh, sod.ModifiedDate) +
DATEPART(mi, sod.ModifiedDate) +
DATEPART(ss, sod.ModifiedDate)...
June 10, 2025 at 9:21 pm
Are you able to reproduce this on a test system? If so, I would do so and review the execution plans after each execution.
One question for you though - how...
June 10, 2025 at 9:16 pm
My first thought is "why?"... but if that is your odd requirement, and I am understanding your request correctly (INSERT all possible values in hh:mm:ss:ms format), the easiest way I...
June 9, 2025 at 10:28 pm
I ru ln CHECKDB nightly on my systems. I want to find out about works early. But it really depends on your risk tolerance.
September 16, 2024 at 3:14 pm
I just wanted to point out that IF this is installed on your primary use computer, I would strongly encourage you to configure the max memory to a lower value...
September 13, 2024 at 7:57 pm
My opinion - registry changes for SQL Server configuration are only going to give you grief and break things long term.
Use the SQL configuration manager to check if TCP/IP is...
September 13, 2024 at 3:33 pm
Since you MUST prefix with "NP:" that means you are using named pipes to connect. I've never done that before. I ALWAYS use TCP/IP to connect to my SQL instances...
September 12, 2024 at 8:39 pm
I just wanted to add to ratbak's post recommending indexed views - these are less useful on SQL Standard. SQL Standard doesn't automatically use an index on a view, you...
September 12, 2024 at 8:32 pm
Just to add to what Phil said, it is REALLY hard to guess what is wrong without knowing what the error is. BUT if I had to guess on the...
September 12, 2024 at 8:20 pm
Viewing 15 posts - 91 through 105 (of 2,854 total)