Viewing 15 posts - 6,496 through 6,510 (of 49,552 total)
What exactly is changing?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 2, 2015 at 2:09 am
I would suggest you post this on a MySQL forum. This site is for MS SQL Server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 2, 2015 at 2:03 am
Lynn Pettis (3/1/2015)
Ed Wagner (3/1/2015)
Lynn Pettis (3/1/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 25, 2015 at 6:46 am
mohammedaala (2/25/2015)
Dear Team,I have a query:
And?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 25, 2015 at 5:57 am
Viewing 15 posts - 6,496 through 6,510 (of 49,552 total)