LutzM

Forum Replies Created

Viewing 15 posts - 1,291 through 1,305 (of 5,502 total)

RE: Help Needed for SQL Query

Something like this?
;with cte as
(
select *,
historyid - row_number() over(partition by letterNo order by historyid) row
from #Test
),
order_grps as
(
select row, row_number() over(order by min(historyid))-1 as row2 from cte group by...

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]

July 11, 2011 at 3:51 am

#1350976
RE: Comapare Datetime type

Would you please be a little more specific?

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]

July 11, 2011 at 12:22 am

#1350889
RE: Mortgage amortization table

I brought it down to 1.20 E-31 by using 1073.64324602427796965698515822583333 for the loan_pmt (don't ask where I got that number from 🙂 ).
I think the major issue is the lost...

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]

July 10, 2011 at 8:08 am

#1350826
RE: Insertion into multiple tables

Can you provide a short test scenario (table def for the import table and the target tables including a few rows in each table) so we have something to work...

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]

July 10, 2011 at 5:26 am

#1350810
RE: How to display the columns which are never used??

It depends.
Is all the business logic implemented inside SQL Server (using stored procedures, views, functions and the like)?
If so, you could analyze the object definitions:
SELECT DISTINCT so.name, so.[object_id], so.type
FROM...

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]

July 10, 2011 at 5:20 am

#1350808
RE: I am not a Schema

@Jeffery:
Microsoft's official solution: modify all code to use join hints (I'm guessing hash or merge)
Do you have any source available for that statement?

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]

July 10, 2011 at 4:02 am

#1350804
RE: Multiple OUTER JOIN query is slow

... They take arbitrary length strings - is there a problem with a UDF doing the same?
Have a look at this link[/url]. there seems to be a significant performance...

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]

July 10, 2011 at 3:31 am

#1350801
RE: Multiple OUTER JOIN query is slow

Jeffrey Williams-493691 (7/9/2011)
In addition to all of the advice given so far - you really need to look at how you are using those functions. Scalar functions are notoriously...

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]

July 10, 2011 at 3:09 am

#1350800
RE: Multiple OUTER JOIN query is slow

Here's what I would do:
Step 1: fix the data type used in / returned by the functions involved (e.g. [fnsFormatAkcesit] will never exceed 17 byte, therefore the data type for...

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]

July 9, 2011 at 5:42 pm

#1350778
RE: Executing a SQL View from Excel using VBA

I just tried to connect from Excel 2007 to a view in SQL 2005. It worked without any issues.
Maybe the connection you're using to from Excel doesn't have permission 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]

July 9, 2011 at 3:04 pm

#1350761
RE: Are the posted questions getting worse?

If I would have to stop on a highway (or Autobahn as we call it over here) other than because of a traffic jam, I'd immediately run and jump behind...

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]

July 9, 2011 at 2:54 pm

#1350759
RE: Multiple OUTER JOIN query is slow

As you noticed, SQLServerCentral (or SSC) is slightly different than most of the other db forums. It's more a community, not just a forum. Therefore, we prefer to clarify an...

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]

July 9, 2011 at 2:45 pm

#1350757
RE: Insertion into multiple tables

Where exactly do you get stuck?
The concept I would use is to call a stored procedure with the parameter Comp_Name, KPI_name, date and value. You'd need to make sure Comp_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]

July 9, 2011 at 6:27 am

#1350729
RE: Delete Query and 'Transaction Log is full' Error

I'm definitely not going to argue with you Gail, but wouldn't horizontal partitioning with a Sliding Window be an option to consider?
To be more specific:
If the business case would allow...

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]

July 9, 2011 at 6:10 am

#1350728
RE: Multiple OUTER JOIN query is slow

...could we stick to the problem I described in my original post? ...
We still do.
The issue with VARCHAR(MAX): it's a Large Object Data Type, which is a special data type...

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]

July 9, 2011 at 4:32 am

#1350720

Viewing 15 posts - 1,291 through 1,305 (of 5,502 total)