Viewing 10 posts - 1 through 10 (of 10 total)
That's really a great explanation by Kingston and in fact the question can be posted in multiple ways where the following is one such type
Declare @customer Table ( ID int
...
August 19, 2013 at 6:10 am
What if i define @s-2 as BIGINT
Can you give me a real time scenario as in this operator would be useful. i am just a bit curious as...
July 2, 2013 at 2:30 am
be aware that by using an External Select Statement we are going to have an Extra tag being added in the XML File. So we have to take care of...
March 19, 2013 at 1:30 am
Rather you should keep in mind that you will not be allowed to do any properties that affect the deterministic nature of an indexed view like full-text predicates or references...
August 21, 2012 at 5:47 am
It is truly not suggestible to use an Indexed View when the tables are highly transactional as you mentioned. But if the priority is reporting then you can use the...
August 21, 2012 at 5:41 am
Really an interesting topic to go through. These days i am seeing a lot of Front End developers who don't even know the basics of DB and will go for...
August 16, 2012 at 4:33 am
I think DTS is not an option here as we need to have sql server agent to schedule the DTS packages.
Possibly we can develop the package on the standard version...
April 19, 2012 at 1:50 am
@sqlist
But with select into you cannot have an identity column , you have to use row_number otherwise , which may affect the performance when you are dealing with large number...
August 10, 2011 at 7:53 am
A very good article , it really enhances the performance just by using the identity columns in #Temp and ##Temp tables rather to using order by while inserting the rows...
August 9, 2011 at 1:37 am
Really a very nice article to spare with. But , In case of tables containing large amounts of data , i think it's not a good practice to use CharIndex....
August 11, 2010 at 2:46 am
Viewing 10 posts - 1 through 10 (of 10 total)