Viewing 15 posts - 1,141 through 1,155 (of 2,917 total)
I'd start by checking the logs. Logs on the source and the destination servers. Both SQL and Windows logs.
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 10, 2021 at 10:08 pm
Personally, I would look at getting a reporting tool like RedGate SQL Monitor (it is what I use, I do not work for RedGate).
Now, in my mind, a failed 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.
June 10, 2021 at 5:28 pm
So since you are ordering by a column you are not using in the SELECT list, you have 3 options if you are using the DISTINCT keyword:
1 - add 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.
June 10, 2021 at 5:06 pm
If operator ID and badge ID are unique in the Operator table (ie it is a 1:1 mapping of operator ID to badge ID), then that isn't going to 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 10, 2021 at 4:21 pm
I was thinking about this and is the data accurate/valid as it is currently?
What I mean is since you are getting duplicates, that makes me think that a single badgeID...
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 10, 2021 at 2:54 pm
What is the value of the following:
string strConnection = ConfigurationManager.AppSettings["GroupStatus"];
?
My thoughts are that strConnection is connecting to MASTER or the user specified in the connection string has master as 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.
June 10, 2021 at 2:38 pm
I think first you need to understand the difference between a database snapshot and a backup. The snapshot just marks a point in time of the current database state and...
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 9, 2021 at 5:55 pm
The documentation says:
AUTO
This option allows SQL Server Database Engine to select the lock escalation granularity that's appropriate for the table schema.
If the table is partitioned, lock escalation will be allowed...
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 9, 2021 at 5:36 pm
My first step when doing the statistics time or IO related analysis is to turn off the execution plan. That is going to skew your information. I would also recommend...
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 9, 2021 at 2:34 pm
I think the easiest way is going to be by casting it to VARBINARYA(MAX) and then manually going through.
So something like this:
SELECT CAST('HELLO' AS VARBINARY(MAX))Which gives you:
0x48454C4C4F
0X...
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 8, 2021 at 8:53 pm
Was doing a bit of googling on the ACE 12 and 16 drivers and found this article:
Apparently in some versions of the driver, the file name is truncated to 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 8, 2021 at 8:21 pm
On a slightly different note, I would be hesitant about using the MONEY data type as it is an approximate data type. NUMERIC is likely going to be a better...
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 8, 2021 at 6:12 pm
quick google:
Linked servers can use remote logins too.
Here is how to add a remote login:
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 8, 2021 at 6:04 pm
In the end, it REALLY depends on what you want to capture. What data is interesting to you and will save your bacon in the event something seems wrong. Can...
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 8, 2021 at 5:59 pm
I would check the source tables (scans and seeks) as the starting point for tuning. Check the estimates vs actuals at the table level as that is where statistics updates...
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 8, 2021 at 5:46 pm
Viewing 15 posts - 1,141 through 1,155 (of 2,917 total)