Programming SQL

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
Thomas Gagne (TandGandGAGNE(a)gmail.com) writes: I have an application that will happily post 20TPS from 9 different processes running on three different computers. In the middle of all this happiness, I'll get about three seconds of: A transport-level error has occurred when sending the request to... 17 Nov 2009 16:21

SharePoint SQL optimization "insert bulk"
Recently, i have been looking for ways to optimize Sharepoint's performance on my SQL Server. I noticed that a particular statement was creating a lot of waits and it was: insert bulk dbo.MSSSessionExistingDocs("DocId" int) I caught that in the Profiler via "SQL:StmtCompleted/Started". Can someone tell me... 17 Nov 2009 16:21

A transport-level error has occurred when sending the request tothe server. (provider: TCP Provider, error: 0 - An existing connection wasforcibly closed by the remote host.)
I have an application that will happily post 20TPS from 9 different processes running on three different computers. In the middle of all this happiness, I'll get about three seconds of: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An e... 17 Nov 2009 09:29

how to convert safearrary COM call
I have to call the following COM interface. Can i just pass a c# arrary of longs and doubles? What about the out parameters? They need to be preallocated. [id(11), helpstring("Calculate travel time and distance between locations assuming given start or end time ")] HRESULT Calculate... 17 Nov 2009 08:23

Usage (scope) of ALTER TABLE in sproc
hi @ll, I have a question about the usage of ALTER TABLE in a stored procedure (SQL Server 2005): First concurrent query, started first, should be later encapsulated in a stored procedure: BEGIN TRANSACTION [Test] ; ALTER TABLE [myTable] NOCHECK CONSTRAINT ALL ; -- Function from BOL, WAITFOR ... 16 Nov 2009 10:10

SQL 2008 intellisense errors Invalid Object
3 days ago I switched out my old SQL 2005 (SQL_Latin1_General_CP1_CI_AS) server for a new one with SQL 2008(SQL_Latin1_General_CP1_CI_AS). I created the Linked Server to my second server that runs SQL 2005 (Latin1_General_BIN) with the default Linked Server settings. When trying to compile stored procedures f... 16 Nov 2009 09:03

SQL Subquery/Temp Value
I'm creating a tempval, from this value I use it in the next select query but I receive an error: Conversion failed when converting the varchar value 'Select ColumnID1 from dbo.tbl_main where id = ' to data type int. However if I hard code the Set @tempval = 'Select ColumnID1 from dbo.tbl_main where id = ... 14 Nov 2009 17:47

generate summary row question
Having this data set, is there any way to generate single summary row, with no UNION ALL, i.e. double query? I tried grouping sets but can't figure it out. Thank you for your help! SELECT keyID, val1, val2, val3, dt FROM ( VALUES (1, 10, .5 , 100, 1000) ,(2, 10, 1.5 , 10, 1000) ... 13 Nov 2009 21:06

CREATE AGGREGATE failed because type 'Concatenate' does not conform to UDAGG specification due to method 'Accumulate'.
You don't need a CLR for this http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254 //Peso "Minu Nair Khurana" wrote in message news:2009111355850khurana.minu(a)gmail.com... 1. Open the project in Visual Studio 2. Click on the project properties 3. Go to the Database tab and click on the browse but... 13 Nov 2009 17:47

Quicked way to create a copy of a table with all default value
Here is a DDL that I'm using for trying to figure out the issue CREATE TABLE [dbo].[Currency]( [ID] [int] IDENTITY(1,1) NOT NULL, [Currency] [varchar](3) NOT NULL, CONSTRAINT [PK_Currency] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, AL... 13 Nov 2009 14:26