Just a wild guess but...

If are you returning 1k bytes per row for 40G rows...

it can be a network bottleneck check how much time your bandwidth needs to handle...

I worked in all ranges from "you are fired on spot for letting you display on" to "no badges at all".

It depends a lot on corporation size.

There'a a time where...

Cloud is still hype and I recommend everybody to take a look in things like node.js

Off course it demands depends first on the business model and its more appealing for...

I just realized I forgot to include my Split function.

Its just a function to split a string, just like in javascript or another language.

So I managed to put it to...

Its difficult to find info about FTS in SSC.

I was just about to create a net topic but i think this old ill do.

I just make a example:

-- 0. create...

You are right GSquare the OP dont asked for it but he ill need it if he want to create a auto-install app.

He can also choose to reinstall it if...

Gary,

.Net is expected to work integrated with SQL Server.

You can try this link:

http://msdn.microsoft.com/en-us/library/a6t1z9x2.aspx

I just tested the example code and it worked, listing all servers/instances in my network.

Note a instance name...

I think Celko view point is from ANSI specs and Relational Model Theory and with that in mind he's right.

It's a major failure to overload the most essential language keywords.

The...

Sorry, forgot the wrapping NOT.

Se the below snipet.

-- Boolean equivalence rules:

-- not(A and B) <=> (not A) or (not B)

-- A and B <=> not((not A) or (not B))

-- not(A...

Gail,

I had found:

WHERE (key1 = @key1 AND @key1 IS NOT NULL)

OR (key2 = @key2 AND @key2 IS NOT NULL)

OR (key3 = @key3 AND @key3 IS NOT NULL)

makes better execution plans...

Maybe the performance problem is not at the DBMS but at the application.

You are creating and setting a lot of objects just to use it as TVPs.

.net is a great...

Something changed in my mind concerned about the parser/compiler.

I runned some tests like below:

use tempdb

GO

SET ARITHABORT Off

SET ANSI_WARNINGS Off

GO

declare @b-2 int

set @b-2 = 2147483647

select @b-2*@b

GO

/* setting off ansi warnings ill...

Thanks Paul!

Your insight cleared a lot about this behaviour.

But instead of a error the parser can verifify the DB default values and issue a firendly warning message like.

"Ok, now if...

Sometimes the parser can go weird.

Is there any way to make the snipet below work?

create table test4(

a int null

,b int not null

,c as isnull(a,b*b) primary key

)

GO

Updt: Never mind, I...

Its depends largely of the app.

If a user is searching a phone number with a like and he inputs "99".

"showing the first 1.000 of 10.000.000 numbers" can be a option...