Viewing 15 posts - 27,676 through 27,690 (of 49,552 total)
Restore from backup. Not repairable.
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 18, 2011 at 6:46 am
abhishek_dwivedi03 (2/18/2011)
I want to restore it with a different name ao that i am able to see the data present in the database .
Shut down SQL, take a copy...
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 18, 2011 at 6:46 am
Jeff Moden (2/18/2011)
Lennie even attacked Gianluca who was just trying to keep things calm. I don't have a black book but I believe I'm going to start one.
I've reported...
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 18, 2011 at 6:29 am
Host the SQL Server and don't give them permissions to see the code.
If you give (or sell) the database and the client installs it on their server, there 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 18, 2011 at 6:28 am
Jeff Moden (2/18/2011)
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 18, 2011 at 6:12 am
Craig Farrell (2/18/2011)
Stefan proved to me he's a much better abuser of fools than I am. May I request recruiting his assistance? 🙂
No! Leave Lennie alone. We don't need...
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 18, 2011 at 2:50 am
Sure, find the job/maint plan that runs it and disable that job. CheckDB does not run automatically. There is a job or maintenance plan that runs it.
However, that is really...
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 18, 2011 at 2:43 am
Deadlock graph, update code, schema for any tables/indexes involved (if you have't posted before), please.
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 18, 2011 at 2:35 am
Derrick Smith (2/17/2011)
Now the real problem with SSMS Intellisense:How do you stop it from auto-completing when you press period or space?
Turn it off and get a replacement that actually...
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 17, 2011 at 4:39 pm
Too expensive? SQL Express 2008 (the one with the 10GB limit) is free.
It's only if they want a full version of SQL (without a size limit) that they need to...
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 17, 2011 at 4:32 pm
Every 2 hours is a little often for diff backups. Done so that you can restore the database quickly to any point?
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 17, 2011 at 1:46 pm
Craig Farrell (2/17/2011)
Isn't the RID and the "uniquifier" pretty much equivalent from an overhead standpoint, being a 4 byte identifier?
No. To start with, the RID's not 4 bytes.
The RID is...
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 17, 2011 at 11:25 am
Randheer (2/17/2011)
This is the questions which other than the general indexes questions.What are criteria to define covering index and how we create it?
Please provide some details for this question.
Are 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 17, 2011 at 10:59 am
Nothing can be disclosed about the contents of the exam, the areas questions fell in, any details of what was asked without breaking the NDA that anyone writing the exam...
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 17, 2011 at 10:55 am
jabadwy (2/17/2011)
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 17, 2011 at 10:50 am
Viewing 15 posts - 27,676 through 27,690 (of 49,552 total)