Hi everybody,

I used to make some tests of the exponential approach, also posted some results on SSC and it was faster than any other approach (we are talking about large...

Hi mj,

it would be very very helpfull if you post the actual execution plan and table structure/indexes, so it will be obvious where the most of the time is spent....

Hi,

Is it a mistake in the posted SQL, or it REALLY queries the modifiedByUserID column ? Try first putting an index on it, too.

Regards,

Goce.

Hi Gilbert,

I work with cyrillic characters in varchar columns all the time, without using Unicode. This is the usual sequence of steps that works, at least in my case:

1. I...

Hi Sam,

I ment something like this (a standard approach):

table Languages:
ID Name
1  English
2  Spanish
...

table Texts:
ID Default_Text
1  textHere
2  something
...

table Translations:
Language Text_ID Translation
1      ...

Hi Anton,

while the approach with additional fields looks more simple, it actually isn't: first, you have unstable table structure, that needs to be changed each time you add a language....

Hi all,

Here are my 2 cents: On ORACLE, actually it makes a difference how you order columns. I am not sure if this stands for M$$QL, too, but it makes...

Hi Mike,

ORACLE has packages on the database level, and they perform exactly that way - initialize themselves on per session basis. I'm afraid that M$$QL doesn't have that feature, at...

Hi all,

here is the script I wrote for myself, according to the puzzle specification. It also contains some sample data.

CREATE TABLE SPECIES(
  spcid INTEGER primary key,
  spcname VARCHAR(100)
)
GO

CREATE...

Hi Thomas,

so somebody tried to puzzle you, too :-).

I suppose that mail originated from somewhere ... so we can still obtain some more info about the puzzle origin.

Regards,

Goce.

Hi Thomas,

Why did you post the puzzle as a contest ? It was not listed in the official contests list on SSC. I don't like situations like this, when it...

Here is my solution:

SELECT
  am.antim_id AS antim_id, am.anitm_name AS antim_name
FROM
  (SELECT
     antim_id, COUNT(dc.missile_id) AS num_missiles
   FROM
     (SELECT
 ...

Hi all,

2 questions:

1. why the first puzzle message isn't showing ? (I am new to contests, so this may be normal).

2. why the puzzle is not listed at the official...

Duplicate post

http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=181202

Hi Stefan,

As usual, during performance optimization, you should estimate your needs and maybe make a tradeoff: if the given structure cannot perfectly satisfy all of your queries, then it should...