Viewing 15 posts - 15,466 through 15,480 (of 49,552 total)
The _WA_Sys stats are automatically created by SQL Server.
You can drop them if you want. SQL will recreate them if it needs. The _dta stats were created when someone ran...
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
November 28, 2012 at 9:10 am
Zeal-DBA (11/28/2012)
Yes Gail anthony suggested, and i started the chapter 4 but dint get time to complete it... :-P:-D
You know, just maybe the answers are in there...
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
November 28, 2012 at 9:06 am
Zeal-DBA (11/28/2012)
widows server 2003 R2 (64 bit)SQL serever 2005 SP2 (64 bit)
please let me know steps to set max server memory or min server memory.
Server properties -> Memory ->...
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
November 28, 2012 at 9:05 am
Did you see the recent headline articles?
http://www.sqlservercentral.com/articles/baselines/94657/
http://www.sqlservercentral.com/articles/baselines/94656/
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
November 28, 2012 at 8:45 am
SQLSACT (11/28/2012)
Now, when that change gets reflected on disk, does the changed page in Memory replace the corresponding page on disk?
The 8kb page in memory is written to disk,...
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
November 28, 2012 at 8:37 am
Please note: 3 year old thread.
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
November 28, 2012 at 7:00 am
itis4junk (11/27/2012)
I'll request the database to be upgraded.
If you mean upgraded to SQL 2008 R2, bear in mind that is a different version of SQL (not a service pack) 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
November 28, 2012 at 6:43 am
Pedantic nitpick. The ; is a statement terminator. It does not begin statements. ;WITH is an abomination that I wish would go away.
PiMané (11/28/2012)
DECLARE @FirstColumnsKeys INT = 2;
WITH IndexInfo AS...
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
November 28, 2012 at 6:42 am
Zeal-DBA (11/28/2012)
john,then???
Go for coffee?
lock pages enable permision??
Not required for just changing max server memorry
and service restart, not required??
Not required.
I'm fairly sure I or another person has referred...
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
November 28, 2012 at 6:37 am
Adi Cohn-120898 (11/28/2012)
Unfortunately the whole process of restore took them 3 days. During that time they were close for business.
Amazing that they reopened afterwards. When I worked for a...
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
November 28, 2012 at 3:02 am
They don't always grab an exclusive table lock, they can and do lock at row, page or table depending on the rows involved, the available lock memory and a whole...
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
November 28, 2012 at 2:58 am
raotor (11/28/2012)
1. Why perform a differential database backup as opposed to another log backup?
Speed of restores. When restoring a diff, you just need the latest one. When restoring logs, 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
November 28, 2012 at 2:44 am
Simon-413722 (11/28/2012)
Index rebuilds
Rebuilding an index offline, using ALTER INDEX REBUILD (or the deprecated DBCC DBREINDEX in SQL Server 2000) drops the target index and rebuilds it from scratch (online...
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
November 28, 2012 at 2:23 am
Please post table definitions, index definitions and execution plan.
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
November 28, 2012 at 1:43 am
I would not recommend restoring master to other servers. Not least because you overwrite that server's master DB which you then have to go and restore from its backups later.
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
November 28, 2012 at 1:26 am
Viewing 15 posts - 15,466 through 15,480 (of 49,552 total)