Viewing 15 posts - 151 through 165 (of 173 total)
Right click Management -> Generate scripts -> select the DB then go through it.
On the objects list it should have "Script Create" as true and "Script Data" as false by...
May 13, 2013 at 5:18 am
As mentioned, fix this question T_T
change to "could you see a log file backup bigger than usual?" -- I knew the backup would be bigger; from the wording I...
May 10, 2013 at 7:33 am
Evil Kraig F (4/23/2013)
April 23, 2013 at 11:23 pm
sys.dm_exec_cursors shows nothing =((( how do I view the underlying DDL for the dm_functions?
Dird
April 23, 2013 at 1:07 pm
Evil Kraig F (4/22/2013)
There's no cursor in his solution.
Is there any documentation/book which proves this? Oracle would be running implicit cursors here; I have a hard time believing...
April 23, 2013 at 1:15 am
ScottPletcher (4/22/2013)
unless you use cursors, and nobody wants that
And you think that solution isn't implicitly using cursors?
Edit: But yeah, it's a better way of doing it 😛
Dird
April 22, 2013 at 3:27 pm
Not being funny but it's a SQL exam...
DDL (index creation, table altering, view creation), queries with grouping, various join types is what you would expect, no? If it's as bad...
April 22, 2013 at 12:21 pm
Hardens the log :w00t:
April 21, 2013 at 8:28 am
That doesn't address the question >_< but yeah it seems it is the log writer is in charge of the logging~ nothing's in a commited state while its still in...
April 21, 2013 at 6:42 am
GilaMonster (4/21/2013)
It's not the log writer process that logs the changes either.
Log writer and lazy writer are only concerned with writing already made log records/changes to disk.
Is writing it...
April 21, 2013 at 3:46 am
cmorris1441 (4/20/2013)
Dird (4/20/2013)
Yeah I just tested it in my env 😮Also the commit shouldn't be within the transaction but I guess you copied it before I added it in~
Dird
Should...
April 20, 2013 at 5:46 pm
GilaMonster (4/20/2013)
Lazy writer does not do writes to the transaction log.
Oh lol I meant log writer -_ I should have just said LGWR like i wanted to >_< (http://www.pasteall.org/pic/show.php?id=49671)
and...
April 20, 2013 at 5:42 pm
Yeah I just tested it in my env 😮
Also the commit shouldn't be within the transaction but I guess you copied it before I added it in~
Dird
April 20, 2013 at 5:26 pm
cmorris1441 (4/20/2013)
Moving on to the UPDATE trigger...
CREATE TRIGGER dbo.tr_num_rented_update
ON dbo.customer_rentals
FOR UPDATE
AS
BEGIN
UPDATE m
SET num_rentals = num_rentals
FROM dbo.movies AS m
INNER...
April 20, 2013 at 5:08 pm
You store the number as a text representation? Have you tested it with other values? I think you may have just got lucky here?
Yes, Two is "higher" than One ("T"...
April 20, 2013 at 4:20 pm
Viewing 15 posts - 151 through 165 (of 173 total)