Viewing 15 posts - 48,361 through 48,375 (of 49,571 total)
Yup. That's correct.
If you don't need to be able to make point-in-time restores, then you can change to simple recovery mode. In simple the log auto truncates on checkpoints.
October 23, 2007 at 4:33 am
Look at sp_executesql
DECLARE @ReturnValue DATETIME, @EmployeeID INT
SET @EmployeeID = 1
exec sp_executesql N'SELECT @JoinDate = JoinDateQuery NewHireEmployee where empid = @EmpID ',
N'@EmpID int, @JoinDate DATETIME OUTPUT', @EmpID = @EmployeeID, @JoinDate...
October 23, 2007 at 2:00 am
What you're seeing in parallelism waits. Is there a wait type of CXPacket?
iirc, the display of spids blocking themselves was new in SP3 or 4. Before that you wouldn't see...
October 23, 2007 at 1:41 am
rhunt (10/22/2007)
October 23, 2007 at 1:28 am
Is the DB in full or bulk-logged recovery mode?
If so, do you have log backups runnng? If you're in full recovery mode and have no log backups, the log will...
October 23, 2007 at 1:01 am
Matt Miller (10/22/2007)
...with fill factor @ 100%.
No. With any fill factor. Of course, the lower the fill factor the more out of order inserts you can have without...
October 23, 2007 at 12:31 am
Oh no! The one table to rule them all design. If I were you, I'd start running now. This database 'design' tends to crop up again and again in tales...
October 22, 2007 at 9:46 am
Move the subquery into the from clause, so you can reference it as if it was another table. You'll likely get better performance too.
SELECT ... FROM Table1 INNER JOIN (SELECT...
October 22, 2007 at 9:25 am
I may be wrong, but I think it only comes with the non-free versions of SQL server.
What you may like to do, if you're serious about SQL is buy...
October 22, 2007 at 9:20 am
Edit: Never mind, I'm talking garbage
Since you have AWE enabled, that's not the issue.
October 22, 2007 at 6:07 am
You need to patch SQL to SP2 or later for it to run on Vista
Download SQL Express. You should be able to fid it pre-patched. That's enough to play around...
October 22, 2007 at 5:42 am
If your clustered index is on a column that doesn't increment (identity, date inserted) then inserts cause page splits. Page splits cause increased IOs and index fragmentation. Fragmentation causes slower...
October 22, 2007 at 5:29 am
Yup. That's pretty much the same query expressed a different way. The IS NULL check needs to be left out, or you'll get no records as you've reversed the logic...
October 21, 2007 at 12:37 pm
Ian Harris (10/19/2007)
Am I correct in believing that on the whole it is better to let the SQL Server work out how to apply locks?
In my opinion, 100% correct. My...
October 19, 2007 at 9:05 am
Viewing 15 posts - 48,361 through 48,375 (of 49,571 total)