Forum Replies Created
Viewing 15 posts - 1,966 through 1,980 (of 2,917 total)
-
Reply To: What Are Your Thoughts on Sections 302, 401, and 409 regarding Data Integrity
My opinion (I work at a company that is SOX compliant), if you do your best to follow SOX compliance as best as you understand it and you pass 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. -
Reply To: FTI Query over Joined tables is slow
A few thoughts here. First, update statistics if auto update statistics is not on. And it may even help if that is on.
Second thought - I think you forgot to...
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. -
Reply To: Help in finding re-admission summary counts from detail data.
I think the result I posted in my second edit should work with the potential for a gap. I think the only thing that you may want to add would...
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. -
Reply To: Help in finding re-admission summary counts from detail data.
I realized the mistake. Actually multiple mistakes on my part.
First mistake I did was assumed that I could just add up the number in the xxxDayReadmit column, but you want...
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. -
Reply To: Odd Connection / Authentication Errors
Too bad it wasn't a windows update patch, but also good that your servers are all up to date patched.
As a thought - when did this problem start? Could 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. -
Reply To: Help in finding re-admission summary counts from detail data.
How does this code look:
CREATE TABLE [#test1]
(
[IDColumn] INT
, [MemberID] INT
, [Startdate] DATE
, [Enddate] DATE
, [7DayRedamit] BIT
, [30DayRedamit] BIT
, [60DayRedamit] BIT
,...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. -
Reply To: FTI Query over Joined tables is slow
Looking at your execution plans, both of your FTI's are pretty quick. 0.028 seconds on one of them and 7.080 seconds on the other. The slow part is your clustered...
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. -
Reply To: Odd Connection / Authentication Errors
If these are VM's, it could be how the VM host is handling the memory. Balooning (in VMWare) I think can cause odd issues.
It is weird that nothing is showing...
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. -
Reply To: FTI Query over Joined tables is slow
Might help to see the execution plan... Without that we are really just guessing. Maybe SQL isn't using the full text index? Maybe statistics are out of date so estimates...
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. -
Reply To: Duplicate email being sent from Report Server
Just to confirm with you - Power BI is sending 2 emails; it ISN'T that SSRS is sending one and Power BI is sending one, correct?
This should be easy to...
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. -
Reply To: What's different about configuring a Windows cluster in Azure
I personally haven't done this, but a quick google brought this up:
https://officeline.gr/2020/04/04/azure-failover-cluster-with-shared-disk-step-by-step/
It explains how to set up a failover cluster with shared disk in a step-by-step process.
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. -
Reply To: Odd Connection / Authentication Errors
To me, my first thought when I start getting timeout errors is that it is something in the network stack.
If you are connecting to a SQL ALIAS instead of 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. -
Reply To: How to get at value?
Glad it works!
Also, figured out why I needed it lowercase as I was confused on that too, it was just how it worked for me. The URL in the XML...
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. -
Reply To: How to get at value?
My output looks different than yours for sure:
I ran the following:
DECLARE @xml XML = '<?xml version="1.0" encoding="utf-8"?>
<SharedDataSet xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/shareddatasetdefinition">
<Description />
<DataSet...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. -
Reply To: Encryption Level Problems - Can't Build after Checkout
As a thought, when you ran dtutil.exe, is %f the FULL path to the file or the relative path? May want to remove the "/quiet" option and just see what...
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.
Viewing 15 posts - 1,966 through 1,980 (of 2,917 total)