Hi Angela,

I have seen many posts of this kind on SSC so far. Usual suggestion is to solve the problem at the presentation level, not at the database level. I...

http://www.sql-ex.ru

Hi subban,

clustered indexes are usually said to be usefull when selecting and ORDERed recordset or when filtering on the index prefix (leading portion of columns). What do you expect from...

Or, you can re-use what has already been posted here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=99869

Regards,

Goce.

Hi Dilip,

I think that you should see the execution plan for the SP. Looking at the SQL statement, it seems to me that SQL Server will use nested loop, but...

Hi there,

about the benefits mentioned, I don't know how M$$QL treats this issue, but on ORACLE you can save some space if you order the columns as Frank wrote. For...

Hi Frank,

At the end of the "Truncating the Transaction Log" article of BOL it is explicitly stated: "Truncation does not reduce the size of a physical log file, it reduces...

Hi Joan,

Try this one:

SELECT TOP 1
  DATALENGTH(ldtext), *
FROM
  longtescription
WHERE
  ldtext IS NOT NULL
ORDER BY
  DATALENGTH(ldtext) DESC

The first column in the result set will contain the actual...

Hi Matt,

will this help you ?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=4&messageid=152361</a?

I think it is a similar problem.

Regards,

Goce.

Hi there,

I don't consider myself as one of the Farrell's true gurus :-), but I still cannot accept the fact that M$$SQL's query execution engine has an undiscovered bug that...

Hi,

the usual rule of thumb is to first solve the problem that is causing the most of the problems. So, start the SQL Monitor and observe the execution of SQL...

Hi,

write the table definition like this:

DECLARE @InterestIncome Table (
 Period_Amount FLOAT,
 Regular_Calendar_Key INT,
 Scenario_Key INT,
 Hierarchy_Key INT,
 Service_Type_Key INT,
 Category_Key INT,
 Concept_Key INT,
 Event_Key INT,
 Fiscal_Calendar_Key INT,
 PRIMARY KEY
 (
...

Hi Felipe,

I came up with this procedure.

create procedure families_report
as
  create table #tmp(
    id int not null,
    rank int not null,
   ...

Hi Felipe,

If you limit the result set to a fixed number of columns (according to examples, this will be 3), I think that there is a solution to the problem....

Hi all,

I still think that you cannot (or a least should not) avoid altering those SPs, because a data type change is not an issue that can pass without major...