Viewing 15 posts - 91 through 105 (of 174 total)
Why would "2013-05-04" be an off day AND 'G'?
Why does your query have SpendTime, excesshorttime when the example of what you want doesn't have it?
You also give no...
June 15, 2013 at 7:03 am
select c.DATE, s.eid, isnull(s.Shift,'O'), s.timein, s.timeout
from Shift s right outer join calendar c on s.date=c.date
Like this? The "shift" table would be replaced with the table containing "timein" etc
June 15, 2013 at 5:55 am
It should be something similar to this I guess. You need to identify the columns for the table join though:
Select (SELECT
case LTRIM(RTRIM(RIGHT(coalesce(t2.fielda,'') + coalesce(t2.fieldb,'') + coalesce(t2.fieldc,''))
,LEN(coalesce(t2.fielda,'') + coalesce(t2.fieldb,'')...
June 13, 2013 at 4:02 pm
Sean Pearce (6/11/2013)
A simple decimal point will do the trick.
SELECT 1./2
Perhaps but I was assuming he wants this for a stored procedure or something passing parameter values~...but then I guess...
June 11, 2013 at 6:46 am
Do you mean calculate more accurately the size before actually creating the table?
If so, at least some of inaccuracy may be that you would need to factor in the block...
June 10, 2013 at 8:47 am
This was so interesting 😮 went through it along with the simple-talk tracing articles & just finished (slow reader -_). I'm gonna read through your other articles tomorrow (or as...
June 8, 2013 at 4:00 pm
opc.three (6/8/2013)
Maybe not stop, try clearing the trace, that will definitely force a flush to disk.
Yep. "sp_trace_setstatus 2, 2" sorted it.
June 8, 2013 at 10:45 am
GilaMonster (6/8/2013)
No, it writes continuously.
Only if you fill the buffer it seems.
buffer_countbuffer_sizefile_positionreader_spidstart_timelast_event_timeevent_count
2128131072NULL2013-06-08 16:43:42.0602013-06-08 16:48:40.92316
Mine runs for 20 mins then goes from 0kb to 128kb since I just ran like 5...
June 8, 2013 at 9:51 am
Gail, does it only write out to file at the end of the trace or is it just because I'm not stressing my instance enough?
June 8, 2013 at 8:56 am
GilaMonster (6/8/2013)
June 8, 2013 at 8:04 am
GilaMonster (6/8/2013)
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
Wow, great articles 😮 didn't know about server-side traces, can't wait to test on prod ^_^ a couple questions though:
1. You said you were going to add the modified...
June 8, 2013 at 7:03 am
jnuqui (6/7/2013)
And how would you know really that this is the answer to the questions anyway?
I would assume that the purpose of an exam is that you answer the...
June 7, 2013 at 5:56 am
I don't think HP would be impressed with you cheating Raymund.
June 7, 2013 at 5:21 am
It might help if you paste one of this multi-layered queries from Access so we can see it.
June 7, 2013 at 4:08 am
You are default to int. Int is an integer (whole number). This means that it will remove any decimal places from the value.
e.g. 6/4 will return 1 instead of 1.5
To...
June 7, 2013 at 3:55 am
Viewing 15 posts - 91 through 105 (of 174 total)