Viewing 15 posts - 5,506 through 5,520 (of 7,506 total)
it's the physical processors that count, not the number of cores.
So in your case 2 will be the number of processors to license if you want to enjoy your 4...
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 30, 2007 at 2:05 pm
post upgrade steps:
-rebuild all indexes !
-sp_updatestats;
-dbcc updateusage (0) with count_rows;
-dbcc freeproccache
And offcourse then make full backups !
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 30, 2007 at 2:04 pm
this may be hard to find out, depending on the traces you are running.
Maybe even a log-analyser kind of application can dig into your msdb-logfiles to find out, if possible,...
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 30, 2007 at 1:59 pm
Peter Gadsby (10/29/2007)
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 9:00 am
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
Viewing 15 posts - 5,506 through 5,520 (of 7,506 total)