Hi,

I am very happy to see that this is not only my issue and there are a lot of peoples that are stuck like me with Standard edition because tight...

Hi,

Assuming that you use the auto statistics create & open and have all the statistics updated well, i think that it will be better to read from the statistics and...

Hi,

Great procedure !

Do you have some procedure that is also taken care of "auto" creating new partitions (...and deletes the ones that are close to 1000 limit) for SQL 2008...

Ok, thanks for the script, it's only a start but i need something a little bit else.

Let's say for example that i have a table named Orders with fields OrderId...

Hi all,

I found a great product that is running as a GRIDSCALE and it's activating like a active/active cluster, take a look:

http://www.xkoto.com/

P.B.

If you will buy it, just send...

Use this:

SELECT top 1 *

FROM dbo.sysobjects o, master.dbo.syslockinfo l

WHERE l.rsc_objid = o.id

AND name = ''

an locked object will be in syslockinfo table,...

Thank you very much !!!

I so searched for something like this.

Btw, don't i need a 'close' (..nothing) for the cob=nnection ?

Again, thank you very much.

Victor

Hi,

Shrinking datafiles is not a good idea in generally but if you have to do it, use a loop with small chunks of sizes to shrink, for example something like...

Hi,

Did you implement this logon trigger in a production heavy environment ?

I am asking this because i read few articles about big problems with logon triggers in heavy environments, sql...

Listen,

It sounds to me that you need to get deeper in the running sql code and not playing with the indexes, 30 minutes for a batch it sounds me as...

Hi,

I need more information in order to 'see' the entire picture and to help you with a good solution.

1. What sql version and sp ?

2. Is fregmentation your source of...