This is what I found:

http://www.microsoft.com/windowsserver2008/editions/specifications.mspx

Kind of confusing to me...

Edit: I think I understand now... Just because Win2K8 supports Hot Add also on X86 it does not mean ...

Hello,

could you please tell my why you would not use profiler to audit logins?

Is this putting too much burden on the server?

Thanks!

Are your DBs hosting distinct data?

Do you need to be able to update your data?

Then go for Distributed Partitioned Views

http://technet.microsoft.com/en-us/library/ms188299.aspx

Just as additional info to Matts post:

http://www.sqlservercentral.com/articles/Performance+Tuning/sp_performance/850/

I think this question is incorrect:

CLR Data Types are not "published". CLR data types are data types of the common language run time, not SQL Server. What the author probably...

Hi Andy!

Thanks for this nice quickie! What I really like about this one is its simplicity and shortness.

It doesn't always have to be the complete and in-depth analysis of...

The following query should also take care of values without digits:

SELECTstring Original

,CASEWHEN PATINDEX('%[0-9]%',string) > 0

THEN LEFT(string, PATINDEX('%[0-9]%',string)-1)

ELSE RTRIM(string) END-- Characters first

+ REPLICATE('0', 4-LEN(string))-- Stuff with zeros

+...

As Gail stated, CTEs are nothing more than "in-line views".

I also had a discussion about those not too long ago:-)

http://www.sqlservercentral.com/Forums/Topic411895-338-1.aspx

:)Or in a simple query:

SELECTstring Original

,CASEWHEN ISNUMERIC(string) = 0

THEN LEFT(string, PATINDEX('%[0-9]%',string)-1)

ELSE '' END-- Characters first

+ REPLICATE('0', 4-LEN(string))-- Stuff with zeros

+ SUBSTRING(string, PATINDEX('%[0-9]%',string), 4)-- Add numeric remainder

ASModified

FROM...

Hi Ramesh,

what makes you sure that the order of the rows is guaranteed in your example?

Hi Matt,

The query I "wrote" was just a copy of the query that Chirag posted.

I have compared the CURSOR method against the WHILE loop, and on my machine the first one completes in 10.990 seconds for 80000 rows, and the latter completes in 9.460....

From my experience (which is not too big), a linked table is the only viable option when you want to download by joining to 10.000 local rows.

SELECT D.x, D.y ...

FROM...

Hm,

And what happens with the following query?

I hope it contains no error.

SELECT D1.[SID_0COMPANY] AS [SID_0COMPANY]

FROM mdp.[/BIC/DZFIGL_C021] D1

WHERE EXISTS ( SELECT *

...

Hi Jeff, Chirag,

I am not sure if I misunderstood something, but the SQL Statement does NOT utilize a "triangular join":

Select orderid,orderdate,productid

from orders O INNER JOIN orderdetails OD

On O.orderid = OD.OrderId

WHERE...