brij (8/14/2009)

---

Thanks for reply but I guess u didn't understand my question

I can create partition based on Month or day of the year. But I want partition based on...

You can actually find this in BOL (Books Online, the SQL Server Help System). You can access it from SSMS by pressing the {f1} function key.

here is the relevant...

Actually, in SQL Server 2005 this may work faster:

select

t.[name] TableName,

t.create_date,

t.modify_date,

sum(p.[rows]) RowCnt

from

...

hi_abhay78 (8/14/2009)

---

Give me time till Monday (as its weekend) and your email address as I am on a location where there is no SQL Server (preparing documents to travel to...

Not too hard, here is the code I came up:

select

Account,

sum(case when Type = 'A' then Amount else 0 end) as TypeA,

...

hi_abhay78 (8/14/2009)

---

Here is what you can do and you can always mail me for assistance during this time (hi_abhay78@yahoo.co.in).

First create or modify a job and run profiler at the background...

No website required. You can get all of this from BOL (Books Online, the SQL Server Help System). You can access it from SSMS by pressing the {f1}...

Gift Peddie (8/14/2009)

---

I think you may have missed the where clause in my LEFT JOIN example. All three of these queries will return the same result set. ie Customer records...

There may be another solution as well. Could you please post the DDL for the tables involved (not just the ones in the procedure), sample data for the tables,...

First, you may nneed a cursor. To really help you, we need your help. Please provide the DDL for the tables, sample data for the tables, expected results...

There are numerous ways this can be accomplished. You may want to google Geographically dispersed clusters. There is software that will allow you do to this, but it...

htt (8/13/2009)

---

This is NOT always true. Couple of my...

Only speaking for myself here, but I think others may agree; for me to leave SSC the sense of Professional Community that currently exists would have to leave the site....

Let me think on that a bit. The first idea I had was to have you zip and upload the .dtsx package, but that may not work, even though...

htt (8/13/2009)

---

Okay, here is a scenario for you.

At 12:10 PM Wednesday afternoon your server crashes and corrrupts your database forcing a restore. You attempt to restore from the full backup...