Viewing 15 posts - 1,711 through 1,725 (of 2,917 total)
Thanks for the followup and solution!
That is weird about the syntax... I was using your original syntax when I tested it and it worked for me. But maybe it was...
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.
July 21, 2020 at 4:01 pm
Maybe my eyes are playing tricks on me, but what is the difference between B and C?
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.
July 21, 2020 at 3:39 pm
Heh... I'm still waiting to hear back from the OP with an answer to my question! 😉
It was a bit of a vague question. Is the query only run...
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.
July 17, 2020 at 9:49 pm
I signed up! I'm always curious about new DBA tools. Survey was a bit vague with some things. Like do you prefer the GUI or CLI. Would you consider writing...
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.
July 17, 2020 at 8:08 pm
XML parsing is a common one that is difficult to do for most, but for some people, XML parsing is trivial.
Trivial? Yikes.
LOL... for me it definitely is not, but...
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.
July 17, 2020 at 7:29 pm
You could download adventureworks database and just write some complex queries against that?
But it depends on what you consider complex. I have some stored procedures at my workplace that are...
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.
July 17, 2020 at 7:11 pm
Where I work, I have 60+SQL instances with roughly 5 databases per instance. Not an ideal setup with 3 physical servers, but it works for what we need.
We have our ...
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.
July 17, 2020 at 5:04 pm
Just to confirm, if the date was the 15th, would you want it from the 28th/29th/30th/31st (depending on the month) to the 14th?
Basically, are you wanting it from 15 days...
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.
July 17, 2020 at 3:08 pm
ReportServer and ReportServerTempDB are databases used exclusively by SSRS. If you are not using SSRS, you don't need those.
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.
July 17, 2020 at 2:49 pm
To take a different approach, it depends on what you are trying to capture with the audit trail. Do you care about who and when each and every change was...
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.
July 17, 2020 at 2:48 pm
My first step - grab an execution plan. Have a look under the hood at what is happening.
But I don't think those 2 queries are doing the same thing. Having...
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.
July 16, 2020 at 9:56 pm
My preference is any production level server, maintenance is done in a controlled maintenance window outside of business hours where possible.
You are giving yourself a 1 hour window to do...
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.
July 16, 2020 at 8:26 pm
Another way to check would be to run:
EXEC sp_configure
and then check if the configured value matches the running value, right? If you ran RECONFIGURE, they should match...
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.
July 16, 2020 at 2:48 pm
My approach is to do as little data manipulation on the SQL side as possible before presenting it to the end user or application. I'm not saying that it is...
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.
July 15, 2020 at 9:27 pm
I agree with jcelko here 100%.
If this table structure is not pre-defined for you, I would definitely look at doing it in at least 1st normal form. You will also...
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.
July 15, 2020 at 9:05 pm
Viewing 15 posts - 1,711 through 1,725 (of 2,917 total)