There is usually a small panel on the bottom which can be opened to access the RAM slot(s)

With the right size screw driver its as quick as swapping RAM on...

Beaten to it!

Thats what I get for testing the code 😛

Your missing another +7

declare @string varchar(1000)

SET @string = 'BladieblaDiebladi bladibla blabla, View = AnyViewName_without_a_space Export to ADirectory wher spaces can occur\Filename.csv'

SELECT charindex('view = ',@string) AS result1,

...

For your future reference:

You never know untill you try! 😉

I had a situation a couple of weeks ago where...

if this is true

And for some value of my attributs ,it can be true in more than 1 case.

Then this cannot be the case

when i change the order of the...

Out of curiosity I just checked it on a 30 million row table

Result 1 - without a derived table

CpuMsLogRdsElapsed

80159430078641

Result 2 - with a derived table

CpuMsLogRdsElapsed

7766946009777

Run a few tests on it 🙂

Use this code from RBarryYoung as a test wrapper:

Set NoCount On

Declare @cpu_ int

Declare @lreads_ int

Declare @eMsec_ int

Select @cpu_ = cpu_time

, @lreads_ = logical_reads

,...

nothing wrong with the syntax of your case statement

One thing to note though, a Case Statement will stop as soon as it hits a condition which is true, so...

won't work like that

you can use

select * from

(

SELECT (firstname + ' ' + LastName) AS FullName) as derivedtable

WHERE derivedtable.FullName like '%Dalton%'

This works by returning a data set with the...

i'm not sure about why its getting that collation.

You can specify the collation of a column though

select MyColumn collate [collation name] as MyColumnAlias

from MyTable

The same thing works in joins

from TableA...

you need to alias it

select *...

I've got a Dell Precision 15" 2 years ago with:

2.2Ghz dual core intel processor

2GB Ram

250Gig hard drive

NVIDIA Quadro FX 370M 256MB - good enough to allow some gaming entertainment when...

The first isn't a valid time string

use this instead:

SELECT dateadd(hh, 2, CAST('1976-12-14T00:00:00' as datetime))

You can use Skype - they provide an API for windows development

You'll need some way of interfacing from your stored procedure to the Skype API, probably by way of an...

There are details from microsoft here[/url]

In a nutshell - you just need to install the updates to service pack 2