Viewing 15 posts - 25,291 through 25,305 (of 49,552 total)
joshd 1807 (6/28/2011)
As for transactional replication, we don't have a need for any high level stuff here, so I'm unaware of how that works.
It's far simpler, far less prone 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
June 28, 2011 at 4:28 pm
Dave Ballantyne (6/28/2011)
Thanks Gail , I did wonder if the poster read past the first few lines.
What's this? You're expecting people to actually read something before criticising it? Really, how...
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 28, 2011 at 3:30 pm
You can mirror to test, but the mirroring database is inaccessible. You can create a snapshot over it (Enterprise only), but that's read only.
What's wrong with a backup-restore on a...
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 28, 2011 at 3:28 pm
None that I know of. It's TempDB, not log, not user DB. It has to store old versions of rows that change during your transaction, so if little changes 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
June 28, 2011 at 3:25 pm
Oh, right. In SA writing an exam is the term used for a student, an examiner sets the exam.
No, I'm not that interested in getting involved in setting the exams....
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 28, 2011 at 3:16 pm
Make sure that the tran log has space to grow. If it's running out of space during routine maintenance, it needs to be larger.
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 28, 2011 at 3:09 pm
SQLRNNR (6/28/2011)
You should have written the one for 450 - IMHO it needs a revamp to correct some flaws.:-D
I have. For 2008 I've written 432, 433, 450 and 451. 3...
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 28, 2011 at 3:05 pm
Steve Jones - SSC Editor (6/28/2011)
You can explain it is a simple example, but I wouldn't give it more than one post.
Already done.
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 28, 2011 at 2:59 pm
Rich Yarger (6/28/2011)
No practice exams for the Denali TS and ITP certs??? I had better get my 2008 creds done soon.
Err, what???
The Denali exams likely won't be out for...
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 28, 2011 at 2:50 pm
glen.wass (6/28/2011)
Here is a start for you this will give you the highest paid per department
select Emp_Name max(Salary)
group by emp_name, Dept
That's great for the highest, it's much harder to extend...
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 28, 2011 at 2:46 pm
For simplicity of example?
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 28, 2011 at 2:44 pm
Tables are by definition unordered. What you're probably seeing is not a difference in the way the data is stored, but the way SQL's returning it.
SQL will try to put...
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 28, 2011 at 2:42 pm
Test, don't assume. Depending on what else is running it could be heavy or virtually none, can't tell until you test (dev/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 28, 2011 at 2:40 pm
Reorganise (ALTER INDEX ... REORGANISE or DBCC INDEXDEFRAG) is fully logged always. The more fragmented the index, the more it has to do and the more log space it generates.
Rebuild...
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 28, 2011 at 2:34 pm
The latest build available is CTP 1. There's talk of another CTP soon (for whatever MS defines as soon)
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 28, 2011 at 2:31 pm
Viewing 15 posts - 25,291 through 25,305 (of 49,552 total)