I wrote my own PageStatePersister class based on SessionPageStatePersister which writes the most recent 10 Viewstates for a session to a shared disk. I figure this will scale better than keeping Viewstate in session since all web servers have access to it, they won't have to deal with expiration, and use less memory. When a user close...
So suppose I have a bunch of blog entries and I want to find out the most recent comment in each of them, how would I go about finding that out in SQL Server. I have a list of integer id's of these blog entries in a temp table. Something like select top 1 does not work in this case. The approach coming to my mind is looping, and we a...
Hi I'm new to production level web development, so sorry if this is obvious. My site has a potential to have a sudden surge of (permanent) users and I'm wondering what happens if too many users sign up in a short period of time, causing the site to run slowly. Since development takes time, would it just be a case of adding more boxes t...
How can I obtain all stored procedures and their code from SQL Server? I need to show data that is similar to what SQL Server Management Studio shows, incl. allowing to browse through SP's with code, tables and indexes. Any hints on how to get this information out of SQL Server? P.S., I'm using C#. ...
Are there any differences between following two indexes? IDX_IndexTables_1 IDX_IndexTables_2 If there are any, what are the differences? create table IndexTables ( id int identity(1, 1) primary key, val1 nvarchar(100), val2 nvarchar(100), ) create index IDX_IndexTables_1 on IndexTables (val1, val2) GO create index IDX_IndexTab...
My employer currently has most of its access to the database through C# sqlDataAdapters and sqlCommands on a WebServices server or components in applications. These are mostly Windows Forms apps that are ran on intranet and internet depending on their functionality. I have been researching WCF quite a bit and I feel it would be a good f...
Hi, I want to find programatically (with C# code) ALL the SQL servers in relative domains - "brothers", "sons" or "father" domain. It can be done with WMI queries for each domain in the global catalog - but maybe you know about simpler way?? Thank you in advance. ...
Best practice says to keep my web app and database on separate machines, but when doing that it seems I can't get a clear explanation on how best to make this connection. Whil windows auth is the recommended authentication, I don't see how to make a trusted connection . Must I use impersonation to have my application connect to a db serv...
How do you look up a list of language IDs available within SQL Server? I am specifically looking if there are any views within sys schema. ...
I need to do the data conversion from EDI format to XML. is there any step by step tutorial, links about what are the processes on data conversion? How to convert from EDI to XML, step by step guide? I highly appreciate your help. Thanks ...
Hello, I am trying to filter results in an sql query using the like statement. Here are the results /q/my_rat_terrior_is_about_8_just_this_moring_hes_barley_moving_around_panting_heavy_and_shaking_like_shivering/1 /addquestion /addquestion/Validation /q/how_do_you_get_a_hamster_out_of_a_wall/2 These are urls that are stored in my data...
Hai, I'm developing a tool to synchronize SQL Server database with a Pi system (OleDb).Each time there is a change in the Pi System I need to update the values in Sql Server Database and vice-versa.Could you please provide me with the options possible and how it can be done. Thanks, M.K ...
The basic problem is that upon trying to uninstall the default SQL 2005 express and install SQL 2008, it is no longer connectable through either Visual studio or the Management Studio. I think at this point (as I have been meaning to for sometime) a reinstall of Windows will be quicker than a repair. When I have Windows reinstalled, wha...
Using SQL Server 2000 I get a database from sql 2005, then i try to attach the database in sql 2000, it showing error as "could not find row in sysindexes for database id 8 object id 1 index id 1 run dbcc checktable on sysindexes" Is possible to attach the database, or any other way to attach? ...
Hi guys, I'm currently working on a project that simulates a map with routes on it that allows users to decide their destination, and the system will calculate the shortest path to it. The map should receives real-time traffic data in which the traffic flow changes along the way while the vehicle is travelling. When the traffic flow chan...
Table1 ID Date Time Functionkey 001 23-02-2009, 08:00:00 A 001 23-02-2009, 12:00:00 A 001 23-02-2009, 13:00:00 B 001 23-02-2009, 14:00:00 B 001 23-02-2009, 16:00:00 C 001 23-02-2009, 17:00:00 C 001 23-02-2009, 19:00:00 D 001 23-02-2009, 21:00:00 D 001 24-02-2009 10:00:00 A 001 24-02-2009 18:00:00 D 001 25-02-2009 09:00:00 A 001 25-02-2...
I need to use SQL SERVER to try for it and then generate a crystal report out. who can teach me how to make it as the pattern i show in? Daily Registration / Activation Report As Of 12/10/2009 Year : 2009 Month : ALL Registration Activation Port Out Month Imported Activated Imported Jan...
Using VB6, SQL Server 2000 I want to connect to others system database. Code: ConnectionString = "Provider=SQLOLEDB.1;" & _ "Persist Security Info=False; " & _ "User ID=" & SQL_Username & "; Password = " & SQL_Password & "; " & _ "Initial ...
UPDATE: the issue does not happen when run against SQL Server 2008. So this is something strange (or wrong) with SQL Server 2000. I try to do a simple insert on SQL Server 2000: INSERT INTO UserAddresses (UserId, AddressId) SELECT UserId, Id FROM Addresses and I get this: INSERT statement conflicted with COLUMN FOREIGN KEY ...
I need to remove semi duplicate records from the following table ID PID SCORE 1 1 50 2 33 20 3 1 90 4 5 55 5 7 11 6 22 34 For any duplicate PID's that exist I want to remove the lowest scoring record. In the example above ID 1 would be remove. I'm tr...