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?

If would be easier to help you with your query if you posted the code for it.

The LIKE operator is meant for use with character data, not numbers. Also, float is a very poor choice to use as an identifier.

This would be the best way...

Try this code:

declare @handle1 binary(20)

declare @handle2 binary(20)

--select * from sysprocesses

declare @handle1 binary(20)

declare @handle2 binary(20)

selecttop 1

@handle1 = a.sql_handle,

@handle2 = b.sql_handle

from

master..sysprocesses a

join

master..sysprocesses b

on a.blocked = b.spid and a.spid <> b.spid

where

a.blocked <> 0

if...