Viewing 15 posts - 34,636 through 34,650 (of 49,552 total)
mstephens1754 (1/18/2010)
If anyone here has any experience with NLB combine with database mirroring please share?
SQL Server cannot be load balanced. What's done with sharepoint is to use NLB with the...
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
January 18, 2010 at 7:06 am
Read through all of the documentation on Technet on clustering. There's a lot of it. If you have specific questions once you've read it all, please ask.
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
January 18, 2010 at 4:09 am
Saravanan T (1/18/2010)
Hi ,Try to use tablock in delete Statement. it may work.:w00t:
It'll prevent the deadlock sure. It'll also prevent anyone else from doing anything...
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
January 18, 2010 at 4:06 am
Dubai's good too.
Location doesn't concern me all that much, just as long as the host city as reasonably good public transport.
I'm not sure about the splitting up. At the moment,...
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
January 18, 2010 at 2:01 am
sanketahir1985 (1/18/2010)
if yes then how many questions will be there for simulation & how many for objective?
The number of questions in total (and the division between aread) can vary...
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
January 18, 2010 at 12:49 am
I'm not sure what you're asking for.
It's a standard MS cert exam, multiple choice style. The material that the exam covers is details on the Microsoft site. http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-443
There weren't any...
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
January 18, 2010 at 12:36 am
rspskumar-704119 (1/17/2010)
If you are looking for high level protection to your backups use TDE[Transparent data encrytion which is more powerfull than passwords]
Available only in SQL 2008....
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
January 17, 2010 at 2:11 pm
rspskumar-704119 (1/17/2010)
plese set db status to emerngy mode and export data and run repair
Absolutely not. Totally unnecessary and frankly in this case stupid things to suggest.
Emergency mode...
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
January 17, 2010 at 2:04 pm
This series on indexing (and especially the comments on the second one) may be worth reading
http://www.sqlservercentral.com/articles/Indexing/68439/
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
January 17, 2010 at 2:19 am
ypradeep (1/17/2010)
But I want to know, the technical reason behind this deadlock, and how to reproduce this?
As I said, I'm honestly not sure why this is happening.
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
January 17, 2010 at 2:16 am
Yes, I did.
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
January 16, 2010 at 12:59 pm
stephenhai (1/15/2010)
Anythings need to pay attention when upgrade from 2000 to 2008
Lots.
Run the upgrade advisor. Fix everything it complains about.
Set up a test server running SQL 2008. Test your...
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
January 16, 2010 at 11:44 am
Have a read through this: http://www.brentozar.com/becoming-a-dba/how-to-get-a-junior-dba-job/
If you have no DBA experience, it is very unlikely that you will get hired, even as a junior DBA. Those jobs usually require some...
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
January 16, 2010 at 11:26 am
Actually, I'd suggest either saving the xml deadlock graph in a text file or posting the deadlock graph directly into your post, rather than giving us what looks like your...
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
January 16, 2010 at 11:17 am
Matt Miller (#4) (1/16/2010)
Steve Jones - Editor (1/16/2010)
I guess that Twitter SQL help thing is going to work out great, isn't it?
Can't help but think that the amount of help...
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
January 16, 2010 at 10:30 am
Viewing 15 posts - 34,636 through 34,650 (of 49,552 total)