Viewing 15 posts - 1,321 through 1,335 (of 2,917 total)
My company is actually doing exactly what you say! The DBA role is slowly becoming less relevant at work as more and more tools are being migrated to the cloud. ...
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.
March 16, 2021 at 8:46 pm
I did test it (on the screen) in Windows 10, with SSRS 2016 and Edge version 89.0.774.54 (Official build) (64-bit) as well as chrome Version 89.0.4389.90 (Official Build) (64-bit).
Now 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.
March 16, 2021 at 7:44 pm
First step, make sure your web browser is fully up to date.
I just tested this in both Chrome and Edge (both at the latest release version) and zooming in or...
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.
March 16, 2021 at 6:02 pm
My advice - ask your license provider about that.
CAL vs Core really depends on your scenario and setup and the deals your licensing provider can get you.
Plus, in the event...
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.
March 16, 2021 at 5:04 pm
If you need to compare the 2, you will either need to do it manually (bleh) or with a tool. Most tools that manage this are of the paid variety. ...
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.
March 16, 2021 at 2:54 pm
Fun thing - it makes no difference if you use UNION or UNION ALL. Changes the result set for sure, but the estimated execution plan remains the same. Performance with...
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.
March 16, 2021 at 2:35 pm
Happy to help.
There are advantages and disadvantages to all of the approaches. linked servers can help reduce data duplication. SSIS can allow you to transform the data as you go. ...
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.
March 15, 2021 at 10:18 pm
What error do you get and what is your expression for the visibility on the column?
I think you are going to be using the IIF and OR functions for the...
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.
March 15, 2021 at 6:12 pm
Fun thing you can look into - windowing functions.
For example, if you wanted to SUM Time1 ONLY by the EmpNo (as in your first query) and not by department, job,...
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.
March 12, 2021 at 9:50 pm
Rather than having us jump through the blogs and guess on the syntax for your UPDATE statement (and the probable typo), could you post the TSQL you used 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.
March 12, 2021 at 5:51 pm
That error "SSL Security Error" is the problem for sure. Best guess - the old driver is using a weaker encryption method than the new one so SQL is refusing...
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.
March 12, 2021 at 3:48 pm
My first thought - what error are you getting in the application and in your logs (SQL and Windows)?
My guess, without seeing your system and setup, is 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.
March 12, 2021 at 3:16 pm
That part is easy then - Run the script.
The script is just plain TSQL used for re-creating the object. It can be opened in SSMS or SQLCMD and run against...
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.
March 12, 2021 at 3:02 pm
If you want the data as well as the table, that method won't work. If you ONLY want the table schema and don't care about the data, that will work...
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.
March 11, 2021 at 9:17 pm
There are multiple ways, but I like the "don't reinvent the wheel" approach.
Get a SQL Monitoring solution in place. It will tell you about blocking, deadlocks, long running queries, etc...
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.
March 11, 2021 at 5:00 pm
Viewing 15 posts - 1,321 through 1,335 (of 2,917 total)