Viewing 15 posts - 16 through 30 (of 37 total)
even if i do the inner join i'm getting the same
all i'm trying to do is to find out what jobs overlap each other. In this case i need...
April 2, 2008 at 9:20 am
but will using SAVE sort of commit the transaction but will make reversible
November 30, 2007 at 12:49 am
nice article
look like you've missed () in tip2
if HOST_NAME='Somemachine' then return
has to be
if HOST_NAME()='Somemachine' then return
November 13, 2007 at 10:55 am
As a general remark - i had a problem with CLR function which was executed about 200000 times a day and was building XML strings up to 300 characters...
October 18, 2007 at 11:02 pm
Matt, just for fun - compare the memory usage when you run CLR udf and udfTRANSELATE
October 18, 2007 at 10:41 pm
it all depends on how the function is going to be used...
October 18, 2007 at 1:01 am
have you tried analyzing your query in the Database Engine Tuning Advisor? How big is the Sessions tabe? What is the spec of the server?
October 18, 2007 at 12:57 am
Jeff Moden (10/18/2007)
Max Yasnytskyy (10/17/2007)
Yeah, but he is using some sort of prefilled table isn't he?
Yep... you should try it 😀 Works well on a lot of things and...
October 18, 2007 at 12:31 am
Sergiy (10/18/2007)
Max Yasnytskyy (10/17/2007)
Jeff Moden (10/17/2007)
Max Yasnytskyy (10/17/2007)
P.S. i'm mainly working with SQL 2005 and assume that everyone else too works on it:)
I'm working on SQL2000 and playing with SQL2005.
Still...
October 18, 2007 at 12:28 am
how i understand this:
i have a logging in place which writes to the table when user starts and in the same row marks the end time when user finishes his...
October 18, 2007 at 12:14 am
Jeff Moden (10/17/2007)
Max Yasnytskyy (10/17/2007)
I have found an interesintg function in msdb, seems like it is working much better ...
Ummm... this is an SQL Server 7/2000 forum... wanna tell us...
October 17, 2007 at 11:59 pm
Not sure if i am right in understanding what you are trying to achieve, but
I've created a test table
CREATE TABLE [dbo].[tmpTimeSpans](
[UserID] [int] NULL,
[Start] [datetime] NOT NULL,
[EndTime] [datetime] NOT...
October 17, 2007 at 10:20 pm
Sergiy (10/17/2007)
SELECT A.some_fields, B.some_fieldsFROM A
LEFT OUTER JOIN B ON A.f1=B.f1
WHERE func(A.something)=true
Clause "func(A.something)=true" is big NO-NO in queries.
Results in table scan every time.
Rethink your query to avoid such calls.
So what...
October 17, 2007 at 9:55 pm
Yeah, but he is using some sort of prefilled table isn't he?
October 17, 2007 at 9:36 pm
Viewing 15 posts - 16 through 30 (of 37 total)