Viewing 15 posts - 2,971 through 2,985 (of 7,484 total)
Jeff Atherton (10/17/2013)
L' Eomot Inversé (10/17/2013)
October 17, 2013 at 10:42 am
Bhuvnesh (10/17/2013)
L' Eomot Inversé (10/16/2013)
Bhuvnesh (10/16/2013)
October 17, 2013 at 9:29 am
Arrgh! I got this wrong by a careless assumption. I assumed that sp_recompile('T') would the same effect as would sp_recompile('GetIt') in this context. So now I've...
October 17, 2013 at 6:21 am
crookj (10/16/2013)
A Happy Ada Lovelace Day to all!
If the Yale guys get their druthers, we'll have a day named after the other Lovelace some time.
October 16, 2013 at 5:16 pm
Anyone want to offer any advice on this?
edit: fix tags
October 16, 2013 at 9:14 am
Bhuvnesh (10/16/2013)
L' Eomot Inversé (10/16/2013)
ROLLBACK always (unless you specify an invalid transaction name) sets @@trancount to 0 and rolls back the transaction (unless @@trancount is already 0, in which...
October 16, 2013 at 8:46 am
marlon.seton (10/16/2013)
October 16, 2013 at 8:23 am
David Burrows (10/16/2013)
And continuing your premise then 'SELECT COUNT(*) FROM table' before the rollback will return the wrong result as the table does not contain any rows 😛
Actually reads within...
October 16, 2013 at 7:31 am
Bhuvnesh (10/16/2013)
October 16, 2013 at 6:53 am
David Burrows (10/14/2013)
Due to the amount of criticism of previous QOD of the phrasing of the Q'a and A's I am surprised that no one posted anything about the...
October 16, 2013 at 6:19 am
Jeff Moden (10/11/2013)
October 11, 2013 at 4:54 pm
Daniel Bowlin (10/11/2013)
L' Eomot Inversé (10/10/2013)
Revenant (10/10/2013)
jasona.work (10/10/2013)
SQLRNNR (10/10/2013)
tomahawkHarpoon
Moby Dick
Pequod
Ahab
Ishmael
October 11, 2013 at 7:38 am
Fal (10/10/2013)
October 11, 2013 at 7:34 am
Sean Pearce (10/11/2013)
Hi Tom,Here is a blog post regarding this:
http://sqlblog.com/blogs/merrill_aldrich/archive/2011/11/25/one-database-or-ten.aspx
Yes, that's quite a good piece.
Apart from thinking that people usually don't use the features that make recovery...
October 11, 2013 at 7:05 am
Sean Pearce (10/10/2013)
Data that needs to be transactionally consistent must be in the same database.
That's a remarkable statement. MS technology allows reliable transactional consistency across multiple databases in multiple...
October 10, 2013 at 7:31 pm
Viewing 15 posts - 2,971 through 2,985 (of 7,484 total)