tag:blogger.com,1999:blog-6082652835152798567.post7138284425064405116..comments2024-03-19T00:55:43.409-07:00Comments on Sql server, .net and c# video tutorial: Indexes in sql server - Part 35Unknownnoreply@blogger.comBlogger23125tag:blogger.com,1999:blog-6082652835152798567.post-2301946060228860242021-08-05T00:49:00.145-07:002021-08-05T00:49:00.145-07:00anyone who have collated notes bu Kudvenkat?anyone who have collated notes bu Kudvenkat?xhttps://www.blogger.com/profile/03084279230942347300noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-54963760780688998852021-07-02T21:43:28.023-07:002021-07-02T21:43:28.023-07:00To view index its
Execute sp_helpindex tblename
...To view index its <br />Execute sp_helpindex tblename <br />Its not sp_helptextKalpesh patilhttps://www.blogger.com/profile/00153868191160722875noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-89156773836653736492019-06-27T20:24:48.518-07:002019-06-27T20:24:48.518-07:00you're the best teacher sir....
yours all sess...you're the best teacher sir....<br />yours all session are best of best...Sabhajeetkmr9@gmail.comhttps://www.blogger.com/profile/12886693607771547691noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-46512953337747494852018-11-15T23:25:49.365-08:002018-11-15T23:25:49.365-08:00Please edit this..
Execute sp_helptext tblEmployee...Please edit this..<br />Execute sp_helptext tblEmployee to Execute sp_helpindex tblEmployee. Lshttps://www.blogger.com/profile/09270986995776589413noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-53738153304397653552018-10-23T03:41:26.607-07:002018-10-23T03:41:26.607-07:00Hi Venkat, Very beneficial tutorials provided by y...Hi Venkat, Very beneficial tutorials provided by you. I appreciate your effort & thank you so much for all your hard work. God bless youAnuj Dhariahttps://www.blogger.com/profile/12915788375465580799noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-29149894973005264292018-04-26T00:11:44.439-07:002018-04-26T00:11:44.439-07:00whether there is any drawback in creating the inde...whether there is any drawback in creating the index on PKRohanhttps://www.blogger.com/profile/00819254311619617767noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-12202990880965900902018-02-23T04:01:52.772-08:002018-02-23T04:01:52.772-08:00Execute sp_helptext tblEmployee
you mentioned thi...Execute sp_helptext tblEmployee <br />you mentioned this one not working instead of these youcan use<br />Execute sp_helpIndex tblEmployee <br />VidyaSagar Pinnamnenihttps://www.blogger.com/profile/05567206227259477478noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-79819827911220047662017-10-14T12:33:27.676-07:002017-10-14T12:33:27.676-07:00Your explanations are the best Venkat!
Your explanations are the best Venkat!<br />Anonymoushttps://www.blogger.com/profile/17159773321861516844noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-10500533663648912132017-04-25T10:09:50.788-07:002017-04-25T10:09:50.788-07:00Below, please find the SQL Query for creating the ...Below, please find the SQL Query for creating the tblEmployee table.<br /><br />CREATE TABLE tblEmployee<br />(<br /> Id INT PRIMARY KEY NOT NULL,<br /> Name NVARCHAR(20) NOT NULL,<br /> Salary INT NOT NULL,<br /> Gender NVARCHAR(10) NOT NULL<br />)<br /><br />INSERT INTO tblEmployee<br />VALUES (1, 'Sam', 2500, 'Male')<br /><br />INSERT INTO tblEmployee<br />VALUES (2, 'Pam', 6500, 'Female')<br /><br />INSERT INTO tblEmployee<br />VALUES (3, 'John', 4500, 'Male')<br /><br />INSERT INTO tblEmployee<br />VALUES (4, 'Sara', 5500, 'Female')<br /><br />INSERT INTO tblEmployee<br />VALUES (5, 'Todd', 3100, 'Male')<br /><br />SELECT * FROM tblEmployeeAnonymoushttps://www.blogger.com/profile/01832828391833940148noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-66637006061194349912017-02-17T08:42:02.825-08:002017-02-17T08:42:02.825-08:00its sp_helpindex.
Sp_help shows all information bu...its sp_helpindex.<br />Sp_help shows all information but prior shown only about indexes.himanshu pareekhttps://www.blogger.com/profile/16585764404152784870noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-43479937268128255842016-03-23T01:49:27.789-07:002016-03-23T01:49:27.789-07:00I think it Execute sp_helpindex tblEmployee no...I think it Execute sp_helpindex tblEmployee not Execute sp_helptext tblEmployee Anonymoushttps://www.blogger.com/profile/09810435528548921359noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-22941083737913710952015-11-07T17:10:39.498-08:002015-11-07T17:10:39.498-08:00Nagendra , Thanks for rectifying the mistake .Nagendra , Thanks for rectifying the mistake .Ashokhttps://www.blogger.com/profile/10831403694229454718noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-51400080938540391402015-09-21T21:45:35.412-07:002015-09-21T21:45:35.412-07:00Nice Tutorials. Thanks.Nice Tutorials. Thanks.Govind Rawathttps://www.blogger.com/profile/11062402992993900799noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-25882056134774109822015-03-13T01:44:21.417-07:002015-03-13T01:44:21.417-07:00Great Explanation ,i want to say thank you from th...Great Explanation ,i want to say thank you from the bottom of my heartTapan Dubeyhttps://www.blogger.com/profile/00282230931401465601noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-8827251884578922692014-12-09T03:11:14.954-08:002014-12-09T03:11:14.954-08:00Nice tutorial Venkat,very well understood indexes ...Nice tutorial Venkat,very well understood indexes in SQL,ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-6994729693363794952014-06-09T06:39:52.418-07:002014-06-09T06:39:52.418-07:00sp_help 'EmployeeDetails' its not sp_helpt...sp_help 'EmployeeDetails' its not sp_helptextAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-25470441618538543602014-03-29T02:56:42.721-07:002014-03-29T02:56:42.721-07:00 To view the Indexes:
... To view the Indexes:<br /> Execute sp_helpindex tblEmployeeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-87082879206452207312014-02-07T05:36:30.546-08:002014-02-07T05:36:30.546-08:00I am very grateful for all the knowledge learned, ...I am very grateful for all the knowledge learned, thank you very much Pragim.Anonymoushttps://www.blogger.com/profile/15361618163862828607noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-3694432488241893402013-10-27T10:58:42.392-07:002013-10-27T10:58:42.392-07:00Thanks very much... for clear & patient explan...Thanks very much... for clear & patient explanationAnonymoushttps://www.blogger.com/profile/06508084015258422135noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-36454754331339406002013-08-08T05:49:25.711-07:002013-08-08T05:49:25.711-07:00Your tutorials are so easy to understand. Thanks s...Your tutorials are so easy to understand. Thanks so much for all your hard work. I loved your text explanation and all the video tutorials.<br />To add to this - Indexes can be created on either a single column or a combination of columns in a table and are implemented in the form of B-trees.B- Tree is sorted on the search key and can be searched efficiently!Suchihttps://www.blogger.com/profile/14930093115967424470noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-68709035200017244782013-08-04T23:23:06.262-07:002013-08-04T23:23:06.262-07:00excellent demonstration. i am very impressed by se...excellent demonstration. i am very impressed by seeing all this videos. going to make one library for this. very good and very impressive work from you. this will take lots of effort and patience.exceptional work dear..Anonymoushttps://www.blogger.com/profile/04735292927835866200noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-71997449371516602932013-01-26T08:15:45.995-08:002013-01-26T08:15:45.995-08:00Your instructions are so clear and easy to underst...Your instructions are so clear and easy to understand.Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-50841742955440012672013-01-24T01:59:37.619-08:002013-01-24T01:59:37.619-08:00excellent demonstration
excellent demonstration<br />Anonymousnoreply@blogger.com