Tagged Questions
0
votes
2answers
49 views
Home rolled gridview search results shows rows that are supposed to be ignored [closed]
Note: I tried posting this on Stack Overflow but didn't get any good bites. I'm still researching this but wanted to see if any db czars can assist here.
I'm in the process of trying to troubleshoot ...
-4
votes
1answer
60 views
Update date Column values? any please help? [closed]
I Want to copy and data in same Table and Update date Column values? any please help?
1
vote
2answers
104 views
Microsoft SQL Server how can i detach localdb to run on any computer
I am working on a personal project and have implemented a database system using the Entity Framework code first tutorial on msdn, link below,
http://msdn.microsoft.com/en-gb/data/jj193542
I am ...
1
vote
1answer
101 views
Database Tasks in C#
We have 2 database environments a "Production" Database and a "Reporting" Database located on different physical windows server 2003 boxes. The reporting Db is derived off the Production database and ...
3
votes
1answer
208 views
“Thread was being aborted” error when inserting 25k rows
I need to store about 25k rows worth of data into a single table about once a week. To achieve this, I'm creating an object (created from parsing XML), and sending the data within that object to a ...
13
votes
2answers
336 views
Setting up a central CLR stored procedure / function respository library for internal stored procs in other databases to use?
I would like to use code that I developed in C# CLR to be used in all of the databases on the system so that I don't have to set each to trustworthy and turn CLR on and keep a bunch of the same code ...
4
votes
2answers
109 views
why SELECT is still using CPU & DiskIO?
I have a large database, about 30GB. In order to delete some data from a table (most data is in this table, simply because the # of rows), I have to do delete in batch. However, if I delete in too ...
3
votes
1answer
918 views
sql server , set N prefix as unicode for all queries by default
Is there any option in ms sql server which use N prefix for my database.
There are many query in my application which non of them use N prefix for nvarchar fields , and now I have to set N for all of ...
2
votes
0answers
164 views
going from heirarchical XML to heirarchical SQL tables then SQL to c# objects to go to user view, how should I store the data in the databases?
Hi I'm getting my data from a web service using their getData call and it comes in as fairly chunky heirarchical XML, first everything all at once, like
<allData>
<product1>
...
2
votes
1answer
188 views
How would you implement conversation groups/ locking for multiple users of a Service Broker Queue?
How do you implement conversation groups for multiple users using their own instance of the user applications but sending related messages to the service broker queue? Any good example of this kind ...
4
votes
2answers
3k views
Converting RTF in a text column to plain text in bulk
I have a legacy system with about 10 million rows in a table. In that table there is a column of type text, most of them are standard text but about 500 thousand rows have RTF markup in them. I need ...
2
votes
2answers
607 views
Looking for example design of using an SQL database as a queue for throttling web service requests of multiple users
I'm designing a system for multiple users to queue their requests to a web service which takes requests such as creating new entries, changing entries, requesting data. Many of the web service calls ...
2
votes
2answers
1k views
What server property makes TransactionScope escalating to MSDTC?
In our application we're using TransactionScope's. We're aiming to not use the MSDTC service because it's a lot slower than lightweight transactions.
using (var transactionScope = new ...
1
vote
1answer
459 views
Merge Replication from SQL 2008 R2 to SQL 2005 Express: SQL Server version (10.50) is not supported
I'm setting up a (one way) pull, RMO merge replication via web sync from my main database (SQL Server 2008 R2) and clients running SQL Server 2005 Express or 2008 Express (I must support both). I've ...
5
votes
3answers
1k views
3rd party dll in SQL Server CLR
I need to use a third party DLL in a trigger c# code in SQL Server CLR
But when I try to add reference it just shows some DLLs from SQL Server.
How can I add my third party dll to SQL Server?
