Viewing 15 posts - 4,141 through 4,155 (of 7,502 total)
The tricky part for most of us is: How do you size your tempdb ?
Nicholas Cain (1/15/2009)
...My tempdb is vastly larger than it will ever need to be. ....
Do you...
January 16, 2009 at 1:55 am
Phillip Oyog (1/15/2009)
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...
January 16, 2009 at 1:46 am
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...
January 16, 2009 at 1:02 am
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...
January 16, 2009 at 12:14 am
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...
January 15, 2009 at 12:51 pm
did you free the db's proccache after the reindex ?
Possibly the old cached plans nolonger serve optimal with the new statistics and organisation.
January 15, 2009 at 10:39 am
Mahi (1/14/2009)
January 14, 2009 at 2:47 pm
raymond.lew (1/14/2009)
Hello, I have an identity problem.
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...
January 14, 2009 at 2:31 pm
GSquared (1/14/2009)
January 14, 2009 at 2:10 pm
SELECT A.SOLD_TO_CUST_ID
, C.NAME1
, DATEDIFF(DAY, ( CONVERT(CHAR(10), B.STATUS_DT, 121) ), GETDATE()) as DtDiff
...
January 14, 2009 at 6:40 am
Could you also post your version number of SQL2005 ?
Select @@version
-- or
Select Serverproperty( 'ProductVersion' ) as ProductVersion
, Serverproperty( 'ProductLevel' ) as ProductLevel
, Serverproperty( 'ResourceLastUpdateDateTime' )...
January 14, 2009 at 3:39 am
here's a starter :
- simplyfied http://www.extremeexperts.com/sql/articles/BestPractices.aspx
- http://vyaskn.tripod.com/sql_server_administration_best_practices.htm
January 14, 2009 at 12:22 am
Jeff Moden (1/13/2009)
Holy moly... you are a very patient human... 470 hours... 19.58 days. And to think I...
January 14, 2009 at 12:18 am
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...
January 14, 2009 at 12:07 am
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...
January 13, 2009 at 11:59 pm
Viewing 15 posts - 4,141 through 4,155 (of 7,502 total)