Hi,

I didn't check your calculation, but # reads means the number of pages that needs to be read to execute the query. One page is 8kB.

Cheers

Hi,

My recommendations:

Postcode

If you always have same length then use char(<length>). If it can have different lengths like international postcodes, safest is nvarchar(<length>).

Telephone Number, Mobile Number

These can indeed be tricky:...

Hi,

An indexed (materialized) view would solve the performance issue. If the base tables are very frequently updated there can be an issue as the view update puts extra load on...

Hi,

My first thought is that it should work for storage, but can be tricky if you have to do operations (mathematical, aggregations, ...) on the data.

Cheers

Hi the_justin,

I am glad the problem is solved. I think it was a very interesting one. 🙂

Cheers

Hi,

Glad you sorted it out. I have never tried tracing triggers. I guess there might be some implications as they are not procedures to be called. That might explain that...

Hardy21 (11/23/2010)

DougieCow (11/23/2010)

Hardy21 (11/23/2010)

INSERT INTO #

SELECT 'ASDF'

GO 0

GO <ZERO> --- SQL doesn't throw any complilation error but when you execute the code, status bar should display: "Query completed with...

Hi,

These links explains it:

Troubleshooting Insufficient Disk Space in tempdb

Capacity Planning for tempdb

Cheers

Hi Denesh!

There is a DATABASE shared lock on a database for every connection. You can test this by open some query windows to a certain database in Management Studio and...

Hi the_justin!

Maybe I am getting this wrong, but from your second output it seems that you want to group dt and cat with minutes precision on dt.

So these are in...

Thanks Philipp for the nice poster! Really handy

Cheers

Hi,

Here is an article that might help you:

Tracing Trigger Execution

Cheers

This question fooled me 🙁

Thanks Hugo for the great walkthrough, I learned something new 🙂

Cheers

Hi,

I would suggest to consider using the TOP clause to set number of rows deleted in one statement:

delete top (<nbr>) from <table>

where ID = <value>

The nbr should depent on size...

"I have followed the same steps and found that some stored procedures having highest duration abnd IO/CPU.

But my developer saying i can't further tune with query as this is the...