Viewing 15 posts - 5,506 through 5,520 (of 7,502 total)
just my 2ct.
Don't remove the clustered index ! drop all nci and then truncate the table.
Load the data sorted according to the clustered index definition. This way , your data...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 29, 2007 at 8:33 am
Did you start with a "select * " to see what's the cause of this error ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 29, 2007 at 4:21 am
just another thought ...
avoid FREETEXT !
Freetext <> like !
Maybe a like predicate serves you better.
Check BOL !
WHERE A.City_Name like '%New York%' and A.state = 'NY')
AND ( B.Business_Name...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 29, 2007 at 2:59 am
Just my 2 ct.
I'd first convert the where ... in (select .. ) or ... in ( select ...)
to correlated subqueries lik :
WHERE A.City_Name like '%New York%'
and...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 29, 2007 at 1:19 am
have a look at the new pivot methode:
Pivot table for Microsoft SQL Server
http://www.sqlservercentral.com/articles/Advanced+Querying/pivottableformicrosoftsqlserver/2434/
http://www.sqlservercentral.com/articles/Development/2734/
http://www.sqlservercentral.com/redirect/articles/2791/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 29, 2007 at 12:59 am
you could also use the new "intersect" and "except" clauses to get mutual of different rows in a set ( unjoined ).
http://msdn2.microsoft.com/en-us/library/ms188055.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 28, 2007 at 8:52 am
this would take a tripple join
select ...
from computers C
inner join computers_to_components_relations CCR
on C.ID = CCR.COMPUTER_ID
inner join components Cmp
on CCR.COMPONENT_ID =...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 28, 2007 at 7:11 am
Let us know if it got an A+:w00t:
HTH
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 27, 2007 at 5:45 am
regarding the unavailable files .... if you encounter invalid urls, contact the webmaster. The site has been restyled and suffers some issues of this kind.:ermm:
I've just contaced the webmaster. Normaly...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 27, 2007 at 5:33 am
Oops SQL7-2000 forum ..... offcouse CTE's will not be available for you, nor will outerapply :blush:
CREATE FUNCTION utvf_getDateList_2000 ( @startDate datetime, @endDate DATETIME)
RETURNS @tvfResult TABLE ( effective_date DATETIME NOT NULL...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 26, 2007 at 8:12 am
IMO one should always work with deterministic data, meaning always specify an end date (even if it is way up in the future).
It avoids handling a NULL enddate and urges...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 26, 2007 at 7:56 am
KISS principle :
CREATE PROC spc_Currencyconvertor
@FromCurrencyCode CHAR(3),
@ToCurrencyCode CHAR(3),
@Amount MONEY ,
@CurrencyRateDate DATETIME ,
@ConvertedValue MONEY OUTPUT
AS
BEGIN
SET NOCOUNT ON
IF @CurrencyRateDate IS NULL
BEGIN
SET...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 26, 2007 at 6:21 am
Recursive Queries in SQL:1999 and SQL Server 2005
With nice tests ...
CTE Performance
http://www.sqlservercentral.com/articles/2926/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 26, 2007 at 5:54 am
Nice example.
... 2) The maximum number of levels is 100. This is the limitation of T-SQL. ...
This is not correct! It is the default recursion limit.
Values: 0 - 32767
You can...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 25, 2007 at 2:45 am
I think you can set the front end field property to accept 0 decimals. :hehe:
This way it will not allow decimals.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 23, 2007 at 10:04 am
Viewing 15 posts - 5,506 through 5,520 (of 7,502 total)