Forum Replies Created
Viewing 15 posts - 2,536 through 2,550 (of 2,917 total)
-
RE: Maintenance Cleanup Task Works Sporadically
Do you have an antivirus installed on the system?
I know our antivirus sometimes catches the files when we go to delete them and ends up locking it while 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. -
RE: Is my database corrupted?
As a weird thought, are all of your differential restores succeeding?
We do not do differential backups, but we do nightly fulls plus hourly t-logs. I have seen strange things...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. -
RE: SQL QUESTION but SSIS related - How do we get a list of parameters used by each DTSX file ?
mw112009 - Wednesday, June 7, 2017 3:03 PM
BTW-Thanks, that query worked fine.
Since you are an expert on this stuff, let...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. -
RE: Special Character Being Inserted into Data
As a thought, could this be a client processing issue not a server side processing issue?
What I have seen with some of our 3rd party solutions is that 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. -
RE: SAN Drives question. Format 4k or 64k blocks
recommended is 64k due to that being the size of an extent.
An extent is 1 chunck of data that SQL requests. Having your block size and extent size...
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. -
RE: SQL QUESTION but SSIS related - How do we get a list of parameters used by each DTSX file ?
I believe what you are looking for is the view catalog.object_parameters.
But that will give you the parameters for each DTSX, not for each project. If you want it 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. -
RE: Data Types
Revenant - Wednesday, June 7, 2017 8:35 AMThe 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.RE: Data Types
Revenant - Tuesday, June 6, 2017 7:24 PMThe 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.RE: SQL server 2014 is very slow
ChrisM@Work - Tuesday, June 6, 2017 9:15 AMThe 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.RE: SQL server 2014 is very slow
Just send them the memory requirements for SQL Server.
From the MS website:
All other editions: At least 4 GB and should be increased as database size increases 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.RE: Data Types
That was an easy one. I am a little confused why 1% of the people picked bigint though? Thinking that has to be a rounding error.... 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.RE: what is good career Sql Developer or sql DBA ?
My job title is DBA, but I do both DBA work and developer work (both database and software).
It really depends on what the company is looking for. I've read...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.RE: SQL 2012 to 2014 upgrade
Oh, one other piece of advice - Run the upgrade on a TEST environment first so you can see how it all works and test all of your reports.
I'd...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.RE: cluster disk expand
tcronin 95651 - Monday, June 5, 2017 1:17 PMThen you should be able to extend the partition inside disk manager.
Where 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.RE: Need Help Getting Max Date
meichmann - Monday, June 5, 2017 11:24 AMThe 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.Viewing 15 posts - 2,536 through 2,550 (of 2,917 total)
