Faster, maybe. It depends. SQL caches execution...

riix (8/12/2008)

---

why not add in diagrams and foreign key constraints? surely there's a perf penalty to consider when every fk is constantly yet needlessly checked by the dbms when...

I may go through on the sunday,...

Jayakrishnan (8/12/2008)

---

In complex stored procedures we are using one or two temp tables. It was working fine initially. But DBA suggested us to add the following lines in the SP...

andrew gothard (8/12/2008)

---

Well - usually in QA once it's written. Prototype in MS - then you get that sinking feeling when a colleague comes up to you baffled that...

TheSQLGuru (8/12/2008)

---

As long as you are doing seeks the extra index depth level that comes from larger average key size comes very infrequently thus the 1 page addition. It...

Hehe. There is no free version. Visual Studio Team Edition is the highest level edition of Visual Studio....

Views cannot take parameters. If you need a view-like object that takes parameters, consider using a table-values user-defined function. Be careful, sometimes they have a bad impact on performance.

Ok, a little more challenging, but not much so. Needs a subquery.

SELECT Log_Transactions.assetno, Log_Transactions.pcdatetime, Log_Transactions.tline

FROM Log_Transactions INNER JOIN

(SELECT asstno, MAX(pcdatetime) AS LatestDate FROM Log_Transactions) MaxValues

ON Log_Transactions.asstno = MaxValues.asstno AND...

You're getting repeated rows because you're grouping by the tline as well as the asset number. If you want to see the max tline for eachn asset number (which is...

:hehe: Congratulations....

andrew gothard (8/11/2008)

---

Was thinking of this one

http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/

Think we all know how often people seem to get parachuted into 'looking after the database(s)' and over the years I've seen a pretty...

Are you perhaps switching to simple recovery mode to do the index rebuilds?

Switch traceflag 1204 or 1222 on (DBCC TRACEON (1222,-1)). That will write the deadlock graphs into the error log. With that you can see what is deadlocking and on what...

And another one.

http://sqlinthewild.co.za/index.php/2007/12/19/temp-tables-and-table-variables/