Viewing 15 posts - 17,881 through 17,895 (of 49,552 total)
SQLRNNR (6/27/2012)
One thing you did not list that I am not sure works in Compat 80 is backup compression.
It does. So do most 2008 features. The only thing that compat...
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
June 27, 2012 at 12:19 pm
The create index statements and the create table statement. Want to see data types, key and include columns
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
June 27, 2012 at 12:16 pm
sql.AB (6/27/2012)
Gail - Is there any article for the same?
Sure. Books Online. The section Files and Filegroups is probably a good place to start.
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
June 27, 2012 at 11:00 am
An execution plan of the TOP 100 is useless. It'll be a different plan to the full query. If you can't get actual plan, please the index and table definitions.
Personally...
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
June 27, 2012 at 10:55 am
GilaMonster (6/27/2012)
Long running transactions?Bulk-logged recovery model?
Replication?
Are you appending multiple backups to a single file?
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
June 27, 2012 at 8:08 am
Brandie Tarvin (6/27/2012)
Stefan Krzywicki (6/27/2012)
GilaMonster (6/27/2012)
Stefan Krzywicki (6/27/2012)
Why do you say they suck? I love mine.
Love mine too, it just has to be said, it is not a replacement...
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
June 27, 2012 at 8:06 am
Firstly the size of the log file is unrelated to the size of the log backup. You may want to regrow your logs to a sensible size for the normal...
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
June 27, 2012 at 7:39 am
Stefan Krzywicki (6/27/2012)
Why do you say they suck? I love mine.
Love mine too, it just has to be said, it is not a replacement for a computer. Very nice...
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
June 27, 2012 at 7:36 am
Reddy Ksr (6/27/2012)
i think in sql server 2008 we can rollback the committed transaction.
You cannot.
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
June 27, 2012 at 7:06 am
Probably because it's a heap.
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
June 26, 2012 at 11:47 pm
Why nolock? You like randome, hard-to-reproduce data errors?
See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
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
June 26, 2012 at 11:44 pm
No, it won't make data changes.
That said, don't run DTA against the productin database. Very bad idea. REstore a copy to dev/test and tune there, don't trust DTA's output, test...
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
June 26, 2012 at 11:44 pm
Please run the following and post the full and complete output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
p.s. Detach/attach will never repair corruption and can actually make the situation worse.
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
June 26, 2012 at 11:28 pm
No, need to see the rows affected by every operator.
If you can't get an actual plan, then please at least the index and table definitons.
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
June 26, 2012 at 3:14 pm
Actual plan please (can't see row estimation errors on an estimated), table definitions and index defintions also.
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
June 26, 2012 at 2:21 pm
Viewing 15 posts - 17,881 through 17,895 (of 49,552 total)