Viewing 15 posts - 2,176 through 2,190 (of 2,917 total)
Can you have duplicate OperatorID's in the Transaction table?
try running the following query on the Transaction table:
WITH duplicateCheck AS
(
SELECT OperatorID, count(OperatorID) OVER (PARTITION BY OperatorID) AS OperatorCount
FROM...
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 9, 2019 at 7:57 pm
I still see that link taking me to an article about Data Compression Double Take which seems different than SQL and T-SQL for Beginners or is that where 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 8, 2019 at 5:37 pm
With the sample hourly rate being 10,000, I was just trying to make sure I picked a value that was substantially large enough to cover almost everything possible in 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.
July 5, 2019 at 4:21 pm
Do you need this to be "real time" data or can you load the data into some system (Hadoop, SQL Server, Oracle, etc) on a nightly basis?
I am not 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.
July 5, 2019 at 2:54 pm
I would not recommend putting an excel file on here. Not many people will nab that as there is inherit risk of downloading random files from the internet...
I would just...
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 4, 2019 at 7:05 pm
I think all you need to do is change how it is formatting the cell. When I paste that in with a straight paste (no paste special or anything like...
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 4, 2019 at 6:59 pm
Without seeing the data or having any idea of what things look like, what I would do is something like this for your case statement:
CASE
...
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 4, 2019 at 6:51 pm
I think the link in the OP points to the wrong post?
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 4, 2019 at 6:43 pm
The problem with trying to manage 1,2,3 as well as a,b,c is what happens when you hit 1,a,1? One solution could be to just sign each letter a numeric value...
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 28, 2019 at 11:19 pm
I see a few things that will make this tricky. The first being that the datetime column has no time. So how do you know that m5 went from 3...
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 28, 2019 at 6:50 pm
With them being physical disks, I think that setup looks like it should be good.
Your next question about the types of disk (SSD or Other) and RAID, that really depends...
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 27, 2019 at 3:29 pm
Are your disks on a SAN or physically attached to the machine?
SAN disks in a good SAN should be set up in RAID by the SAN controller and should be...
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 26, 2019 at 10:03 pm
If you do go the SSIS route, there are a few things to watch out for:
SSIS will...
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 26, 2019 at 6:07 pm
I am not aware of any archiving tools that work on generic data. And designing one would not be the most fun thing to do as each table can be...
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, 2019 at 10:05 pm
Did you look at the execution plan to ensure that SQL was using the full text index?
a nice read on CONTAINS vs CONTAINSTABLE is here:
http://www.qdpma.com/CBO/FullTextQueryPlans.html
If it IS being used, my...
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, 2019 at 9:01 pm
Viewing 15 posts - 2,176 through 2,190 (of 2,917 total)