Viewing 15 posts - 1,126 through 1,140 (of 2,356 total)
That is weird...the first error is usually when a dump happens. But the long checkpoints would be a concern. I'd probably check for any other signs of disk latency...
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/
June 11, 2019 at 6:10 pm
Is it generating any dump files, any listed in in sys.dm_server_memory_dumps? Sue
That's one of the baffling things. There are no dumps, and nothing in the windows event logs.
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/
June 11, 2019 at 1:13 pm
You can try the steps listed in this article.
Have you run a consistency check on this database recently?
Best case, the ALTER DATABASE name SET ONLINE may work.
Worst case, you may be...
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/
June 6, 2019 at 4:04 pm
The point of a backup is to be able to restore the database.
If there is not an initial full backup (backup chain), there will be no way to restore 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/
June 5, 2019 at 3:14 pm
It does not appear that this procedure needs to be Dynamic SQL.
Is there a reason that this is written using Dynamic SQL?
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/
June 3, 2019 at 7:46 pm
I have a bit of bittersweet news. After more than a decade of coaching youth soccer I am finally hanging up the whistle (although I never actually use one...
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/
June 3, 2019 at 6:22 pm
You said this:
SQL Server Engine and agent services on both machine running with domain account that is domain admin.
Also this accounts add to the SQL server with sysadmin permission.
Both of...
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/
June 3, 2019 at 4:43 pm
Change it to 'sa'
EXEC sp_changedbowner 'sa'
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/
June 3, 2019 at 4:38 pm
No, I have not found a place to move the system databases.
I let the install finish, and move them as part of the post-install steps
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 31, 2019 at 1:44 pm
Some dev systems are set to simple recovery, and a full backup is done nightly. These are mostly the legacy systems where little development work, if any, is being done.
Other...
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 29, 2019 at 7:31 pm
You are three service packs, and 2 hotfixes behind what is available.
I think your "next best" is to apply SP4. There's little advantage to delaying the inevitable.
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 29, 2019 at 4:28 pm
On two Instances I have inherited there is just one tempDB file on both of a size of 8MB, the drive tempDB is on is 30GB and tempDB 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 29, 2019 at 1:12 pm
Yes, this can be done without downtime.
The second part of the question is why? What things are you seeing that makes you need to do this?
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 28, 2019 at 4:03 pm
I just can't believe some people. I requested our DBA to gather statistics from sys.dm_exec_procedure_stats in production and store them in a non-production database for analysis without compromising...
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 28, 2019 at 1:18 pm
No, your assumption is not correct.
This link explains how much is allocated for the the different data types.
So, when you declare a variable, or a 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/
May 24, 2019 at 1:34 pm
Viewing 15 posts - 1,126 through 1,140 (of 2,356 total)