Viewing 15 posts - 1,606 through 1,620 (of 2,356 total)
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...
May 15, 2017 at 1:56 pm
I forgot about that one. I just put up with that fun myself.
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.
His account was probably an admin level account.
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...
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...
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...
May 10, 2017 at 10:00 am
May 9, 2017 at 6:24 am
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...
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.
May 4, 2017 at 5:55 pm
The table does not have frequent inserts, so better to have a...
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...
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...
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...
May 2, 2017 at 7:38 am
Viewing 15 posts - 1,606 through 1,620 (of 2,356 total)