Viewing 15 posts - 796 through 810 (of 2,917 total)
EDIT - disregard my post. Everything I said has already been in previous replies.
If memory serves, SQL Server presents the date in the format that is configured on the server. ...
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.
December 1, 2021 at 8:52 pm
Are you trying to install SQL fresh OR is this an upgrade of SQL 2012 to SP3? Have you had SQL Server 2012 installed on that machine (and potentially 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.
December 1, 2021 at 8:03 pm
again, I would check the result of your print statement and see what is actually being executed and where the error likely is.
Running your query with the exec commented out...
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.
December 1, 2021 at 7:08 pm
I would start by taking out that "EXEC" line and use the PRINT line to see what is actually being run. You are comparing OR inserting an NVARCHAR with an...
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.
December 1, 2021 at 6:10 pm
At my workplace, we actually use SSIS to pull data across from "live" systems into our reporting database. SOMETIMES it is a 1:1 copy of the data, sometimes we transform...
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.
December 1, 2021 at 5:20 pm
That is on you to decide if it is a problem or not. If it is, then you are going to need to come up with another solution. If it...
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.
November 30, 2021 at 6:00 pm
To add to what everyone else has said, network performance could be a bottleneck too. Those tables don't look like they hold that much data in terms of MB 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.
November 30, 2021 at 5:34 pm
I think my representation of SSIS was a bit off. What I meant was that SSIS would be used for the data pull from source, the transform of the data...
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.
November 30, 2021 at 4:41 pm
Bruin's solution works with the exception that it doesn't capture error messages from the scripts. But what you COULD do is a modified version of Bruin's script, but it does...
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.
November 30, 2021 at 4:03 pm
Personally, I agree with you Rod. I think that report writing is more of a "business analyst" role than a DBA or DB Developer role. BUT that being said, 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.
November 29, 2021 at 6:54 pm
I was just reading the error message as it says "The process encountered a deadlock and is retrying". This is the expected behavior.
Now, as for long running blocking causing deadlocks,...
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.
November 29, 2021 at 3:49 pm
My opinion - I do 1 solution per folder in SSRS on a per-subfolder basis.
What I mean is if my SSRS layout is like:
home/
-- Inventoy/
-- invReport1.rdl
--invReprot2.rdl
-- Warehouse/
--WarehouseReport1.rdl
I would have 1...
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.
November 29, 2021 at 3:12 pm
I would review the logs. See why it can't execute that stored procedure and possibly find a maintenance window where you can run sp_replrestart for a long period of time...
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.
November 26, 2021 at 8:33 pm
That sounds like your backups are encrypted. What certificate did you use to back up the database? I expect you didn't restore that certificate onto the secondary system.
SSC actually has...
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.
November 26, 2021 at 8:26 pm
Had another thought on this - since you don't want to do updates on the SQL instance, why not look at putting it in Azure in a SQL Managed instance...
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.
November 26, 2021 at 7:34 pm
Viewing 15 posts - 796 through 810 (of 2,917 total)