Viewing 15 posts - 2,146 through 2,160 (of 2,452 total)
Kiara (10/28/2011)
J Livingston SQL (10/28/2011)
have you any performance figs...you say your query is "slow"...based on the test data what...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 28, 2011 at 1:26 pm
Ok...got the test data now (dev machince at work 🙂 )
have you any performance figs...you say your query is "slow"...based on the test data what response times are you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 28, 2011 at 12:29 pm
Hi Ki
I will try again with your test rig....earlier on I thought it was my PC playing up...until I saw Jeff's post.
think I will reboot and start over.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 28, 2011 at 12:11 pm
Jeff Moden (10/28/2011)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 28, 2011 at 11:55 am
with no data/examples/require results to work on....
pure guess...have you tried LEFT OUTER JOINS?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 27, 2011 at 11:03 am
+1...please, it would be much appreciated.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 25, 2011 at 9:50 am
one way that may work for you, dependent upon the data.....
SET fax_number_varchar = CAST(fax_float as int)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 24, 2011 at 2:00 am
Phil Parkin (10/23/2011)
Can you please try again to explain what you are...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 23, 2011 at 8:00 am
just an idea :
USE [tempdb]
GO
CREATE TABLE [dbo].[TableXY](
[Y] [int] NOT NULL,
[XMIN] [int] NOT NULL,
[XMAX] [int] NOT NULL,
[RESULT] [int] NULL,
CONSTRAINT [PK_TableXY] PRIMARY KEY CLUSTERED
(
[Y] ASC,
[XMIN] ASC,
[XMAX] ASC
)
) ON [PRIMARY]
GO
INSERT INTO...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 23, 2011 at 7:20 am
Have you researched SSAS (Analysis Services) as Ninja suggested?
! am learning a course on Data Warehousing. Any fact table in a data warehouse may be accompanied by aggregate fact tables...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 22, 2011 at 1:38 pm
does this work for you:
order by LEFT(name,1), ASCII(name) desc
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 21, 2011 at 4:54 am
MidBar (10/17/2011)
In one query, starting either at "Select" OR ";With"
hmmm...:-)
this is quite a speciic statement ...that is also clearly prescribed on the "Challenge" under
__________________________________________________________
1 . Restrictions
The...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 18, 2011 at 10:33 am
is the OP question related to the following article:
http://www.sqlservercentral.com/articles/T-SQL+Challenges/76259/
??
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 18, 2011 at 10:17 am
To erhanduman ..the OP
I hope that we havent hijacked your original post to the extent that you are unable to find some ideas.....;-)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 16, 2011 at 10:30 am
Performace Guard (Shehap) (10/15/2011)
create table #temptable (F1 int, [F2.1] varchar (20), [F2.2] varchar (20), [F2.3] varchar (20))
insert into #temptable (F1 )
select...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 16, 2011 at 7:58 am
Viewing 15 posts - 2,146 through 2,160 (of 2,452 total)