LutzM

Forum Replies Created

Viewing 15 posts - 2,341 through 2,355 (of 5,502 total)

RE: Virtualize or not ?

Ok, so at least you have a budgetary number to compete against... 😉
Get a quote from your vendor how much it would cost to replace the "heaviest" c.u.r.s.o.r.s.
Once that's done,...

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 23, 2010 at 12:33 pm

#1266041
RE: Help writing query logic

Something like this?
DECLARE @tbl TABLE
(
DATE DATETIME, OrderNmbr INT, Transtype VARCHAR(10), Amount INT, InvoiceinPer CHAR(1)
)
--/*
INSERT INTO @tbl
SELECT '12/1/2010', 12345 ,'Inv', 1000 ,'N' UNION ALL
SELECT '12/3/2010', 12345 ,'Credit', -1000 ,'N' UNION...

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 23, 2010 at 10:25 am

#1266015
RE: How to do UNPIVOT with dynamic column names within a FUNCTION

Wouldn't it be more efficient to have one table ANTI_RES with a column AB_CODE, a column for the sensitivity result and one for the sample?
With such a structure you wouldn't...

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 23, 2010 at 9:44 am

#1266001
RE: First time semi-complex query - its slow!!!

skcadavre (12/23/2010)
To add to this, I had a similar issue not too long ago which was solved on this forum.
Try going over this.
Hmmmm... your last statement in the link...

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 23, 2010 at 9:35 am

#1265996
RE: Are the posted questions getting worse?

If you're referring to the "Call in the Experts" editorial: sure I did and it demonstrated how much more efficient an organization can be if people know what they don't...

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 23, 2010 at 9:27 am

#1265993
RE: Virtualize or not ?

rmechaber (12/23/2010)
...it honestly sounds like you'd likely get more performance bang for your buck by doing that than you will by virtualizing. ...
Just to make sure there is no misinterpretation:...

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 23, 2010 at 9:24 am

#1265989
RE: Table for Object with Multiple States

I think the table design needs to be re-evaluated...
Basically there are products, sections and status history per product and section. There might be section groups as well (at least what...

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 23, 2010 at 7:57 am

#1265942
RE: Virtualize or not ?

I was reading a white paper yesterday on virtualizing SQL Server and there was something about "physical I/O path".
Care to share the link? Others might benefit from it.

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 23, 2010 at 4:35 am

#1265856
RE: SPARSE vs XML vs EAV

I'd go with the XML approach but shred it into relational data behind the scenes (noone needs to know 😉 ).

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 23, 2010 at 4:30 am

#1265855
RE: How to load data into SQL Server in which columns are formated vertically

If I understand correctly, you have two questions:
a) how to load the file into SQL Server and
b) how to shred the data into tables
a) load the (unshredded) file (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]

December 23, 2010 at 4:18 am

#1265852
RE: Table for Object with Multiple States

rootfixxxer (12/23/2010)
No one... 🙁
One reason for not getting an answer yet might be a missing table structure (reduced to the relevant columns) with some sample data so we can visualize...

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 23, 2010 at 3:56 am

#1265847
RE: Sql query Output in XML format

Hi Wayne,
the reason for the additional empload tag is the "ROOT('empload')" code snippet.
The ROOT element basically is the "wrapper" around the xml code since a wellfomrmed xml needs a covering...

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 23, 2010 at 2:50 am

#1265825
RE: Sort Data by Time but start at specific time

Here's one version to define the order:
ORDER BY CASE WHEN cast('19000101' + ' ' +StartTime as datetime) >'19000101 11:30:00:00' THEN 0 ELSE 1 END, StartTime
But I strongly recommend 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 22, 2010 at 4:56 pm

#1265745
RE: Logic

sounds like homework...
There are three choices:
a triangular self join,
a recursive CTE, or
a "quirky update" approach.
If it's homework, go for the first. If it's performance critical and there are people...

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 22, 2010 at 4:36 pm

#1265742
RE: Sort Data by Time but start at specific time

What's the data type of StartTime?

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 22, 2010 at 4:22 pm

#1265738

Viewing 15 posts - 2,341 through 2,355 (of 5,502 total)