Hi, It is a question for SQL Server 2008 and .NET code. I am wondering what you think in terms of performances, design between these two options to insert a lot of data (>250,000 rows, 5 “normal” columns) into a table using a transaction. a. Insert Into statement surrounded by transact statement in the c# code. Or b. Insert Into ...
Hello, This is a continuation of this question. I worked all weekend on this problem without solving it. I'm totally stumped. Essentially, I inherited an interesting table structure. This table structure looks like the following: GroupTable * ID * Name * Description GroupItem * ID * GroupID * Name * CreatedBy * CreationDate OpenG...
Hi guys I have a table with many URLS like www.topshop.com www.shopbop.co.uk http://www.magickingdom.net http://www.asos.co.uk UPDATE Needs to be able to handle this URL as well topshop.co.uk I want to be able to strip out the fluff such that it returns only topshop shopbop magickingdom asos Do I have to write a manual excepti...
Hi, I have been reading for the last two days about indexes and how to optimize a database. Despite I have a clear idea on Indexes i don't know yet how to practically optimize my database. Could you suggest any tutorial or technique to optimize a database. Please be specific as i have been reading lots of theory but no specific instr...
I'm pretty experienced in C#, but still mostly a beginner in SQL. We have an application in C#, using an MSSQL database. One part of our application is simply a list of pre-written queries as reports that the application shows by simply running the query and sticking the returned table into a gridView. The user is requesting a new report...
I am in a situation where I need to run multiple times the same queries. I have to look if one of the rows returned correspond to a specific value (query 1) otherwise, I have to return the first row of the result set (query 2). In SQL Server 2008, I am wondering what is best: running the query and storing the results in a table variable ...
Hi. We have one vps server, at the moment, and we need to run both test and prod web applications on it. Is it good idea to have one sql instance for production databases and another one for test databases? Thank you. ...
I'm working on a school project desktop application in c# using Visual Studio 2010 (.NET 4.0) and the application uses a SQL Server 2008 database that's running on a SQL Server instance on the development machine I'm working with. My question is how do I package up the database with the c# project so that the application works no matter...
I have done SQL synchronization. I am to execute the Query like Insert,Update,Delete and it is affecting /reflecting in another PC, but if I create a table it is not replicated in another PC. How do I create a Table that is reflected in another PC which I synchronized. SQLProduct:MsSql Server 2008 Please help ...
I use visual studio 2008 with sql server 2008 and all my applications and databases are installed on my desktop. No server priviledges as yet. I noticed for the first time and probably since my apps are a little different now; but when running 6 apps at one that all access the same database but different tables with some accessing the sa...
IS there any way to change what values in the properties page are expanded by default? I'm examining a DB schema designed by someone else and since the FK names aren't always convenient for IDing what table they're from every time I select a relationship in the diagram I have to expand the Tables And Columns Specified group in the prope...
(I've read a lot about 64-bit versus 32-bit OS/Apps, but this question is specifically in regards to databases.) I'm trying to understand the pros and cons of 32-bit versus 64-bit databases, and namely, under what conditions that it starts to make sense to use 64-bit installations. The database systems that I am interested in are: SQL ...
Hi Guys, Need help with the pivot clause in sql server 2008. I have a table with this info: Weekno DayOfWeek FromTime ToTime 1 2 10:00 14:00 1 3 10:00 14:00 2 3 08:00 13:00 2 4 09:00 13:00 2 5 14:00 ...
I also have a very large table in SQL Server (2008 R2 Developer Edition) that is having some performance problems. I was wondering if another DBMS would be better for handling large tables. I'm mainly only considering the following systems: SQL Server 2008, MySQL, and PostgreSQL 9.0. Or, as the referenced question above eludes to, is ...
Greetings, How to create duplicate table (structure only) with new name in the same database in SQL Server 2008? I have table with 45 fields so I want to create new with same structure but new name. I do not want to copy the data!! Thank you, ...
Hi, I have a SQL Server 2008 in production environment (Windows 2003 -64 bit) and it is consuming 10 GB memory of installed 20GB. Is this normal behavior or is there anything wrong with the configuration ? P.S. I have hosted one web application which is used by hundreds of users concurrently everyday . ...
When using FOR XML PATH and WITH XMLNAMESPACES to declare a default namespace, I will get the namespace decleration duplicated in any top level nodes for nested queries that use FOR XML, I've stumbled across a few solutions on-line, but I'm not totally convinced... Here's an Complete Example /* drop table t1 drop table t2 */ create ta...
i need to connect SQL Server 2008 instance with SQL Server 2005 Management Studio. There is a limitation on my Box that i can not upgrade the framework to 3.5. There are few applications running on my box which will stop functioning after 3.5 upgrade. Is there any way to achieve this? I GOOGLE this problem and found a Cumulative update p...
Hello everyone, I am using SQL Server 2008 Enterprise + VSTS 2008 + C# + .Net 3.5 + ASP.Net + IIS 7.0 to develop a simple web application. In my database table, I have a XML type column. The content is like below, I want to get AdditionalInfoList of all rows in the table if Title contains "software engineer" or Info contains "Software ...
We have ASP.NET MVC2 project with EntityFramework mappings. How to delete row from Structure table with cascade deleting rows from Customer table (Customer table has "Zero or One - Many" association with itself and cascade deleteing of children Customers)? ...