Sean Lange (1/22/2013)

---

ScottPletcher (1/22/2013)

---

Sean Lange (1/22/2013)

---

GilaMonster (1/22/2013)

---

Sean Lange (1/22/2013)

---

ScottPletcher (1/22/2013)

---

DiverKas (1/22/2013)

---

1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

2) Do NOT let your DBA's design the database.

3) Hire a...

Sean Lange (1/22/2013)

---

GilaMonster (1/22/2013)

---

Sean Lange (1/22/2013)

---

ScottPletcher (1/22/2013)

---

DiverKas (1/22/2013)

---

1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

2) Do NOT let your DBA's design the database.

3) Hire a Data Architect.

Just saying....

DiverKas (1/22/2013)

---

1) Do NOT let your C#/VB/ASP/Pascal guys design the database.

2) Do NOT let your DBA's design the database.

3) Hire a Data Architect.

Just saying. The first 2 groups have...

You need to do something like that in the WHERE clause:

select

col1

,CAST(col2 AS datetime) as col2test

from #DateTest

where isdate(col2) = 1

drew.allen (1/21/2013)

---

ScottPletcher (1/21/2013)

---

Huh? I don't see anywhere a "datetime" data type is specified, only varchar. I don't see why the code couldn't run fine as is.

I guess...

What you really need is someone that has experience doing it, period. This is not something that you can just "wing it".

If you have to do it with no...

Huh? I don't see anywhere a "datetime" data type is specified, only varchar. I don't see why the code couldn't run fine as is.

I guess your actual...

No, you should not have to; the db engine takes care of that itself.

From Books Online:

"

If the value inserted is larger than the current identity value for the table, SQL...

INSERT INTO dbo.T1 ( ... )

SELECT t2.col1, t2.col2, ...

FROM dbo.T2 t2

LEFT OUTER JOIN dbo.T1 t1 ON

t1.Name = t2.Name

WHERE

t1.Name IS NULL --only include...

The first is a datetime2 format, the second is a datetime format.

Try CASTing to datetime2 first, then CASTing that to datetime.

CAST(CAST(column_name AS datetime2) AS datetime)

SELECT *

FROM <db_name>.sys.database_files

WHERE

type_desc <> 'LOG'

DBA24 (1/17/2013)

---

Hello All,

I have a primary key on a column that is a unique identifier (width 32 char) and it is nonclustered. There are a lot of inserts, updates and...

For that, I would use a function with PATINDEX to retain only the desired chars.

If performance is not an issue, you can use a scalar function.

I can give you a...

Better yet, forget the dopey "cluster first by identity" and cluster the table the best way: that is THE most important thing for performance.

Based on what you've posted, it seems...

As Lowell states, they're not really orphaned.

Extended properties that aren't explicitly subordinated to a db object apply to the db itself.

That is, if you add extended properties w/o specifying a...