What is the datatype of the column containing the bad data?

If it is not a DATE, DATETIME, DATETYPE2, or SMALLDATETIME datatype, what it the format of the data?

If you really...

samalex (12/20/2012)

---

Technically FLOAT, REAL, MONEY and SMALLMONEY all have different ranges, but my standard is just to convert all numeric values of different types, especially values with currency, to Numeric(17,2),...

The order of the data could have changed without adding a file to tempdb, so that problem could have started happening anytime.

You should always have an ORDER BY unless you...

sql-lover (12/19/2012)

---

Increased the test file size to 150GB and performed another round of tests ...

64KB random IOs

sqlio v1.5.SG

using system counter for latency timings, 2474091 counts per second

parameter file used: data_param.txt

file...

sql-lover (12/18/2012)

---

I am not following you. The...

The 64K random read and random write tests may be OK, but I would not call them spectacular, especially the 64K random write.

You should probably test again, adding more threads,...

Probably not. It...

The location of the backup is recorded in column physical_device_name in table msdb.dbo.backupmediafamily.

If the backup is not going directly to a file system, physical_device_name may contain a path to a...

JP10 (12/7/2012)

---

THank you so much for leading me in the right direction Chris! I have modified your script to run against all db's and return the necessary information...the query...

You can pass as many parameters as you want in an XML parameter, including tables of data.

The real key is being able to parse the XML parameter using the built-in...

The most important thing for a naming convention is that it is always followed and enforced.

I have worked at several places with different naming conventions and they are all fairly...

Ulysses_Infinity (12/6/2012)

---

select cast(case datepart(dw,Loaddate)

when 1 then dateadd(ww,-0,Loaddate-6)

when 2 then dateadd(ww,-0,Loaddate)

when 3 then dateadd(ww,-0,Loaddate-1)

when 4 then dateadd(ww,-0,Loaddate-2)

when 5 then dateadd(ww,-0,Loaddate-3)

when 6 then dateadd(ww,-0,Loaddate-4)

when 7 then dateadd(ww,-0,Loaddate-5)

end...

The reason I use -53690, instead of 0 is simple: It produces correct results for the entire range of possible datetime values.

You can view the difference in the query...

An UPDATE updates all rows that match the selection criteria. UPDATE statements do not return rows, unless you have an OUTPUT clause.

If you really want some help, you need...

This will give it to you in a single result set using dynamic SQL:

declare @Cmd nvarchar(max)

select

@CMD =

isnull(@cmd+N'union all',N'')+

N'

select

[DB]= N'''+db.name+N''' ,

[Type Count]= count(*),

[Type_Desc]= [Type_Desc]

from

'+quotename(db.name)+N'.sys.objects a

group by

[Type_Desc]

'

from

sys.databases db

where

db.source_database_id is null

order by

db.name

set...