Viewing 15 posts - 2,266 through 2,280 (of 2,917 total)
SQL doesn't by default have an "order" to return your result set by. So when you issue a command like "SELECT Transaction_Date FROM Employee_Change", depending on various factors, you could...
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.
November 14, 2017 at 2:18 pm
You are missing some data there... or I misunderstand the request.
is the attached table the expected output, the sample input or something else? If it is the sample input,...
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.
November 14, 2017 at 1:44 pm
We actually have a similar setup where I work and it was a lot of trial and error to get thigns to work optimally.
Even after we thought we had...
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.
November 14, 2017 at 1:19 pm
I've been trying to reply to this thread all day.
I apologize for the misinformation. I did more snooping and I am definitely incorrect in what I had posted....
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.
November 7, 2017 at 3:26 pm
Possibly? I personally have not experienced that specific issue.
Are you using BIDS 2008 (inside Visual Studio 2008) to create the report? I've seen other SQL things have issues...
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.
November 7, 2017 at 7:23 am
using "copy_only" makes a backup of the tlog but it does not do a truncate of the log when it completes. According to Microsoft:
opy-only log backups (full recovery model...
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.
November 7, 2017 at 7:13 am
It will not break the log chain (which I think is your goal), but it won't affect shrinking the log file. In order to shrink the log file (not recommended)...
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.
November 6, 2017 at 2:45 pm
Are you viewing the reports in IE or some other browser? I find that in SSRS prior to 2016, it is best viewed in IE. In 2016 they made improvemnets,...
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.
November 6, 2017 at 2:41 pm
The Full backup would mark a checkpoint which is the start of the backup. Any data that exists prior to that checkpoint would be in the full backup. Any data...
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.
November 6, 2017 at 2:37 pm
That sounds like a short window for the upgrade.
What I would do is build an upgrade plan and rollback plan on paper first and then run through that on...
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.
October 24, 2017 at 2:32 pm
How'd the install go? Are you happily running SQL 2008 R2 and 2016 on the same machine?
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.
October 24, 2017 at 2:07 pm
I've not seen that before without any errors in the logs. When you look at the SQL Setup log, does it give any indication of what was updated? And using...
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.
October 23, 2017 at 8:32 am
Right... forgot about some of those things. SQL Server Browser service would be one of the things upgraded but won't harm anything with that being upgraded.
As long as you...
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.
October 20, 2017 at 4:33 pm
Yep. I'd do a full backup and since it is a VM, I'd do a snapshot as well. It is a lot faster to restore from a snapshot than a...
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.
October 20, 2017 at 4:18 pm
I would install things into separate folders. We generally install the shared stuff into the default folder (which is then separated by version) and the database files onto separate physical...
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.
October 20, 2017 at 3:51 pm
Viewing 15 posts - 2,266 through 2,280 (of 2,917 total)