did you free the db's proccache after the reindex ?

Possibly the old cached plans nolonger serve optimal with the new statistics and organisation.

Mahi (1/14/2009)

---

We have decided to go for inplace upgrade.Since we don't have enough place for side by side.we have a vendor application on this server it supports only sql 2005,...

Who doesn't every once in a while 😉

Maybe this helps you figure out what's going (wr)on(g).

SELECT @@VERSION

GO

IF OBJECT_ID ('id_test') IS NOT...

GSquared (1/14/2009)

---

Something that strikes me as possibly erroneous in this query is that it has a Left Join, but there's a Where clause on the second table of the join....

SELECT A.SOLD_TO_CUST_ID

, C.NAME1

, DATEDIFF(DAY, ( CONVERT(CHAR(10), B.STATUS_DT, 121) ), GETDATE()) as DtDiff

...

Could you also post your version number of SQL2005 ?

Select @@version

-- or

Select Serverproperty( 'ProductVersion' ) as ProductVersion

, Serverproperty( 'ProductLevel' ) as ProductLevel

, Serverproperty( 'ResourceLastUpdateDateTime' )...

here's a starter :

- simplyfied http://www.extremeexperts.com/sql/articles/BestPractices.aspx

- http://vyaskn.tripod.com/sql_server_administration_best_practices.htm

- http://msdn.microsoft.com/en-us/sqlserver/bb671432.aspx

Jeff Moden (1/13/2009)

---

So! Did it work? Enquiring minds want to know! 😛

Holy moly... you are a very patient human... 470 hours... 19.58 days. And to think I...

If you cannot fine any reasonable / related message in sqlservers errorlog,

I would suggest to at least run DBCC CheckDB (for the db if you know it, if you...

IMO your variable is declared to small !! char(10) seems rather small.

Be sure to match you declared size to the size of the column in de table ddl.

DECLARE @Driver_Name...

a log file can only shrink up to the last virtual log file it has in use.

This script will write dummy data to the log file, until it's first VLF...

Can you check it restrictions apply to the number of user connections ?

/* "user connections" is an advanced config setting

enable show advanced options */

exec sp_configure 'show advanced...

Feedback:

I've upgraded the dev servers to SP3 and got the approval to re-test it in cooperation with one of our biztalk devs.

After I activated the "old" logon trigger again, the...

Did you read:

-SQL2005 http://msdn.microsoft.com/en-us/library/ms188706(SQL.90).aspx

-SQL2008 http://msdn.microsoft.com/en-us/library/ms188706.aspx

-WP: http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

- http://www.sqlservercentral.com/articles/SQL+Server+2005/61765/

- http://www.sqlservercentral.com/articles/Development/3144/

- http://msdn.microsoft.com/en-us/library/ms345146.aspx

- http://www.sqlservercentral.com/Forums/Topic414210-338-1.aspx

- http://www.sqlservercentral.com/Forums/Topic623669-360-1.aspx

also keep in mind, if partitioning an existing table, you may still end up with DOWN TIME for your application(s)...

As always, play it safe and start with a full backup scenario of ALL your databases (including systems databases !)

If all backups completed successfully, only then start the sp3 exe.

Read...