LutzM

Forum Replies Created

Viewing 15 posts - 346 through 360 (of 5,502 total)

RE: I am running this store procdure on new query window and it works fine but when it run through sql server agent it gives me error in three steps...

fawad.majid (11/14/2013)
...
In sql server agent job this procedure runs 69 steps and every step is separate,
Do you have a job step similar to EXECUTE [dbo].[usp_MU_Format2] or are there...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 14, 2013 at 11:25 am

#1666484
RE: Is this a bad habit i need to clean up after?

Just a pot shot:
It might be driven by the developer who want to make sure the key is unique but wasn't able to define a UNIQUE PRIMARY KEY (for good...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 14, 2013 at 11:07 am

#1666476
RE: I am running this store procdure on new query window and it works fine but when it run through sql server agent it gives me error in three steps...

You've posted as single stored procedure but you refer to SQL Server Agent failing in a couple of steps. Please clarify.
What are the exact steps being called in your SQL...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 14, 2013 at 10:35 am

#1666466
RE: T-SQL puzzler - given a cell in an N-dimensional space, return the cells that are inline with the given cell along each axis

I'm not sure if I fully understood the requirement (especially for N>3)...
My assumption: a cell is "inline" if all but one value match the cell coordinates in question.
"All but one"...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 14, 2013 at 10:19 am

#1666460
RE: Are the posted questions getting worse?

Lynn Pettis (11/13/2013)
Lynn Pettis (11/13/2013)
It is 23:27 Afghan time. Three minutes until my phone interview. Wish me luck!
Just finished the interview, and I feel like a Junior DBA....

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 13, 2013 at 5:44 pm

#1666249
RE: CAST Issue on join Creating index scan - poor performance

What's the reason for the CAST conversion?
It seems like o.invoiceid is already a character data type. What exact data type are the two columns referenced in the join predicate (o.invoiceid...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 13, 2013 at 2:57 pm

#1666222
RE: Concat columns in Where clause

I'm not saying either of the solutions is right or wrong. Both are just different in terms of the final result. They're just not equivalent.
Whether the current approach works...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 13, 2013 at 11:04 am

#1666159
RE: Concat columns in Where clause

GilaMonster (11/13/2013)
Jonathan Marshall (11/12/2013)
The queries are updating lookup tables that do not have a value by using a subquery to the lookup table.
I like that idea of using a...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 13, 2013 at 10:13 am

#1666145
RE: Limit the number of months to the last three months using ssrs

It depends on the query being used to get the raw data.
It might be sufficient to add a "TOP 3 ... ORDER BY Year DESC, Month DESC" to the underlying...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 12, 2013 at 4:51 pm

#1665898
RE: XML Export File

hunchback (11/12/2013)
Because the requirement is to have an xml file, not a caracter text one, with the prolog / encoding / descriptor or whatever it is. SQL Server does not...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 12, 2013 at 4:41 pm

#1665895
RE: Tablas con índice y opción IGNORE_DUP_KEY=ON problemas en los bloqueos al insertar en la tabla

Ich habe keine Ahnung, wovon du sprichst, Luis!
(I have no idea what you're talking about, Luis!) 😀

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 12, 2013 at 2:45 pm

#1665882
RE: Conditional query

@Kyr_Soronas: I though about an approach towards what mickyT came up with, but just without the "fancy geometry stuff" (@mickyT: no offence intended 😉 )
However, instead of using computed columns,...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 12, 2013 at 2:07 pm

#1665874
RE: bulk export of xml column

It would be great if you could provide a more detailed scenario (e.g. table definition, sample data, your current approach and the expected result).
To simply copy the in- and...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 12, 2013 at 1:58 pm

#1665871
RE: Concat columns in Where clause

@eric:
From my point of view, every approach will lead to the same execution plan including the table/index scan (including the MERGE approach).
A rather dirty approach would be a separate column...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 12, 2013 at 1:24 pm

#1665861
RE: Conditional query

Flip the start and end positions where start >= end so you can use a "standard query" and add constraints to ensure start <=end.

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

November 12, 2013 at 1:10 pm

#1665855

Viewing 15 posts - 346 through 360 (of 5,502 total)