It will be in all files are that are part of the filegroup (or filegroups) it is in.

Edit:

Just to clarify, a table can be in multiple filegroups by having indexes...

You could also just convert the datetime to the first day of the month at time 00:00:00.000 and group by that:

group by dateadd(mm,datediff(mm,0,MyDate),0)

I would start by having development managers who have a high enough level of competence to be able evaluate the talent of the people they hire.

However the way the world...

The only time I have seen this problem was in trying to delete a maintenance plan that was created before a server was renamed.

You could just drop the primary key and add a new one. The disadvantage is that it will happen in a single transaction and the transaction log will get...

What is the physical size of the table? Do you have enough free space in the database to create another copy of this table?

This script will tell you the...

Access to SQL Server is via connection to the SQL Server service, not a network share.

When the machine that hosts the service is down or unreachable, then there is no...

Lynn Pettis (6/29/2010)

---

Actually, if you take the time to read all 16.072 (at this writing) posts of the this thread, Are the posted questions getting worse?, you will learn...

It's not all love and kisses around here; Check out the Bankers...

Agile (6/28/2010)

---

Thanks wayne for the suggestion, Im just wondering, Because when I use your solution, I did not declare variable for Date. Is there a difference in performance on doing...

I was saying that it is not logged because it is not a database object in tempdb, not because it is not stored in tempdb. The following code shows...

Better come up with a different plan.

I've never heard of such a tool, and I really, really, really doubt it exists.

Table variables are not actually database objects, even in tempdb.

# or ## tables are actual tempdb objects, so they are logged.

Any operation that changes a database is logged.

For moving databases from one server to another, the safe method is to use SQL backup and restore.

Doing the move using disk level copies is probably not a good idea,...