The real advange the the function here is that when (not if but when) the powers that be decide that you need to insert a 3rd value, then all you...

Here's a version that wouldn't affect performance (or extremly slightly)

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION dbo.FnYesNo

(

@Value TINYINT

)

RETURNS VARCHAR(3)

WITH SCHEMABINDING

AS

BEGIN

RETURN CASE WHEN @Value <> 0 THEN 'YES' ELSE 'NO' END

END

GO

SELECT dbo.FnYesNo...

Lynn Pettis (8/12/2010)

---

CELKO (8/12/2010)

---

tymberwyld (11/10/2008)

---

Along with a lot of other horrible decisions, I am now not allowed to use Negative numbers in any database design. Instead, I need to...

Good point, but with 25 columns (especially if you repeat that query often), I'd consider using a schemabound scalar udf.

I wouldn't expect that logic to change much, but you never...

That does the trick!

http://stackoverflow.com/questions/972616/string-aggregation-in-ssrs-2005

If you don't have insurrance, then yes. I don't know if you can get a discount tho... I never explored that option.

Ya I gave it a whirl on my prod server : 15 minutes for 32K rows... and it's not like we have a slow a busy server here!!!

From the user interface you cannot set a max size, the only option is to disable auto grow which achieves the same thing.

Filegrowth = 0 means no auto grow.

Yes if you specify the location that assumes you want to move the files so you need to restart.

Here's what I get when I script my modifications from the UI in SSMS

ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'templog', SIZE = 2097152KB , FILEGROWTH = 0)

BTW 100MB...

I'm not sure I understand what you are saying. Calculating required space is a very fast operation, what takes time is growing the file. So in that sense,...

Do you get...

The patented "is it plugged in question" :

Are you sure that the datasets are 100% identical on both servers BEFORE applying the order by?

With a linked server you could...

Cool, did that affect performance noticably?

WOW 2315 post from a single SPAM post from a new user... that must be some sort of record. :hehe: