Viewing 15 posts - 151 through 165 (of 2,917 total)
Just to confirm, you get that error when trying to PREVIEW the report on your local computer, correct? If so, are you using the correct VS version for the SSDT...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 25, 2025 at 4:35 pm
I've personally never used between and it is because of this exact QOTD - I can never remember for certain if it is inclusive, exclusive, or a mix and I'd...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 24, 2025 at 3:14 pm
I have also used heaps when the data has no real business value but someone requested the data to be captured because it may be needed one day by someone....
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 24, 2025 at 2:44 pm
My big takeaway from your article was this bit:
But perhaps the most valuable insight was this: before touching MAXDOP, fix the query. In our case, adding a missing index and...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 23, 2025 at 8:50 pm
With the ad hoc queries as needed, a good monitoring tool should be able to capture some of those too. RedGate Monitor (formerly SQL Monitor) allows you to capture custom...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 23, 2025 at 7:04 pm
My advice - don't trust random people on a forum - trust the source. Check the Microsoft Docs:
Upgrading to 2022 requires a min version of 2012 SP4.
Now, that being said,...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 23, 2025 at 6:56 pm
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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?...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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,...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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)...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
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...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
June 9, 2025 at 10:28 pm
Viewing 15 posts - 151 through 165 (of 2,917 total)