You are welcome 🙂

COALESCE is the ANSI standard version of ISNULL....

Andy Warren (8/13/2008)

---

Jeffrey, the schema idea is interesting, it's just felt like it was worth doing to me, all too often users need to cross schemas to get work done....

One of the things I haven't seen mentioned here is how to use schema's in addition to roles for granting privileges.

I know that in most systems being converted from 2000...

You can use a full outer join.

Declare @TableA Table (Material char(7), Plant int);

Declare @TableB Table (Material char(7), Plant int);

Insert Into @TableA Values('8843NEW', 1001); ...

No, you do not need to put the databases into single user mode to rebuild indexes. If you can rebuild the indexes online, this leaves the table accessible while...

By any chance, are you trying to upgrade a clustered instance of SQL Server? You will see the white icon next to a clustered instance instead of the normal...

California (8/12/2008)

---

Thanks for the contribution.

So what happens when i execute the following code:

ALTER INDEX ALL ON Product REBUILD??? I dont see online rebuild option is specified here with the command....

You can take a look at RedGates SQL Dependency Tracker tool.

antonio.varricchio (8/11/2008)

---

Hi,

We have SQL 2005 64Bit Std edition installed in a cluster in pre-production environment. The disks (2, drive M and N) are on a SAN. When...

Is there a process that changes the recovery model, say from full recovery to simple and back again?

California (8/11/2008)

---

I have 4 indexes (1 clustered and 2 non-clustered) on a table which is 105 GB. I want to run the following code to rebuild all the indexes on...

GSquared (8/11/2008)

---

I just ran my unmodified code on my machine, and got Jan 31, Feb 29 and Mar 31.

The difference is probably where your Numbers table starts. Mine starts...

Did that solve the problem?

GSquared (8/11/2008)

---

declare @SDate datetime, @EDate datetime

select @SDate = '1/8/2008', @EDate = '3/8/2008'

select

dateadd(month, number, -- Months in range

dateadd(day, -1 * datepart(day, @SDate), -- Last Day of (prior) month

dateadd(month, 1, --...

Using a numbers table, you can do the following:

Declare @fromDate datetime

,@toDate datetime;

Set @fromDate = '20080115'; -- From date some date in...