ChrisM@Work

Forum Replies Created

Viewing 15 posts - 9,091 through 9,105 (of 10,143 total)

RE: Select top random rows ?

Mark Shvarts (12/18/2008)
I need to get a sample random rows from a table. Top will get only first records, but I need my sample to be evenly distributed. The table...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 8:06 am

#914570
RE: Totally Dumb Dev Question

Hi Shaun
Wasn't this a qotd earlier in the year?
INSERT INTO table Default Values
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 8:02 am

#914566
RE: Replacing Case statement in UPDATE

dhanasekar.palani (12/18/2008)
That is the whole query. You are right it hits the performance. can you give some idea to write in the condition instead as a case statement.
Yep, move the...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 7:57 am

#914562
RE: Replacing Case statement in UPDATE

Can you post the whole statement? It's unlikely that the CASE construct - as you've posted it - will cause much of a performance hit.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 7:45 am

#914547
RE: Temp table usage in dynamic sql

dongadoy (12/18/2008)
Yes, a global temp table is an option. Just have to remember the concurrency issue - can't have multiple processes executing the code concurrently, or have different code using...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 7:43 am

#914544
RE: Temp table usage in dynamic sql

GilaMonster (12/17/2008)
If you create the temp table in dynamic SQL, the temp table will go out of scope and be dropped as soon as the dynamic SQL ends. There's no...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 7:29 am

#914529
RE: Return missing hours from a table

Can you post some sample data please Fred? The link in my sig will explain how to do this.
Many thanks
ChrisM
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 6:48 am

#914488
RE: Spot the incorrect syntax please..!

Ninja's_RGR'us (12/18/2008)
And there I was thnking you knew everything about everything ;). Now that dream is gone for me.
There I was thinking you dreamed about SQL Server, and all...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 6:45 am

#914482
RE: Want to select Records with null values

sar_kan25 (12/18/2008)
I have a table Info with Name, address,Mob.No.,Designation as Columns.
Some of the records in the table contain null values.
Now i want to write the select query which will give...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 5:14 am

#914414
RE: group by and difference

Join table1 twice...
SELECT...
FROM table2 t2
INNER JOIN table1 y ON y.coulmn3 = t2.column4 AND y.column2='Y'
INNER JOIN table1 n ON n.coulmn3 = t2.column4 AND n.column2='N'
GROUP BY...
If this fails because of the aggregate,...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 4:20 am

#914385
RE: Count number of occurancies

bhushanhegde (12/18/2008)
Hi,
I dont have rights to create any objects in the data base since that is in production.
I want to do with any sys defined functions....is it possible?
Yes.
DECLARE @TargetString VARCHAR(100),...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 1:57 am

#914351
RE: Count number of occurancies

Thank you for the prompt answers.
There are several ways to do this, my preference would be a function using a tally-table - are you permitted to add a utility table...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 1:49 am

#914349
RE: Count number of occurancies

bhushanhegde (12/18/2008)
Hi,
My string is as follows:
'hurrycanecathurrycanecatand dod race'
I want to find out character 'a' how many times occured in the above string.
pls help me.
What have you tried so far?
How do...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 1:38 am

#914345
RE: Query to fill in missing dates in a series of rows

Jeff Moden (12/17/2008)
bnordberg (12/17/2008)
Thanks Chris!
that appears functional. Now to tune and see how it works with a few hundred million rows!
Why on Earth do you need to create what is...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 18, 2008 at 1:21 am

#914338
RE: help begginer to loop with T-SQL

Davor Geci (12/17/2008)
I'm new in T-SQL,
can someone help me with big problem for me, but redicilus problem for a T-SQL programmer?
I have 3 tables:
Table1, Table2, Table3
Table1 is having 100 records...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

December 17, 2008 at 3:17 pm

#914202

Viewing 15 posts - 9,091 through 9,105 (of 10,143 total)