ChrisM@Work

Forum Replies Created

Viewing 15 posts - 3,421 through 3,435 (of 10,143 total)

RE: Query optimization help

EasyBoy (4/23/2014)
I have also noted one more thing.
I can't to modify existing index due to business rule. So, i havent used AI_OperatorCBGEstimate_14947. But i have created new index(AI_OperatorCBGEstimate_HAP) with 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

April 23, 2014 at 5:30 am

#1708048
RE: Drop Identity column from temp table

Eirikur Eiriksson (4/23/2014)
ChrisM@Work (4/23/2014)
hoseam (4/23/2014)
Now that's an easy one cause I created a table for you, so you are working with the data you know. say now the user input...
^{“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, 2014 at 5:10 am

#1708042
RE: Drop Identity column from temp table

hoseam (4/23/2014)
Now that's an easy one cause I created a table for you, so you are working with the data you know. say now the user input tblDef_RETURNS as 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

April 23, 2014 at 4:48 am

#1708035
RE: Drop Identity column from temp table

hoseam (4/23/2014)
...the user should be able to insert any table name as an input...
If you're updating two very specific columns, they should exist in one very specific table, surely?
If not,...
^{“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, 2014 at 3:40 am

#1708009
RE: Drop Identity column from temp table

Eirikur Eiriksson (4/23/2014)
Is it this that you are looking for?
😎
SELECT *
INTO #MyTemp
FROM Sales.SalesOrderHeader;
SELECT *
FROM tempdb.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE N'#MyTemp%'
DROP TABLE #MyTemp;
Would you do it like this Eirikur or would you...
^{“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, 2014 at 2:54 am

#1708000
RE: Drop Identity column from temp table

hoseam (4/23/2014)
For now I'm using SELECT ... INTO
SET @InsertSQL = 'SELECT * INTO Hosea_tempTable FROM ' + @TableName +' WHERE (Product_Id = '+ QUOTENAME(@Product_Id, '''''') +' or Product_Id = ''''...
^{“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, 2014 at 2:45 am

#1707996
RE: Drop Identity column from temp table

hoseam (4/23/2014)
The scenario is this..
I have a product AGP with Fund E01, and other attributes
then later I want to creat another product with the same attributes as AGP...
^{“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, 2014 at 2:27 am

#1707988
RE: How to convert nvarchar to date data type?

aar.mba (4/17/2014)
I have to convert nvarchar to date data type. and fetch the week number of that particular month from the column
Pls find the sample data
CREATE TABLE #mytable
(
current_week nvarchar(30)
)
insert...
^{“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, 2014 at 2:22 am

#1707985
RE: Drop Identity column from temp table

hoseam (4/23/2014)
... the perm table name will be passed as a input parameter, then take all the it's data into temp table to update them, then put them back into...
^{“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, 2014 at 2:10 am

#1707980
RE: Getting heirarchy

We'll need some sample data and a table of expected results. Read this article [/url]which describes how to create and post your scripts.
^{“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, 2014 at 1:49 am

#1707977
RE: Are the posted questions getting worse?

GilaMonster (4/22/2014)
ChrisM@Work (4/22/2014)
And yes, every other plan the OP posted show only KeyInstn and DateEndedStandard coming out of the index seek, as you'd expect.
Systems here won't let me anywhere...
^{“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, 2014 at 9:52 am

#1707822
RE: Query optimization help

A little more info - this is the same question on MSDN:
[Quote]I have one simple query to optimize but somehow after creating couple of index this query is still having...
^{“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, 2014 at 8:22 am

#1707783
RE: Are the posted questions getting worse?

Greg Edwards-268690 (4/22/2014)
ChrisM@Work (4/22/2014)
Greg Edwards-268690 (4/22/2014)
Ed Wagner (4/22/2014)
dwain.c (4/21/2014)
Greg Edwards-268690 (4/21/2014)
TomThomson (4/20/2014)
Greg Edwards-268690 (4/20/2014)
Bucket List Challenge - teach Jim to Filet a fish properly.
I'll keep trying, but I may fail...
^{“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, 2014 at 8:10 am

#1707778
RE: Are the posted questions getting worse?

GilaMonster (4/22/2014)
ChrisM@Work (4/22/2014)
The question I'm asking is here - http://www.sqlservercentral.com/Forums/FindPost1563832.aspx and the query, to save you a few moments, is this:
select KeyInstn, MAX(dateendedstandard) DateEndedStandard
from ObjectViews..InternalOperCBGEstimate
where dateendedstandard...
^{“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, 2014 at 7:30 am

#1707758
RE: Are the posted questions getting worse?

GilaMonster (4/22/2014)
ChrisM@Work (4/22/2014)
Does anyone around here know anything about output lists from index seek operators, by any chance?
Maybe, what do you want to know?
See above, Gail. You'll remember 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

April 22, 2014 at 7:12 am

#1707746

Viewing 15 posts - 3,421 through 3,435 (of 10,143 total)