You searched for the word(s): userid:692488

More Search Options

RSS Available

• Re: Auto logon with Windows Authentication

  Thanks for all the advise. Managed to resolve by using Host name instead of Host IP. Thanks again.

  Posted to Security (Forum) by ysliew on 9/15/2009

• Auto logon with Windows Authentication

  Hi all, I'm facing some problems when integrating Windows Authentication into my web application. Scenario 1) All the users are currently logon to their pc through a Domain with Windows Active Directory authentication. 2) The web application will be auto logon as long as they are authenticated. In anohther words, as long as they can logon to the windows, they will be auto logon to the web app once they click the app link. I'm refering to article Recipe: Enabling Windows Authentication within

  Posted to Security (Forum) by ysliew on 9/14/2009

• Re: Auto logon with Windows Authentication

  Hi sukumarraju, I have tried set to false, however the prompt still popup. Any idea? Thanks.

  Posted to Security (Forum) by ysliew on 9/14/2009

• Performance comparison of using WHILE and CURSOR

  Hi all, Recently I learned about CURSOR and I found most experts advise not to use it due to performance issue. However, I found using CURSOR is much faster than using a WHILE for looping. Thus, I would like to seek for some valuable advices. Basically I would like to loop each record in my record sets and perform some actions based on the selected field from each row. In order to simplify my scenario, I have created a sample here for comparison. 1. Create a table variable with 10k records. SET NOCOUNT

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ysliew on 6/26/2009

• Re: Performance comparison of using WHILE and CURSOR

  Hi Nikola, Thanks for your advise, and I just noticed that by adding the PRIMARY KEY will speed up the WHILE loop a lot. DECLARE @MyData TABLE(pk INT IDENTITY(1,1) PRIMARY KEY, id INT) Basically I have few tables to store system data of application, and those data maybe added/updated from time to time. Thus, I have a master script to store the latest data and will be executed on the client's server upon application update. What I'm currently doing is, 1. Create a table variable with identical

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ysliew on 6/26/2009

• Re: Custom Pagination with Complex Queries

  Thanks again for your reply. I just feel that's very hard to predict the no of records to be selected, as the Row Number will not be known until the final UNION. Anyway, your proposed approach worth a try, thanks

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ysliew on 6/26/2009

• Re: Custom Pagination with Complex Queries

  I think I got your point, now the problem is just how many records to be selected in each union and form the final union. That is hard to determine as the worst case we might have to select all records for UNION. Anyway, thanks for your opinion. :)

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ysliew on 6/23/2009

• Re: Custom Pagination with Complex Queries

  Hi Naomi, Thanks for your prompt reply. Could you elaborate more on the followings? RowNum > @StartNumber - NumberOfUnions* PageSize (e.g. select more records than needed here just in case of overlap) I guess you are trying to select a range of records from different UNION, am I right? Thanks.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ysliew on 6/22/2009

• Custom Pagination with Complex Queries

  Hi all, Currently my application is facing slow performance due to the growth of data. After reading some articles, I have a brief understanding on how pagination works. However, I would like to ask for some advice on implementing pagination for complex SQL with lots of JOIN and UNION. For simple SQL, I use the following approach. -- * Pagination with Simple Query -- SELECT * FROM ( SELECT field1, field2, field 3, ROW_NUMBER() OVER ( ORDER BY field1) AS RowNum FROM table1 ) AS Result WHERE Result

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ysliew on 6/18/2009

• Re: Custom Pagination with Complex Queries

  The page will not show a million of rows unless the users search for a long date range. I found that the performace will break down when user selects the >> (Last Page) of the pager. I guess this is due to the records reside at the most bottom part of the selected query and thus affect the performance while the 1st page load is quite fast. Also, I need to use UNION to avoid duplicate records.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by ysliew on 6/18/2009