On a separate note, is this worth opening a connect ticket with ms for this issue?

My guess is that they'll just tell me to use a cursor...

I don't have a complete list of bad characters and I've got no idea about that type thing you're asking about.

All I know for sure at this point is that...

I can't explain this one...

Simple concat takes 500 times longer than select *, yet for xml is just as fast as select *.

No locking, no transactions ?!?!?

http://www.sqlservercentral.com/Forums/Topic1092281-146-1.aspx

rebuild does an update stats as well. reorg doesn't touch the stats.

If you can work the stats in your schedule, just do it. Autoupdate stats is good, but...

possibly definitly.

I love MS & all since I'm earning my living beause of them. BUT I work with ms Dynamics Nav and EVERY SINGLE FREAKING USER needs to be DBO.

Granted...

The db will use the space it needs to store the data you ask it to store. Nothing you can do about that.

Talking about good enough. Guessing is 1 thing, traking it is another. I know this script has been made before, but I just build this this week for...

Yes... never heard that expression b4 but it makes sens when you think about it.

Lowell (4/12/2011)

---

heck i'm throwing all sorts of numbers out there; i think i made my numbers extra huge to kick up some dirt so people would say "no! that's too...

SELECT 9 / 7

UNION ALL

SELECT 9 / 7.0

UNION ALL

SELECT ROUND(9 / 7, 2)

UNION ALL

SELECT ROUND(9 / 7.0, 2)

1.000000

1.285714

1.000000

1.290000

Look at my code again, there's an IMPLICIT CAST. I use 12.0...

That code eon't work on compatibiliy level 80 you need 90+.

Also the dbname is concatenated only once, but used twice in the code.

freddie-897605 (4/12/2011)

---

Better still, write function2 to call function 1 when only 2 parameters were passed. In that way, the existing code can continue to use function1 and the new code...

SELECT

last_name

, department_no

, ROUND(Annual_Salary / 12.0 , 2) AS 'Monthly Salary'

FROM

dbo.Employees

WHERE

Department_No = '90'

What the datatype of annual salary?

Try Annual_Salary / 12.0 (the .0 cast to decimal)