Viewing 15 posts - 1,606 through 1,620 (of 2,356 total)
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/
May 18, 2017 at 12:09 pm
I have no problem dealing with developers, I just wish they would "up their game".
Last week, a piece of code that loops(!) through a bunch of records to insert...
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/
May 15, 2017 at 1:56 pm
I forgot about that one. I just put up with that fun myself.
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/
May 10, 2017 at 6:03 pm
SQL Server service account needs access to the folders where the data and log files reside, as well as the binaries. Michael L John
His account was probably an admin level account.
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 10, 2017 at 2:55 pm
If he did that, please do not refer to him as a DBA! It's an insult to those of us that are!
Aside from the two places you thought...
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/
May 10, 2017 at 2:24 pm
You cannot restore a SQL 2016 database to a SQL 2012 server.
You can re-create an empty database on 2012, and transfer the data into it from 2016. There are...
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/
May 10, 2017 at 10:04 am
For starters, your max memory setting needs to be adjusted.
https://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/
Secondly, what is happening at the VMWare level? Are there snapshots happening? How is...
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/
May 10, 2017 at 10:00 am
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/
May 9, 2017 at 6:24 am
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/
May 8, 2017 at 11:49 am
Another great day.
Moved the production reporting server database to a new box Saturday
Weeks ago, the dev and QA instances were upgraded to SQL2014 SP2. No bad...
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/
May 8, 2017 at 11:37 am
I think it may make sense for you to do some learning.
Grant Fritchey wrote this article.
https://www.simple-talk.com/sql/performance/execution-plan-basics/
He has also written a good book.
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/
May 4, 2017 at 5:55 pm
The table does not have frequent inserts, so better to have a...
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/
May 4, 2017 at 1:47 pm
This looks like an estimated plan, not the actual plan.
Can you post the actual plan?
The only thing that stuck out was that, even with 20+ indexes, the optimizer...
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/
May 3, 2017 at 1:51 pm
You have a new server. You expect it to be fast, because it's new?
Have you looked at:
1. The configuration of the VM.
a. How are 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/
May 2, 2017 at 1:37 pm
It sounds as if there may be rights granted to the second table that you may have missed.
See if you can spot where the permissions were granted by...
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/
May 2, 2017 at 7:38 am
Viewing 15 posts - 1,606 through 1,620 (of 2,356 total)