You can utilize the sys.dm_os_sys_info DMV to get this information:

select cpu_count

from sys.dm_os_sys_info;

PowerShell:

Get-WmiObject -Class Win32_Processor | Select-Object NumberOfCores

BOL Reference on how to Configure a Server to Listen on a Specific TCP Port.

You're welcome. 🙂

I'm guessing this is what you want:

;with PodCte

as

(

select

case

when month(DueDate) = 5

then DueDate

end as DL

from Purchasing.PurchaseOrderDetail

)

select *

from PodCte

where DL is not null;

In your immediate query DueDate isn't necessarily NULL, but since...

Ok, can you post your whole query with your attempt?

...

where YourCol is not null

YourCol would be the column that if it is null you want to omit those rows from the result set.

Tony Parfitt-465405 (6/3/2012)

---

This is not for everyone, but I found that switching to using my left hand on the mouse at home, and my right hand at work relieved a...

toddasd (6/4/2012)

---

Steve Jones - SSC Editor (6/4/2012)

---

Take lots of breaks.

Seriously, that's important. Get up, even for 5 minutes.

Do some stretches. Google for the various ones for your wrist. Adding some...

GilaMonster (6/5/2012)

---

Yes, for exactly the reason I wrote.

Async Network IO waits are actually not network waits most of the time. They're waits for the client app to acknowledge the resultset,...

Yes, there's a ton of SQL Server notes out there. You can find experts' knowledge through the many, many books out there on the subject. I have listed...

Ok, I think triggers have narrowed my definition of DML, but you are right.

GilaMonster (6/3/2012)

---

If the log is actively growing, data modifications have to...

Wouldn't performance would be degraded if the...

In my opinion, there are two benefits in helping others with issues that we are familiar with (i.e. SQL Server, data). The first and most obvious is that there...

banda.sai (6/3/2012)

---

Performing backup of complete database monthly 2 or 3 times.

Also hosting team will take regular backups of database. But i don't know which recovery model they are using.

Currently performance...