Viewing 15 posts - 1,486 through 1,500 (of 2,917 total)
I am not 100% sure, but I am about 95% sure that that is not possible and would be a HUGE performance hit to go that route anyways. 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.
November 19, 2020 at 2:56 pm
Locks are a required part of SQL Server. You wouldn't want 2 queries updating a single piece of data at the exact same time. Much better for them to run...
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 18, 2020 at 2:28 pm
Just to confirm - you are NOT reindexing anything during that job step, right?
I just found this post:
https://www.sqlservercentral.com/forums/topic/sql-job-fails-giving-message-2528
which says that message 2528:
"The message 2528 is what DBCC Reindex always outputs"
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 17, 2020 at 9:45 pm
When you say it is not returning a number, what is it returning?
Also, in your code, you are declaring @newID as a VARCHAR and then setting it to the result...
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 16, 2020 at 2:38 pm
My only guess about it is readability and habit from other languages.
What I mean is some coding languages take a new line as being the end of that statement so...
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 16, 2020 at 2:29 pm
A nice easy one for a Monday morning! BUT a very important one to know about when working with AG's.
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 16, 2020 at 2:19 pm
My method of experimenting is to get a database that has some sample data I can play with and just go at it.
We had a long blocking query a few...
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 13, 2020 at 9:57 pm
My first step - check the logs. Not JUST for the error you reported here, but the lines before and after that. I suspect that there is a bunch of...
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 12, 2020 at 8:44 pm
If you have a short list of languages and don't mind a bunch of SUM and CASE statements, you could get by using those
Such as:
DECLARE @tmpTbl TABLE
(
[USERname]...
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 12, 2020 at 8:11 pm
Since this sounds like interview or homework (as others indicated), I think you are likely not to get 100% help. You are asking a lot and giving very little.
Starting with...
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 12, 2020 at 7:37 pm
Looking at that chunk of powershell, I don't see where it is looking for the name "Sheet1". BUT if you did want to check for that, I would possibly have...
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 9, 2020 at 7:20 pm
If you want to throw the query into a variable, you need to double up all of your quotes. So all ' characters become ''. All '' become ''''. 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.
November 6, 2020 at 9:06 pm
You can force the parameters to have default values or you can hide some of them or you can adjust the number of rows and columns. You could have 10...
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 5, 2020 at 9:40 pm
Those are kind of my go-to's.
One thing that could be an interesting check would be how much data is being transmitted across that connection at the time the query 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.
November 5, 2020 at 9:23 pm
Execution plans would be my starting point. make sure that the queries are all doing the same thing.
Also make sure all queries are getting the same results.
Then I'd check wait...
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 5, 2020 at 8:24 pm
Viewing 15 posts - 1,486 through 1,500 (of 2,917 total)