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...
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...
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...
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...
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?
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...
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...
June 3, 2019 at 4:43 pm
Change it to 'sa'
EXEC sp_changedbowner 'sa'
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
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...
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.
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...
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?
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...
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...
May 24, 2019 at 1:34 pm
Viewing 15 posts - 1,126 through 1,140 (of 2,356 total)