Viewing 15 posts - 41,116 through 41,130 (of 49,552 total)
Rebuild, yes, reorganise, no.
Even still, autostats should be on for any system unless you know that 1 week old stats will not result in performance degradation due to poor query...
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 10, 2009 at 2:50 pm
If the index's leading column is imageid, then SQL will never pick it by choice, as the leading column of the index is not in the where clause at all....
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 10, 2009 at 2:49 pm
ichbinraj (2/10/2009)
We have recommendations from team- lead to increase the datafiles in db ...he suggested us to maintain ratio 2:1 (datafiles : Processors ).
Tell your team lead that the recommendation...
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 10, 2009 at 2:39 pm
Bruce W Cassidy (2/10/2009)[font="Verdana"]
Fair comment. Shamefaced[/font]
No worries. We've all done the same thing on occasion.
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 10, 2009 at 1:53 pm
Look up ALTER DATABASE in Books Online. The options to add files are well described.
Why a new file? What are you trying to achieve?
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 10, 2009 at 1:50 pm
Bruce W Cassidy (2/10/2009)
[font="Verdana"]Gotcha. I did a little subsidiary reading on Books Online, and you're quite right -- cached query plans don't apply for views.[/font]
May I very politely 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 10, 2009 at 1:47 pm
Paresh Prajapati (2/10/2009)
Only I know that from Network people , it is external IP..
Then tell them to do their bloody jobs and find out where the intrusion is coming from....
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 10, 2009 at 1:45 pm
Grant Fritchey (2/10/2009)
Yep, Gail's right on this one too (you can usually just assume that).
:hehe:
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 10, 2009 at 1:42 pm
Bob Hovious (2/10/2009)
"I've just deleted some huge, important tables and I haven't been doing backups. How do I get these tables back?"
If you want to laugh (or...
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 10, 2009 at 1:39 pm
Bruce W Cassidy (2/10/2009)
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 10, 2009 at 1:24 pm
MVIR (2/10/2009)
I can make the changes in code as everybody hassuggested but I need to give out a proper reason for why it has gone bad.
Very hard to say. Data...
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 10, 2009 at 1:10 pm
Grant Fritchey (2/10/2009)
You shouldn't have to do anything to clean out a transaction log that is in simple recovery. It will happen automatically.
Indeed. If the log space is not...
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 10, 2009 at 1:08 pm
gupta1282 (2/8/2009)
now I want to start my carrier as a sql server dba.
Why do you want to be a DBA? What is it about that career that attracts 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 10, 2009 at 9:49 am
I would recommend that you restore the entire database. If you don't have a filegroup backup (and log backups from the time of the full), it's going to be hard...
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 10, 2009 at 9:47 am
Can you post the table and index definitions and the execution plan (saved as a .sqlplan file, zipped and attached)?
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 10, 2009 at 9:35 am
Viewing 15 posts - 41,116 through 41,130 (of 49,552 total)