It might be a hardware issue. Check to see if you have a failed disk in a RAID array. Ask your hardware vendor to perform diagnostics on the disks...

Joseph Hicks (1/15/2008)

---

Michael Valentine Jones (1/15/2008)

---

Joseph Hicks (1/15/2008)

---

We had a group of...

Joseph Hicks (1/15/2008)

---

We had a group of developers (from before my employment)...

This works with 7.0, 2000, and 2005

if object_id('tempdb..#tables','U') is not null begin drop table #tables end

go

create table #tables ( TABLES_FULL sysname not null primary key clustered )

go

declare @sqlnvarchar(4000)

set @sql =

'use...

Any one have a way to read the following?

1. 800 BPI 9 track reel-to-reel tapes formatted to hold punch card images.

2. 8 inch floppy disks formatted for a Honeywell DPS-6...

denimblue (1/14/2008)

---

select cast(dte as datetime)

from stutable1

(select '1/2/90' as dte UNION ALL

select '11/1/91' as dte UNION ALL

select '1/02/05' as dte UNION ALL

select '1/02/95' as dte UNION ALL

select '10/11/94' as dte UNION...

Scott Clark (1/14/2008)

---

when an index is contained in a filegroup which spans multiple database files DBCC SHOWCONTIG isn't as accurate as it is on indexes which are contained within a...

Scott Clark (1/14/2008)

---

Michael,

In a multiple data file per filegroup structure how do you keep indexes healthy as you can't see how fragmented each data file is within the file group...

If the database was recovered, you have to do a restore.

denimblue (1/14/2008)

---

No,

I didn't try it, because the dates given were not real. I have many rows of different data in various formats. I would like them all...

I normally just create one filegroup called DATA and make it the default filegroup. Then I create one data file for that filegroup on each array, assuming that they...

I don’t see a good reason to do what you are planning.

The problem with having one filegroup for each array is they you do not know how much space each...

That is not a good way to do a date range query.

1....

When you tried the posted code, did it work correctly?

It is hard to give you an answer without knowing the reason you are planning to do this.

So what is the reason?