This is a different question.

Thanks

Thanks to all

Can you provide me with a more efficient splitter thanks I am going to try to convience normalizing.

You are right

Thanks

Thanks

05/30/2012 23:46:49,,Information,[098] SQLServerAgent terminated (normally)

05/30/2012 23:46:48,,Error,[359] The local host server is not running

05/30/2012 23:46:47,,Error,[359] The local host server is not running

05/30/2012 23:46:46,,Warning,[360] SQLServerAgent initiating shutdown following MSSQLSERVER shutdown

05/30/2012 23:46:46,,Error,[140] AutoRestart:...

Please here is my function that needs improvement to perform what is mentioned in the excel spreadsheet

Thanks in advance

CREATE FUNCTION [dbo].[fn_UpToNowPercentage_dropL_table]

( @SectionID int,

@StudentID int

)

RETURNS table

AS

return

(

...

Thanks a lot.

Those links were helpfull.

Thanks for your reply

Please can you clarify more what is meant by With a fill factor of 100, any insert of data will cause an initial page split if it's...

Yes my primary key is clustered index

Thank you so much

Thank you all

Thanks a lot

is there a script to drop all fk referencing a particular pk in all tables

and another script to recreate all fk referencing a particular pk

since I have around...

I am using declare @tempmy table to perform the following scanerio. I want to know if cte is better to do that because my sql server has high memory usage...

Thank you all

where shall i use the crossapply

thanks a lot

My code takes long to execute. I need help to reduce the execution time

1) I have an xml document big one I reduced the size using xslt and ssis

2)...