Mention that 24x7 servers don't have a "window" in some cases, which means rollouts have to either be announced before-hand as non-regular downtime, or have to be done in such...

In the Job manager, right-click and select "Stop". Or did you already try that?

Have you taken a look at this article: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/62662/

It depends. Are you trying to loop through values to assign, or just assign a value once?

If it already has SQL Server on it, are you just installing a second instance? If so, no, you don't need to reinstall tools, documentation, etc.

I just did a simple speed test on a do-nothing cursor.

DECLARE c CURSOR STATIC FOR

SELECT NAME

FROM sys.columns;

DECLARE @DB sysname;

OPEN c;

FETCH NEXT FROM c

INTO @DB;

DECLARE @Start DATETIME;

SET @Start = GETDATE();

WHILE @@FETCH_STATUS...

Honestly, since you have to mark each row for success/failure, a cursor will probably be your best bet.

Ron Porter (11/18/2010)

---

Perhaps it's my blue-collar heritage, but I don't really have all that much concern for how management deals with security issues. I tell them what little I know,...

Why do you need to do this? It's possible there's another solution to the problem behind this.

That should work just fine.

Every non-clustered index includes the clustered index. That's how it knows what rows it's indexing.

Cool biz. Glad you sorted it out.

didier.boelens (11/18/2010)

---

GSquared, because I can't find a way of building a SQL statement that would satisfy the following requirement:

I there anything available between date1 and date2.

If I take the...

I don't think so, but I've never tried it. Set up a test on a dev box and see if it blows up.

CriticalStatus (11/18/2010)

---

anyone who says they are a 10 has reached the pinnacle in their career. they are done. time to move on to something else. no one...

Instead of one row for each day the house is reserved, why not a start and end date as columns in one table?