Carl Federl (6/23/2009)

---

Sorry about the delay,but the NTFS decided to misbehave on my business laptop and spent yesterday getting windows re-installed.

First, the term "Triangle Join" is a wonderfull term that...

It would help if you let is know what you have tried so far to solve the task at hand and where you are having problems.

We are all volunteers on...

You can't disable Windows Authentication. The best you can do is not grant access to your servers to windows user or group accounts. If you don't authorize them...

Roy Ernest (6/23/2009)

---

Hey Barry, That movie star , what is his name Redford?? He looks just like you...:-) He must have been one pleased man to look like you... Just...

You really must be kidding, right? This is your code, why should we do your work for you?...

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...