mister.magoo (7/19/2011)

---

The recursive part of the CTE returns no extra data, but coerces sql into storing the results (it will plop the results in tempdb once there are enough I...

Neat!

CTEs generally don't help - the expression is evaluated...

You can avoid performing the complex calculation more than once:

DECLARE

@A INTEGER = NULL,

@b-2 INTEGER = -351,

@C INTEGER = 45,

@d INTEGER = 999;

SELECT

Calculation.result * ((SIGN(Calculation.result) + 1) / 2)

FROM

(

SELECT...

invulnarable27 (7/18/2011)

---

I would like a further explanation of why I should keep the tempdb on the RAID10 array along with the data file. Why not the RAID1 array with...

Right, I'm with you now - yes 'composable DML' is limited to being a source...

The OUTPUT rows are produced by...

This one.

The conversion is the easy part. Don't forget to think about how your...

This is another way of writing a query to suit the requirement:

CREATE TABLE #Cities

(

city_name VARCHAR (25) NULL

);

CREATE INDEX nc1 ON #Cities (city_name);

INSERT #Cities

(city_name)

VALUES

('Chennai'),

('Hyderabad'),

('Bangalore'),

('Bombay'),

('Kolkata'),

('Cochin'),

('Ahemadabad'),

('Bangalore'),

(NULL),

('Delhi');

SELECT

ranked.city_name

FROM

(

SELECT

city_rank = CONVERT(BIGINT, -1),

c.city_name

FROM #Cities AS c

WHERE

c.city_name IS...

sqlfriends (7/16/2011)

---

My question is : is it an common case that when join multiple tables we get duplicated recors, and it is Ok then use update to perform on those...

There are hundreds of scripts out there for things like this. I used Google to find this:

http://sqlserverteam.blogspot.com/2008/11/monitor-database-growth.html

There are probably better ones. Have a look around.

I normally write such stubs the other way around, to avoid all that tedious messing about with quotes in the view definition:

IFOBJECT_ID(N'dbo.MyView', N'V')

IS NULL

EXECUTE ('CREATE VIEW dbo.MyView AS SELECT 1...

Yes, you can filter an OUTPUT clause, and achieve what you want to do in one statement:

DECLARE @Production TABLE (col1 INT NULL, col2 INT NULL, col3 INT NULL);

DECLARE @Archive TABLE...

First again!

Good question - I guessed correctly, but still leaned a new fact for the day. Cool.