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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 23, 2020 at 6:48 pm
Duplicate post:
https://www.sqlservercentral.com/forums/topic/dynamically-choose-columns-names
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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)'
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
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,...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 7, 2020 at 8:25 pm
What are you ultimately trying to do?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
January 7, 2020 at 7:17 pm
Viewing 15 posts - 991 through 1,005 (of 2,356 total)