Viewing 15 posts - 6,496 through 6,510 (of 49,571 total)
I would suggest you post this on a MySQL forum. This site is for MS SQL Server.
March 2, 2015 at 2:03 am
Lynn Pettis (3/1/2015)
Ed Wagner (3/1/2015)
Lynn Pettis (3/1/2015)
March 2, 2015 at 2:02 am
Usually, most of the time, corruption is due to something wrong in the IO subsystem. That's everything from filter drivers right down to the disks, so there's lots of moving...
March 2, 2015 at 1:56 am
Michael Valentine Jones (2/28/2015)
You should consider setting the database to Read Committed Snapshot.
This. Absolutely this.
Bear in mind that nolock doesn't just mean dirty reads. Keeping nolock may seem fine until...
February 28, 2015 at 5:40 am
If it's never had a transaction log backup, then it's probably safe to assume no one really cares about point in time recovery.
Set the DB to simple recovery model, shrink...
February 26, 2015 at 1:47 am
This is a SQL Server forum, not Exchange (or whatever uses OST). Maybe start by finding a forum for the product you're having a problem with?
February 26, 2015 at 1:42 am
You need the last differential which *finished* before the time you want to stop at, the full backup that it is based off and all log backups since the differential...
February 25, 2015 at 10:35 am
PHYData DBA (2/25/2015)
https://technet.microsoft.com/en-us/library/ms188270(v=sql.105).aspx
A heap is a table without a clustered index.
I don't...
February 25, 2015 at 9:01 am
anthony.green (2/25/2015)
Total server memory is 64GB, but the OS is showing 61.9GB used,
60GB max server memory on a 64GB server is a tad on the high side. OS needs...
February 25, 2015 at 8:28 am
PHYData DBA (2/25/2015)
I do not completely agree with your statement.The order of the results returned by a query can be changed by adding any index.
Not if you have...
February 25, 2015 at 8:12 am
PHYData DBA (2/25/2015)
Not being sarcastic, just need to know to give you a good answer.
If a Heap is required then you...
February 25, 2015 at 7:44 am
Grant Fritchey (2/25/2015)
Nothing using WITH RECOMPILE? No one running DBCC FREEPROCCACHE? Nothing like that?
No sp_recompile, sp_configure, ALTER DATABASE?
February 25, 2015 at 7:29 am
anthony.green (2/25/2015)
Server has 60GB of RAM assigned to its min and max server memory settings
Probably unrelated, but I don't like that for starters. Setting min to max means that SQL...
February 25, 2015 at 6:46 am
mohammedaala (2/25/2015)
Dear Team,I have a query:
And?
February 25, 2015 at 5:57 am
Viewing 15 posts - 6,496 through 6,510 (of 49,571 total)