ChrisM@Work

Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 10,143 total)

RE: Are the posted questions getting worse?

Sean Lange (4/29/2015)
andrew gothard (4/29/2015)
Sean Lange (4/28/2015)
Lynn Pettis (4/28/2015)
Lynn Pettis (4/28/2015)
Wow, what some people expect us volunteers.
The OP just PMed me with all the info that had been posted on...
^{“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

April 29, 2015 at 7:21 am

#1794275
RE: Identity column insert issue

You haven't given us much to work on. How similar are the tables supposed to be?
^{“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

April 28, 2015 at 5:23 am

#1793896
RE: Need help to calc information, based on prev and next lines within the table

BOR15K (4/24/2015)
...I have a list of flights - an itinerary with a request to find a final destination. The steps to find that final are as following:
1. Find the longest...
^{“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

April 27, 2015 at 7:48 am

#1793660
RE: Update takes too long

hemal_301080 (4/27/2015)
Igor Micev (4/27/2015)
Ok,
If you create an index on Lotno,Kapan and Position it should improve the selection in the where condition.
where Lotno=@Lotno
...
^{“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

April 27, 2015 at 1:57 am

#1793582
RE: String Manipulation

sql_novice_2007 (4/23/2015)
I have following strings in the full name field.
first,,
first,,last
,middle,last
I want to have the following results
first
first,last
middle,last
need to remove the unwanted , in the full name string.
How can I 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

April 23, 2015 at 9:33 am

#1793035
RE: Insert DATE --Confused with convert

Datetimes should be stored in your tables as datetimes, and are displayed in the SSMS grid control in the format you are now familiar with. You can display them in...
^{“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

April 22, 2015 at 6:42 am

#1792703
RE: Insert DATE --Confused with convert

challakarthik (4/22/2015)
Hi Experts,
I have created a table Employee with Hire_date with datatype as datetime.Then inserted a row with date converted to style 109[ convert(varchar(30),'01-Jan-2013 12:00:00:000AM',109)
After I have inserted ,while retrieving...
^{“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

April 22, 2015 at 6:05 am

#1792691
RE: The Elusive Conditional WHERE Clause

peter-757102 (4/21/2015)
Even with some of the harsh feedback that comes with publishing I feel the need to write at least one article myself.
Certainly I owe many of the previous writers...
^{“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

April 21, 2015 at 8:57 am

#1792442
RE: The Elusive Conditional WHERE Clause

John Hick-456673 (4/20/2015)
Thank you, Jeff, and you, Jason. I've learned more from lurking on SSC than I did in my CS classes back in the day.
You two,...
^{“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

April 21, 2015 at 7:28 am

#1792394
RE: Today's Random Word!

crookj (4/20/2015)
Eirikur Eiriksson (4/20/2015)
Ed Wagner (4/20/2015)
BWFC (4/20/2015)
Hippy
Happy
Flip
Wilson
Picket
^{“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

April 20, 2015 at 7:19 am

#1792013
RE: How a new partition Function apply for Current Data

MotivateMan1394 (4/15/2015)
I have a heavy database , More than 100 GB only for six month .
every Query on it takes me along time and I dont have enough space to...
^{“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

April 20, 2015 at 7:18 am

#1792012
RE: Optimisation of SELECT query

You can explore the reasons why this query is performing poorly using a simplified model of your query - one of the EXIST subqueries.
Here's yours. The filter for postcode isn't...
^{“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

March 31, 2015 at 5:40 am

#1787643
RE: Query plan for partitioned views not running as they should.

josjonkmans (3/30/2015)
I did find a solution for the problem, I was using an SQL account for my linkedserver connections. When I changed it to use the "Be made using 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

March 30, 2015 at 4:52 am

#1787267
RE: Are the posted questions getting worse?

Luis Cazares (3/27/2015)
In a different order of ideas, I want to share with you my happiness.
Starting on April 21st I'll be working in the US. I'll make a stop at...
^{“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

March 27, 2015 at 10:41 am

#1786986
RE: Number of times a specific day of month occurs between 2 dates?

rarara (3/27/2015)
Hi, am trying to get to grips with the syntax needed for this...here is one set of example values...
StartDate(this is numeric): 20150305
EndDate(this is numeric): 20150905
MonthlyPaymentDay: 1
PaymentAmount: 125
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

March 27, 2015 at 10:38 am

#1786984

Viewing 15 posts - 2,521 through 2,535 (of 10,143 total)