meichner (12/4/2008)

---

I am a C# program (.net 2.0) using Sql Server 2005. I would love nothing more then to do all of my transaction processing in T-SQL. ...

I'm not aware of any differences in behavior on READ COMMITTED SNAPSHOT. They did introduce the SNAPSHOT isolation level though. It's much more stringent and requires actual code changes to...

I might be off on this, but did you try this;

INSERT INTO xTable ( xCol )

VALUES ( @xmlEvents)

I wish I knew.

You can look at the date that the statistics were last updated. If it seems to long ago (very scientific) then you can update it. You've got...

You can't put them both within the same IF clause? It's pretty simple really, if one can evaluate and the other can't, you're going to arrive at a logical error....

Hey Barry,

Yeah, the GDR got released last Tuesday. FINALLY. And yeah, DBPro & Visual Studio Team System Database Edition are the same things.

That's a good idea. I'm in the middle...

ritesh.saluja (12/4/2008)

---

I want to import large data in one table from csv file.

When the performance of import would be better.

1. When I remove the index in the table and then...

Check the connection settings between the two, especially the ANSI settings. I wouldn't be surprised if they're different.

I'm not sure, but the first question I'd have is, what does the execution plan of the scalar function look like, all by it's lonesome?

You can also use OUTPUT parameters.

CREATE PROCEDURE proc1

(@param1 INT

,@param2 INT OUTPUT)

AS

SET @param2 = @param1 ;

GO

CREATE PROCEDURE proc2

AS...

In addition to Profiler, if you want to get real time information on queries that are currently in cache, you can get aggregate performance information from sys.dm_exec_query_stats. You can get...

Personally, I create all the databases out of TSQL code and check the code into a source control management system (Visual SourceSafe VSS, Team Foundation Server TFS, there are others)....

I'd change that definition just slightly. It means that the string passed will be unicode. This would be for use with NVARCHAR, NCHAR and the other fields and/or parameters in...

Generally, rather than create statistics, I just create an index. It's a fairly rare circumstance that requires you to manually build and maintain statistics rather than simply have an index....

Wow! That one is busy. Thanks for posting it.

Interestingly enough, it's not returning query text for the blocking process either.

Now that I think about it, maybe it's my test. I'm...