Viewing 15 posts - 1,621 through 1,635 (of 2,917 total)
That one I am completely stumped on then.
Just to be sure, auto-shrink isn't turned on on any database, right? My thoughts here are that something is growing and shrinking when...
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 11, 2020 at 5:04 pm
Ok, that is a weird one... I have no good thoughts on why that would be happening nor why adding an explicit transaction would help.
When you say "randomly failing", 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.
August 11, 2020 at 3:38 pm
Could it be a bug in the unit test? What I mean is if the unit test is checking the number of active transactions and sometimes it comes back 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.
August 11, 2020 at 2:33 pm
Not sure if it is the best way, but I just set up a second job that starts at the same time as the one I wanted to monitor 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.
August 11, 2020 at 2:27 pm
If you look at the code behind the view INFORMATION_SCHEMA.COLUMNS, it is looking at USER objects only:
CREATE VIEW INFORMATION_SCHEMA.COLUMNS
AS
SELECT
DB_NAME()AS TABLE_CATALOG,
SCHEMA_NAME(o.schema_id)AS TABLE_SCHEMA,
o.nameAS TABLE_NAME,
c.nameAS COLUMN_NAME,
COLUMNPROPERTY(c.object_id, c.name, 'ordinal')AS ORDINAL_POSITION,
convert(nvarchar(4000),
OBJECT_DEFINITION(c.default_object_id))AS COLUMN_DEFAULT,
convert(varchar(3),...
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 11, 2020 at 2:26 pm
How is the page file utilization while CPU is spiking like that? If page file utilization is starting to climb while the CPU is spiking, it might indicate something 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.
August 10, 2020 at 8:08 pm
I could be mistaken, but I thought all of the xp_ stored procedures were deprecated?
Not sure if this is relevant or not, but:
http://tomaslind.net/2014/01/28/alternative-xp_fixeddrives/
relevant section:
SELECT DISTINCT
...
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, 2020 at 5:34 pm
Both of those questions should be new posts as they are unrelated to the original post. Replying to an old post with an unrelated question is not likely to get...
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, 2020 at 2:35 pm
For those curious, in Windows you can still use xp_cmdshell and run fsutil volume diskfree <driveletter> where "<driveletter>" is the drive letter name such as "fsutil volume diskfree C:".
a lot...
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 7, 2020 at 9:18 pm
As you have access to the server, what happens if you run the TSQL indicated in the second INFO message you posted above:
BACKUP DATABASE [Tfs_DefaultCollection] TO DISK...
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 7, 2020 at 9:06 pm
My first thought on this is that the one SSAS cube is different than the others which is apparent to me since it uses all the CPU. Now, the code...
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 7, 2020 at 7:52 pm
Can you log into the server via SSMS? If so, I would try running the backup command in the INFO message manually and see what error you get back.
If you...
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 7, 2020 at 4:17 pm
I do not have SQL Server running on linux, but I think there may be better tools to report that data than SQL. Things like Cacti, which is designed for...
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 7, 2020 at 4:07 pm
I think this depends on what tool you are using to generate the data and what tool you are using to pull it into the database and what data you...
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 6, 2020 at 6:09 pm
anything in the "users" folder is for a user account. so those 3 folders are user accounts you have or had on your system at some point.
If I remember right...
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 6, 2020 at 5:41 pm
Viewing 15 posts - 1,621 through 1,635 (of 2,917 total)