Viewing 15 posts - 11,911 through 11,925 (of 49,562 total)
Couple steps back...
What are you trying to do?
Bear in mind that a table has no defined order (by definition). A resultset only has a guaranteed order if an ORDER BY...
August 28, 2013 at 5:39 am
Ells (8/28/2013)
Thanks.so thats all my plans out the window and look at Checkpoints. Would it be sensible to force checkpoints if they are not happening quickly enough?
Usually no. If you're...
August 28, 2013 at 3:01 am
Take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/
Did the transaction log not reuse the available space that was ready for reuse because it was allowed to keep growing to a very very...
August 28, 2013 at 2:13 am
As Erland said, something that polls the table on a regular interval, stores the results somewhere and then you'd difference the latest and previous rows.
What are you trying to...
August 28, 2013 at 2:00 am
There is nothing you can do to stop a sysadmin from doing whatever he wants. If you add a trigger to prevent him from changing a login, he can drop...
August 28, 2013 at 1:39 am
I wouldn't recommend it. One error in that defragging tool and you have a corrupt database. Better safe, stop SQL or take that DB offline, then defrag it.
August 28, 2013 at 1:28 am
You insert into Test2, but you never create it, hence the table does not exist.
Add a CREATE TABLE statement for Test2
August 27, 2013 at 12:30 pm
L' Eomot Inversé (8/27/2013)
August 27, 2013 at 12:22 pm
What, exactly, are the messages in the error log?
August 27, 2013 at 11:17 am
L' Eomot Inversé (8/27/2013)
I think TRUNCATE takes only a table lock
TRUNCATE take a schema modification lock
DELETE takes row and sometimes also page locks
Delete can take X locks at table, page...
August 27, 2013 at 11:13 am
You're not declaring the precision or scale of the decimal. The default is 18,0 meaning 18 digits on the left of the decimal place and 0 on the right (so...
August 27, 2013 at 10:45 am
Be careful with that. The CPU_time is the total time since the connection was established, not necessarily going to help much with identifying high CPU-using queries.
Memory usage is probably the...
August 27, 2013 at 10:39 am
Jeff Moden (8/27/2013)
Semantically speaking, it's a difference in what gets logged.
Indeed. TRUNCATE is more like a DDL statement, it logs in the same way as a DROP TABLE does. DELETE...
August 27, 2013 at 10:37 am
Jason.Reeves (8/27/2013)
August 27, 2013 at 9:08 am
If you've got enough activity, then the reason for the log not being reused can easily be log backup all the time, because by the time one log backup has...
August 27, 2013 at 9:05 am
Viewing 15 posts - 11,911 through 11,925 (of 49,562 total)