tag:blogger.com,1999:blog-6082652835152798567.post7848139945370273874..comments2024-03-18T23:22:46.913-07:00Comments on Sql server, .net and c# video tutorial: Indexed views in sql server - Part 41Unknownnoreply@blogger.comBlogger12125tag:blogger.com,1999:blog-6082652835152798567.post-77855890095752257932019-04-17T15:15:34.821-07:002019-04-17T15:15:34.821-07:00I would like to know how can i accomplish this exe...I would like to know how can i accomplish this exercise with foreign key constraint, because currently is not any relation between two tables. How can the User knows which Article which ID has? Ali Ajdadihttps://www.blogger.com/profile/03020265886840593942noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-86710567843272439162018-12-25T21:17:57.335-08:002018-12-25T21:17:57.335-08:00How does we know indexed view may contain data or ...How does we know indexed view may contain data or not<br />Anonymoushttps://www.blogger.com/profile/09895981155575485986noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-85784914761135142582018-08-20T07:30:13.129-07:002018-08-20T07:30:13.129-07:00What happens when we Update the Indexed Views,Eith...What happens when we Update the Indexed Views,Either the Data in the Base table gets Updated<br />Parshihttps://www.blogger.com/profile/17181923934563483360noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-70079928945006158532018-06-16T11:49:20.695-07:002018-06-16T11:49:20.695-07:00You have to use sp_helptext unclusidx_vw_productwi...You have to use sp_helptext unclusidx_vw_productwisesales<br /><br />Instead of sp_helpindex unclusidx_vw_productwisesales<br /><br />because it is view not an index.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-79559880656615547402018-04-15T06:01:32.065-07:002018-04-15T06:01:32.065-07:00sp_helpindex idx_vw_productwisesales.
sp_helpindex...sp_helpindex idx_vw_productwisesales.<br />sp_helpindex must be executed on an object (in your case it is a view) to know what are the indexes present on that particular object. Anonymoushttps://www.blogger.com/profile/18142088718814709918noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-73226293548996862922018-02-24T03:20:20.257-08:002018-02-24T03:20:20.257-08:00thanQ Soo much venkat..Now i get more clarity abou...thanQ Soo much venkat..Now i get more clarity about indexs and viewsAnonymoushttps://www.blogger.com/profile/05622680059022579599noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-79303495940983197132018-02-21T02:11:30.885-08:002018-02-21T02:11:30.885-08:00create VIEW idx_vw_productwisesales
WITH SCHEMABI...<br /> create VIEW idx_vw_productwisesales<br /> WITH SCHEMABINDING <br /> AS<br /> SELECT name, sum(isnull((quantitysold*unitprice),0)) AS [total sale],<br /> count_big(*) as [total trasation] FROM dbo.product <br /> JOIN dbo.productsales<br /> ON dbo.product.productid=dbo.productsales.productid <br /> GROUP BY name<br /> <br /> create UNIQUE CLUSTERED INDEX unclusidx_vw_productwisesales ON idx_vw_productwisesales(name)<br /><br />indexed view is created but when i use <br /> sp_helpindex unclusidx_vw_productwisesales<br /><br />it showing error<br />Msg 15009, Level 16, State 1, Procedure sp_helpindex, Line 38<br />The object 'unclusidx_vw_productwisesales' does not exist in database 'sql_db' or is invalid for this operation.<br /><br />but the indexed view is created in my db <br />can anyone help me out<br />Anonymoushttps://www.blogger.com/profile/16947012321284766438noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-17445392399044689682017-03-30T04:21:21.117-07:002017-03-30T04:21:21.117-07:00Thank you sir for such a nice tutorial.
I wanted t...Thank you sir for such a nice tutorial.<br />I wanted to know when the materialized view is updated, i.e. if I update a row in base table then how that data is updated in materialized view.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-45574774385185697942017-01-26T09:11:18.188-08:002017-01-26T09:11:18.188-08:00Thanks a lot. I wish this video was there in 2010 ...Thanks a lot. I wish this video was there in 2010 itself. Evry concept was so confusing then with your videos they seem so simple and understandable.<br />sowmyahttps://www.blogger.com/profile/00485720334183935031noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-89454649510408555982016-07-09T09:27:56.349-07:002016-07-09T09:27:56.349-07:00i support your saying .. most condidates who are f...i support your saying .. most condidates who are following his lessons , are getting better jobs.Anonymoushttps://www.blogger.com/profile/06321465681611065725noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-13987846242721920042016-06-15T03:09:49.614-07:002016-06-15T03:09:49.614-07:00Believe it or not folks.. i got the job bcoz as .n...Believe it or not folks.. i got the job bcoz as .net developer bcoz of venkat sir where in system test i got the question like insert the data into the table and display it in gridview on single button click both should happen at the same time.. i did it without any errors.. All the credit goes to Venkat sir... Rajendra Prasad C Shttps://www.blogger.com/profile/17875055263930674992noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-34616748735311638232016-06-07T22:26:55.984-07:002016-06-07T22:26:55.984-07:00Thank you So much Venkat,For your amazing You tube...Thank you So much Venkat,For your amazing You tube Chanel, <br />You are the only guy which will make things very easy<br />Anonymoushttps://www.blogger.com/profile/15214644257676033092noreply@blogger.com