Viewing 15 posts - 10,456 through 10,470 (of 15,381 total)
From what you have posted nobody can offer much help. The description is pretty vague and there is nothing to work with. Please see the first link in my signature...
October 8, 2012 at 2:12 pm
Don't shrink tempdb. You are asking for problems doing that. You can end up causing yourself all sorts of problems.
Here is one link that refers to the issues.
http://support.microsoft.com/kb/307487
http://sirsql.net/blog/2011/5/18/dont-shrink-tempdb.html
Search around for...
October 8, 2012 at 12:28 pm
Now for the mechanism you suggested to work robustly it would depend on the sql server client being able to verify back to the server that it has received the...
October 8, 2012 at 11:58 am
blakmk (10/8/2012)
what i mean is the mechanism that you are talking is handled by a background sql process. In sql many of these processes run asynchronously and not continuously
You have...
October 8, 2012 at 10:39 am
blakmk (10/8/2012)
October 8, 2012 at 10:25 am
I wouldn't go as far as holding a transaction open pending feedback from a client over a broken connection.
+1
Especially since this an ASP.NET application using transactions like this is incredibly...
October 8, 2012 at 9:52 am
Or for an even better approach don't use pass through sql from your .NET app. Instead use parameters. From the issues you are facing it is very likely that your...
October 8, 2012 at 9:22 am
blakmk (10/8/2012)
October 8, 2012 at 9:10 am
The code looks ok. It is impossible for us to know if it is correct though. You need to figure out what the error is. This can be somewhat painful...
October 8, 2012 at 7:45 am
bitbucket-25253 (10/5/2012)
Sean Lange (10/5/2012)
ben.brugman (10/5/2012)
bitbucket-25253 (10/5/2012)
October 5, 2012 at 1:01 pm
David_D (10/5/2012)
Beginning T-SQL with Microsoft SQL Server 2005 and 2008 (Wrox Programmer to Programmer) [Paperback]
Paul Turley (Author) & Dan Wood (Author)
[font="Arial Black"]Which SQL Developer Edition...
October 5, 2012 at 12:26 pm
You're welcome. Glad that worked and thanks for letting me know.
October 5, 2012 at 10:23 am
54.69.6d.20 (10/5/2012)
Sean Lange (10/5/2012)
54.69.6d.20 (10/5/2012)
October 5, 2012 at 10:23 am
This should work based on your example.
create table #SomeTable
(
[ACCOUNTKEY] [int] NOT NULL,
[ACCOUNTSERVICEKEY] [int] NOT NULL,
[SERVICEOPTIONSKEY] [int] NOT NULL
)
insert #SomeTable
select 1000, 1050, 1016 union all
select 1000, 1051, 1020 union all
select 1000,...
October 5, 2012 at 10:10 am
54.69.6d.20 (10/5/2012)
October 5, 2012 at 10:00 am
Viewing 15 posts - 10,456 through 10,470 (of 15,381 total)