Viewing 15 posts - 25,396 through 25,410 (of 49,552 total)
10% is a dangerous file growth. Recommendation is not to use % (as it can get out of control as the file grows) but to set it to a sensible...
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 21, 2011 at 12:39 pm
Files cannot be moved between filegroups. End of story.
You can use Shrinkfile with the EmptyFile option to empty the file so that it can be dropped, but that's it. If...
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 21, 2011 at 12:38 pm
sathish2109 (6/21/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
June 21, 2011 at 12:35 pm
Jayanth_Kurup (6/21/2011)
you need to copy the database files onto the disk of the machine hosting sql server. u cannot run sql database on protable media
Completely false. I often run database...
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 21, 2011 at 12:33 pm
http://support.microsoft.com/kb/923247
If you need further help post, but I won't be able to help much this week.
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 21, 2011 at 12:28 pm
Because the insert starts a transaction and automatically commits it as soon as its finished.
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 21, 2011 at 12:24 pm
sqlnaive (6/21/2011)
Actually while deleting 50k records one at a time, the table getting locked and affecting other processes as well.
Snapshot isolation (or read committed snapshot)
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 21, 2011 at 12:14 pm
Post Execution plans 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
June 21, 2011 at 12:11 pm
Documentation?
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 21, 2011 at 12:06 pm
No lock is never good practice.
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 21, 2011 at 1:08 am
Non clustered on all four columns. Go read my blog (indexing category) for a post explaining why.
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 21, 2011 at 1:06 am
There are usually ones on CD in the MS press exam guides, other than that, buy the Transscender or mEasureUp practice exams (they usually have a couple questions as demos)
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 21, 2011 at 1:02 am
Syed Jahanzaib Bin hassan (6/21/2011)
when you set on this,SQL Server will not count the rows ,it will increase the performance because overhead of counting must be disabled and another...
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 21, 2011 at 1:00 am
Iirc, the bugs in the page usage tracking were fixed in 2005 RTM, fixed again in 2005 SP1 and fixed again in SP3. (or something like that)
If you're post SP3...
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 20, 2011 at 2:29 pm
Dumps are cheating. They are the actual questions from the real exams and using any such 'study aid' is against the the rules for the exams. Using or distributing them...
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 19, 2011 at 1:02 pm
Viewing 15 posts - 25,396 through 25,410 (of 49,552 total)