Can you please take a look at the question at the following link and try to help me?
View Complete Post
I have a stored procedure where the performance is bad. The Execution plan shows 5 table scans each of cost 12%. The data is being pulled from the table using the following where clause.
where (datestamp>getdate() - 'sep28 1902 12:00 AM')
I already have an index on Datestamp column but still Table scan is happening. There is no restriction on avoiding index is specified in the query.
If the index is place inappropriately there would be index scan but here I have table scan.
Could anyone help me in finding out why this is happening.
I have a problem with geography data type replication. Any change that is done on a Geography column breaks the replication - the error message is "The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the
article at the Subscriber." I double checked compatibility settings that is suggested here:
http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/d8e31621-5d43-48cd-bdd3-c02b8a24625c. But both publisher and subscriber are 100RTM.
I checked synchronization logs and found a strange message - attempt to convert varchar to geography. I don't understand from where the varchar data type comes from. Tables at subscriber and publisher has the same format - geometry stored in geography data
2010-09-20 18:36:22.499 The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber. This can occur when there are pending DDL changes waiting to be applied at the Subscriber. Restart
the Merge Agent to apply the DDL changes and synchronize the subscription.
2010-09-20 18:36:22.845 Category:NULL
Source: Merge Replication Provider
I have the following table variable that i store rows extracted from an
declare @tbl_ans table ( AnsText nvarchar(max), IsCorr bit)
this cannothave an index column.
assume it has 25 rows, i need insert each row to a table that has three columns
That Answers table has following structure:
The script should iterate through the @tbl_ans_table table and insert each to the answers table then i should fetch each
a_idx in each iteration and insert it to another. But the problem is how itereate through
@tbl_ans_table without an index?
In my VB.Net code I am using boolean type and it is later stored through a stored procedure to a MS SQL database table. I have so far allways been using "int" as the column type in database table because there is no Boolean type to choose from when designing the columns of a table in the MS SQL Express?
Is it correct to use the column type int for storing Boolean values?