Viewing 15 posts - 2,191 through 2,205 (of 2,919 total)
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
That is true. I suppose then it all depends on what you define as a "sequence". If having the "Sequence ID" reset itself is a common occurrence, AND if resetting...
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 8:44 pm
To avoid the "0" and negative problem, change it from using the sequence number to using the event record ID. In the example you have above, it looks like that...
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 14, 2019 at 9:52 pm
I think it depends on what you want in the app. If you are looking for an app that will load a web page in a specialized frame that prevents...
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 14, 2019 at 9:09 pm
You could try turning on the legacy cardinality estimator. It'll almost be like running it without doing the upgrade unfortunately, but might be able to narrow things down a bit.
Since...
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 13, 2019 at 9:40 pm
My opinion, that is one of those "it depends" problems. Is the timeout in code execution OR is the timeout in the connection?
If the timeout is in code execution, 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.
June 12, 2019 at 7:33 pm
I think in this case "best" is a relative term.
There are several ways to do it. long character separated string values, key value pairs, very wide tables with non-descript column...
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 12, 2019 at 7:22 pm
It depends entirely on the language you are working with. As this is SQL Server Central, I am assuming you are working in SQL Server.
The way I would do this...
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 7, 2019 at 7:31 pm
As a thought... I wonder if MAYBE the user is a member of a group that has deny permissions on a system object but you also granted the permissions explicitly.
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.
June 6, 2019 at 5:21 pm
We use it to transfer realtime data from one system to another. Mostly as a way to break reliance on linked servers where possible.
We pull data from system X into...
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.
May 31, 2019 at 9:54 pm
how about this:
CAST(xmldata.value('(ns8:date)[1]','DATETIMEOFFSET') AS DATE) AS RDATEBasically get the value in it's original format (DATETIMEOFFSET) and then cast that to a DATE.
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.
May 31, 2019 at 9:15 pm
You are missing an "END" after your BEGIN.
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.
May 28, 2019 at 7:21 pm
Putting in the restriction on delete isn't a bad idea, but depending on the permissions the user is granted, it may not be enough. what if they drop that trigger? ...
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.
May 24, 2019 at 6:16 pm
I should add that there is a little bit of risk with SQL injection depending on what is in the code.
For example, the Query that is being executed 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.
May 24, 2019 at 3:51 pm
Viewing 15 posts - 2,191 through 2,205 (of 2,919 total)