The tricky part for most of us is: How do you size your tempdb ?

Do you...

Phillip Oyog (1/15/2009)

---

Hello,

This is my first post ever on SqlServerCentral so bear with me. We have a high-availability mirror set up in our office running on Windows 2003 srvr...

What I intended to show is that sqlserver handles it diferently if it as no table content data.

After create it states

Checking identity information: current identity value 'NULL', current column value...

an in place upgrade inherits some settings from sql2000. The goal (from ms) is to keep it working !

With a fresh install of sql2005, it will implement best practises and...

Indeed, freeing the proc cache cause all sql (including sprocs) to be re-evaluated for a plan the next time they execute.

With well organized indexes (including clustered please) and up to...

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...