Viewing 15 posts - 991 through 1,005 (of 2,356 total)
In today's meeting of the entire IT staff, we were discussing how interruptions prevent us from getting projects completed.
My boss, using me as an example, stated that...
January 24, 2020 at 3:13 pm
Did you miss a big point? There is actually a very good reason to name a specific column!
If you don't have access to every single column in the table...
January 24, 2020 at 2:34 pm
In today's meeting of the entire IT staff, we were discussing how interruptions prevent us from getting projects completed.
My boss, using me as an example, stated that I was too...
January 23, 2020 at 6:48 pm
January 16, 2020 at 1:19 pm
The thing is some databases has zero growth or even minus due to shrinking process
Please describe the "shrinking process". And why there is one in place.
January 15, 2020 at 2:20 pm
An equi join is simply a subset of a join. The criteria is an equality operator, as I understand things.
A natural join is an extension of PL-SQL, MySQL, and maybe...
January 14, 2020 at 3:59 pm
I agree. Download and run Ola Hallengren's solution. It's far more complete, and is far more flexible, than what you have written.
January 14, 2020 at 3:51 pm
So, what you are saying is you create procedures that are tested in development, and when moved into production, various issues cause them to perform poorly, or cause...
January 13, 2020 at 4:20 pm
My first car was a Plymouth Valiant, 6 cylinder, 3 on the tree. It had no heat, so it was great on dates because you had to cuddle on the...
January 10, 2020 at 3:40 pm
I have nothing better than Sue's suggestion about using xp_logevent.
I guess my question would be is can the developers modify their code to write to the windows log, in addition...
January 8, 2020 at 5:01 pm
What method HA do you prefer to use, and why? What requirements have to be met? Which technologies meet those requirements?
If the method that meets all of your requirements requires...
January 8, 2020 at 4:30 pm
That's likely part of your problem.
The Max server setting specifies how much memory SQL can use. Your server is set to the default, which is everything!
If you read the link...
January 8, 2020 at 3:28 pm
Please run this query and show us the results:
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'max server memory (MB)'
January 7, 2020 at 9:37 pm
No, you do not need to failover to add files to tempdb. Are you confusing an AG to an Oracle grid installation? Very different beasts.
The system databases, master, model, msdb,...
January 7, 2020 at 8:25 pm
What are you ultimately trying to do?
January 7, 2020 at 7:17 pm
Viewing 15 posts - 991 through 1,005 (of 2,356 total)