Viewing 15 posts - 7,441 through 7,455 (of 26,490 total)
Oh, actually, they don't go away. They get flagged as inactive (status 0). Your log file won't shrink(when using SHRINK_FILE) until you start getting the VLFs at the...
May 31, 2013 at 1:03 pm
Do you see all those VLF's with a status of 2? They won't away until the status changes to 0.
You may also want to start reading this: http://www.sqlskills.com/blogs/kimberly/8-steps-to-better-transaction-log-throughput/
Then follow...
May 31, 2013 at 12:56 pm
Run the following:
DBCC LOGINFO ('YourDatabaseName');
Post the results here.
May 31, 2013 at 12:45 pm
reelnoncents (5/31/2013)
May 31, 2013 at 12:44 pm
How about starting here and see if you can figure it out based on what is there:
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/
If you have any questions, come back here and ask.
May 31, 2013 at 11:40 am
If it is still growing after the t-log backups (full backups have no affect on the t-log) try running the following:
select
name,
log_reuse_wait_desc
from
...
May 31, 2013 at 11:29 am
If the transaction log is still growing even if you are taking regularly scheduled transaction log backups (which truncates, marks as reusable the VLF's) then you may need to increase...
May 31, 2013 at 9:18 am
Post the actual execution plan for the query (save it as a .sqlplan and attach it to a post on this thread).
Also, need the DDL for the table including the...
May 31, 2013 at 9:08 am
Total shot in the dark:
select
mt.studentId,
max(mt.Finishdate) as MaxDate
from
dbo.myTable mt
where
exists(select 1 from dbo.myTable mt1 where mt.studentid...
May 31, 2013 at 9:02 am
mirvin 50540 (5/31/2013)
Small Int. That why I created ST_NUM_TXT, which is varchar(10)
And that is why your values are being converted to smallint's.
Read the following and look closely at the...
May 31, 2013 at 8:39 am
Noticed you have two columns, [ST_NUM] and [ST_NUM_TXT]. What is the data type for [ST_NUM]?
May 31, 2013 at 8:33 am
What is the data type for [APPT_NUM]?
May 31, 2013 at 8:19 am
The problem you are running into is that you are using float for your rate. This results in the multiplication of Amount * Rate results in a float...
May 30, 2013 at 9:05 pm
Sean Lange (5/30/2013)
Lynn Pettis (5/30/2013)
To which I said, find an appropriate forum on SSC and post your question there, and I'm not assisting from a PM.
Which they promptly did and...
May 30, 2013 at 1:05 pm
Luis Cazares (5/30/2013)
I'll save that...
May 30, 2013 at 12:47 pm
Viewing 15 posts - 7,441 through 7,455 (of 26,490 total)