tamie.mcdonald (6/23/2009)

---

This past year we converted multiple instances of Sybase servers having eleven integrated databases on each to MS SQL, and we used the Migration Assistant as one of tools...

After reading Lutz's post, you can also change the code I provided to use the RANK() or DENSE_RANK() functions. Be sure to read about those in BOL as well.

You may want to look up the ROW_NUMBER() function and CTE's in Books Online (BOL, the SQL Server Help System). Read these and if you have questions, ask. ...

bryan van ritter (6/23/2009)

---

Hi guys,

what is wrong with us seriuous dba's. the guy just asked some questions about a possible interview he is going to undertake and you all are...

Wrong I may be but class work this seems to me.

Before we show you how we would accomplish these tasks, please provide us with what you have tried so far...

Use ceiling: select ceiling(170.1) -- will return 171

Looks like this will do your conversion: select dateadd(dd, 39987, -2).

Replace the 39987 with the fdate field in your table.

One of the beauties of working with a GUI tool like SSMS. It does things behind the scenes to make our jobs easier. It monitors the status of...

What else is shown in Activity Monitor? What application is shown for that particular process id?

What you are seeing could simply be normal, behind the scenes activity of tools...

GilaMonster (6/23/2009)

---

Lynn Pettis (6/23/2009)

---

I've had it suggest that I include over half of the columns from the table and that just doesn't make sense to me as that would make...

Too many parens in your SQL version. Try this:

alter function dbo.upper95(@P float, @N float)

returns float

as

begin

return @P+1/@N+2*SQRT((@P*(1-@P)/@N)+1/(2* POWER(@N,2)))/(1+2/@N)

end

go

Always room for more. Welcome aboard!

I would also recommend reading the first two articles I reference in my signature block below. You may also find yourself recommending these...

A block of salt would be better. Use it as a guide to determine what indexes may be needed. Review them carefully, you may find several that can...

Is the user an owner of any schema's in the database?

Here is another solution that I think is a bit simplier, but since I seem to be having a problem (again) posting the code directly in the thread, it is...