Viewing 15 posts - 2,206 through 2,220 (of 2,917 total)
Can you post your query?
Looking at the screenshots the first result set shows row 91 and the second result set shows row 1. Since no row in data set 2...
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 22, 2019 at 9:18 pm
As a crazy thought, what happens if you try opening the error log file outside of SQL? With the new instance you can shut it down and have a look...
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 15, 2019 at 9:18 pm
Welcome to the forum and to SQL Server!
So looking at your queries, my understanding is the first one is adding columns to an already existing table. That one looks good...
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 14, 2019 at 9:58 pm
I have been working as a DBA for about 8 years (roughly) and I don't see the "light" at the end of the tunnel for becoming a Sr. DBA anywhere...
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 14, 2019 at 9:35 pm
I just realized I misread that configuration... it isn't 122 GB of memory, it is 12.2 GB of memory.
Depending on database size, that may be too small, but I'd still...
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.
April 23, 2019 at 9:45 pm
When you say a "slow server", is it every query that is slow? Is it a specific stored procedure or view that is slow or everything you do on 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.
April 23, 2019 at 9:00 pm
This may be an unpopular opinion, but I feel that this is more of a user training issue than a forum software issue.
If the end user uses the tool 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.
April 22, 2019 at 9:30 pm
Looking at the query, your @Time1 and @Time2 variables are going to show the time difference between how long it takes to call GETDATE(). And that time is going 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.
April 10, 2019 at 10:09 pm
I have a question about this:
When it gets suddenly slow, are you able to reproduce the slowness on your machine from SSMS?
What I am thinking is 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.
February 12, 2019 at 9:31 am
Another way to get this inventory is through RedGate SQL Monitor.
Not sure where they scrape their data from, but in version 8 (possibly sooner) they have an Estate tab...
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.
January 22, 2019 at 12:14 pm
As a thought, is your .NET up to 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.
August 15, 2018 at 9:42 am
I quite enjoy being a DBA overall. Every now and then I get hit with odd problems that make me think and hopefully I have time to think and resolve...
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.
August 10, 2018 at 8:42 am
Have you tried using the "right" and "left" functions? something like:
LEFT(RIGHT(<string>,6),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.
August 8, 2018 at 11:39 am
Can you post some DDL? The above is all just my opinion on what you should do.
Looking at the sample data, it looks like you'd just need to look at the status column and member email. the other columns sshouldn't matter.
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.
August 3, 2018 at 2:01 pm
This sounds like a DNS issue to me. Your DNS server is likely pointing to the old address or prioritizing the old NIC.
You will want to update the DNS...
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.
August 3, 2018 at 12:36 pm
Viewing 15 posts - 2,206 through 2,220 (of 2,917 total)