Viewing 15 posts - 4,756 through 4,770 (of 8,416 total)
vidya_pande (3/19/2010)
Please refer to the books online link for how many bytes each data types takes.msdn.microsoft.com/en-us/library/ms187752.aspx
It is rather more complex than that, though that can be useful to provide...
March 28, 2010 at 6:39 am
Bhuvnesh (3/26/2010)
...function dbo.uf_utl_SplitNString gives comma separated values of prod_name column.
Is that a multi-statement table-valued function, or in-line?
March 28, 2010 at 6:24 am
luthrarahul (3/27/2010)
Feebie (10/14/2009)
hi, could you please let me know how to import data from more than 2 Excel files to sql server table.
Why did you add that?
March 28, 2010 at 6:20 am
Also, see Estimating the Size of a Database in Books Online 😉
March 28, 2010 at 6:19 am
vidya_pande (3/27/2010)
it has nothng to do with statistics or restating the server.. its transaction handling issue. logic not written correctly
Agreed. I think Sudarsan Srinivasan will be seeing this problem...
March 28, 2010 at 6:16 am
Thanks for the feedback.
March 28, 2010 at 6:04 am
Perry Whittle (3/28/2010)
Having said that when carrying out normal maintenance on...
March 28, 2010 at 6:03 am
You might also want to consider partitioning this table at some stage, to make maintenance tasks easier. Local partitioned views can be made to work well if you...
March 28, 2010 at 5:57 am
pandrikopoulos (3/28/2010)
As you probably know deleted records are not physically removed in SQL Server for performance reasons.
That is only strictly true for a heap, not a table with a clustered...
March 28, 2010 at 5:54 am
This is an annoying issue. I used to work around this by creating an extra non-partitioned index on the partitioned table.
The extra index had to be dropped before, and...
March 28, 2010 at 5:04 am
vidya_pande (3/27/2010)
this has been improved in 2008. Seek happens at partition level and not at total table level.[Partition-Aware Seek Operation]
Doesn't help at...
March 28, 2010 at 4:59 am
The table was never rebuilt before since in SQL Server 2000 downtime is needed to perform such operations.
The question is, have you run DBCC UPDATEUSAGE on the whole database since...
March 28, 2010 at 4:51 am
GregoryF (3/26/2010)
It was a 2TB DB and took about 45 minutes to run a full backup
2TB of data? That would almost be a record - see http://www.sqlskills.com/BLOGS/PAUL/post/High-end-backup-compression-numbers.aspx
So here is...
March 28, 2010 at 3:56 am
Timothy,
This type of problem (the corrupted file) is the main reason I never use a physical file for more than one backup. There's really no advantage, in any case....
March 28, 2010 at 3:46 am
vidya_pande (3/27/2010)
you can not back up two databases in a single file. Are you trying to do this?
This is incorrect.
March 28, 2010 at 3:39 am
Viewing 15 posts - 4,756 through 4,770 (of 8,416 total)