My problems...

You should probably contact Sibel support. I think you are probably changing the table too fast and auto update stattistics is triggered on each invocation OR the app is actually...

Script it out. and run the generated script on the remote server

If HT is turned off you still need to check for power saving settings in your server. Sometimes the Frequency is reduced when low activity is detected and it causes...

Backup and restore could also be used.

balbirsinghsodhi (6/16/2008)

---

Does the recovery process fills the transaction log. ?

and also is there a gurantee that database will be in a perfect shape. the reason I am asking if we...

No. recovery must finish to ensure that logs are re-played.

DBA (6/16/2008)

---

hi guys, i have an issue, i am trying to query my profiler results, to be specific my duration column, i am trying to conver from miliseconds to seconds,...

nealwright44 (6/16/2008)

---

Hi,

I'm using SQL 2005 T-SQL.

I'm need to extract partial data from a concatenated address field.

The address field contains 5 elements, each separated by '/n'.

In this particular example, I need...

I suspect that the OP has abandoned this thread 😉

Openquery just...

declare @TABLEA Table ( ID int , Name varchar(20) )

declare @TABLEB Table ( ID int , Subject varchar(20) )

insert into @TABLEA ( ID, Name )...

tmbasha (6/15/2008)

---

Hi,

Thanks all of you, for your valuable suggestions. Below i am providing the estimation size of different tables with index also which resides on single file i.e. Primary.... may...

umaramiya (6/16/2008)

---

Hi,

Currently I am developing a Job Portal using SQL Server 2005. I have certain queries like searching the Candidate/Job with keywords. which needs very high performance. Already important fields...

I would go for "RECOMPILE" statement option. That way you will get the appropriate plan for any value pair. This of course comes at a recompilation time price, it may...