LutzM

Forum Replies Created

Viewing 15 posts - 781 through 795 (of 5,502 total)

RE: Remote execution of stored procedure is timing out

There are multiple possible reasons for the slow performance.
Here are a few I can think of:
Network issues (e.g. due to a large size of the result set), blocking due to...

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]

December 17, 2011 at 3:50 am

#1422813
RE: Are the posted questions getting worse?

Stefan Krzywicki (12/16/2011)
L' Eomot Inversé (12/16/2011)
Stefan Krzywicki (12/16/2011)
SAP = Blech
SAP = a lot worse than just Blech
In addition to many of the faults I already knew about, it is SO...

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]

December 17, 2011 at 3:07 am

#1422809
RE: BI Business Plan for the next 5 years

What exactly is your question?
We don't know anything about the company you're working for nor the extent you're using BI at the moment nor anything about the business plan of...

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]

December 16, 2011 at 3:20 pm

#1422751
RE: How to have an element and an attribute value in a tag

Brent Seeney-273128 (12/14/2011)
I need an XML element that has an attribute and an element value. The result required is such:
<Party>
<CustomerID Role="SENDER">1122334455</CustomerID>
<Name>SomeOne</Name>
...

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]

December 15, 2011 at 2:52 am

#1421797
RE: File Locations and SANs

You might want to have a look at my question on a similar thread.
It's not as much focused on the location of the file itself but more on the SAN...

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]

December 14, 2011 at 12:33 pm

#1421544
RE: Microsoft Sql server standard download

vkr.karthick (12/13/2011)
yes, we have a erp product that should be installed in standard edition. now it is in testing stage so we required trial edition.
Whoever sells you that product should...

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]

December 13, 2011 at 1:01 pm

#1420842
RE: Things to consider before migrating SQL 2005 to ORACLE DB

Dev (12/13/2011)
...
‘Tools with Technician’ and ‘Weapons without soldier’, aren’t you suggesting the same? :w00t:
Not sure about the latter, but definitely the former 😀

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]

December 13, 2011 at 5:40 am

#1420537
RE: Things to consider before migrating SQL 2005 to ORACLE DB

Like I stated before:
There are tools available claiming to be able to convert in that direction (SQL Server to Oracle).
A google search should help.
Will those tools help you to...

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]

December 13, 2011 at 5:08 am

#1420514
RE: Things to consider before migrating SQL 2005 to ORACLE DB

If you really want to go down that route, you'll need to verify the T-SQL code can actually be migrated into Oracle (will be "fun stuff" if you're using Service...

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]

December 13, 2011 at 3:24 am

#1420467
RE: how different could it be joining a #temp_table Vs @table_variable?

We'd need to see the function itself together with DDL of all tables involved to make any suggestion. It sounds like a scalar function anyway. So, the next question would...

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]

December 13, 2011 at 1:10 am

#1420401
RE: Are the posted questions getting worse?

Evil Kraig F (12/12/2011)
...
Nah, he used the front portion of the crown. It's about the hardest portion of your body, he's fine. I've done that a few times...

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]

December 12, 2011 at 4:48 pm

#1420312
RE: how different could it be joining a #temp_table Vs @table_variable?

The major difference in this scenario is the missing statistic information. If you look at the actual execution plan, you'll se a big difference between estimated number of rows (=1...

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]

December 12, 2011 at 4:29 pm

#1420311
RE: Query to find which columns have different values in a pair of rows

Evil Kraig F (12/9/2011)
LutzM (12/9/2011)
Wouldn't the UNPIVOT approach be a little easier?
:blush: Yes.
Pardon me, I need to find a mirror. I know someone who deserves a facepalm 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]

December 9, 2011 at 3:36 pm

#1419650
RE: Query to find which columns have different values in a pair of rows

Wouldn't the UNPIVOT approach be a little easier?
;
WITH cte AS
(
SELECT *
FROM
(SELECT *
FROM tblCompare) p
UNPIVOT
(Vals FOR col IN
(col1,col2,col3,col4)
)AS...

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]

December 9, 2011 at 3:12 pm

#1419646
RE: Need help creating a new table from rows of existing table

The solution to your question usually is referred to as PIVOT or CrossTab query. A link to an related article referencing the latter can be found in my signature.
In general,...

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]

December 9, 2011 at 10:13 am

#1419524

Viewing 15 posts - 781 through 795 (of 5,502 total)