Still not sure if I got you...

Do you mean something like this:

DECLARE @t TABLE (Id INT IDENTITY PRIMARY KEY, SomeInt INT, SomeDate DATE);

INSERT INTO @t

...

Hi

If your process starts with a 1:1 copy of the data into the database, you should use BCP or something else to realize a bulk operation. This works way faster.

Are...

Here you can find Adam's blog post:

Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

Greets

Flo

Hi

Please provide a more information. What do you mean with "lists all columns that contains NULL"?

Please provide some sample data and a desired result for those data. You can find...

Hi

Depending on the way how you generate...

Oups... sorry Ed, didn't see your answer. (I've been out for lunch while answering Bob's post.)

Totally confirm your post with my current experiences. Nevertheless, I'll do...

Hi Bob

Yep, looks like. But I...

Sorry, forgot to say that: I know Adam's post 😉 but I'd like to hear some production experiences.

Generally..

Start profiler, remove Audit Login/Log-off and Existing Connections, remove SQL:Batch Started and Completed and keep "RPC:Completed". Use Column Filter to specify a CPU-time or a duration which means "slow" in...

Hi

That's too less information. Do you have some special procedures to be traced? Do you have some general performance issues? Which kind of performance issues do you have?

Greets

Flo

Hi John

Did you try this:

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

Greets

Flo

Hi Trudye

Don't forget the gals ;-). This would exclude some of the greatest people here

To your problem:

If your data are already stored as VARCHAR(8) (why?) you don't have to...

Simple answer: 8

Filestream is not restricted to 2GB and you can join your disks together to support the "The Thread" post-sequence. You just need a new stripe set for each...

Alvin Ramard (11/7/2009)

---

Florian Reischl (11/7/2009)

---

Hi Joe

PS: You can keep registered to "The Thread" but when you don't want to get email till the end of days you should unsubscribe this...

Hi Joe

Your blog showed me some thins I really have to try in my PostgreSQL investigations! Apparently there are some things where SQL Server seems to be better, on the...