Viewing 15 posts - 5,506 through 5,520 (of 7,499 total)
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
- http://www.davidemauri.it/DasBlog/CategoryView,category,Sql%20Server%202005.aspx
CREATE view [V_partitioned_objects]
as
select distinct
p.[object_id],
index_name = i.[name],
index_type_desc = i.type_desc,
partition_scheme = ps.[name],
data_space_id = ps.data_space_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 23, 2007 at 7:54 am
- I think you should post in sql2005 (sys.sysusers)
- be carefull with users being actual dbowner !
- be carefull with users owning objects in databases
- Indeed you need to handle...
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 7:53 am
With SQL2005 you can use server ddl triggers to detect / intercept those kind of actions.
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 4:43 am
Viewing 15 posts - 5,506 through 5,520 (of 7,499 total)