Because at some point someone probably read an article recommending the creation of...

SQLRNNR (10/1/2015)

---

Ed Wagner (10/1/2015)

---

I'm headed to SQL Saturday Pittsburgh this weekend. I'll be my first visit to this location, but I've heard good things about it.

If anyone lives in...

Do you have any idea why these different statements...

Luis Cazares (9/30/2015)

---

Kim Crosser (9/30/2015)

---

In addition to Try_Parse, there is a new function Try_Convert, which does what IsNumeric should always have done.

set <output_value> = Try_Convert(<type>, <source_value>);

Try_Convert returns the source_value converted...

What's the point? What problem are you trying to solve?

INSERT INTO [Member_Info] ( [MemberID], [MemberNbr],[MM_MIN_EligibilityStartDate], [MM_MAX_EligibilityEndDate] )

select MemberID, MemberNbr,

MIN(M.MonthBeginDate) as [MM_MIN_EligibilityStartDate],

MAX(case when M.MonthEndDate = 0 then 99999999 else M.MonthEndDate end ) as [MM_MAX_EligibilityEndDate]

FROM MemberMonth M...

ALTER TABLE TABLE_NAME NOCHECK CONSTRAINT ALL may work.

But, just out of curiosity, if it's ok to have data in the table that violates the primary key, what's the point...

Is this homework?

What have you tried so far?

What would you use the mod function for?

Based upon the limited information you have provided, try this:

SELECT *

FROM YourTable

WHERE Orderdate...

Jacob Wilkins (9/28/2015)

---

The process that Kristen describes will work nicely.

To really minimize downtime, I like to set up mirrors from the old environment to the new. Then migration is just...

Will a logon trigger work?

paul.knibbs (9/28/2015)

---

Eric M Russell (9/28/2015)

For example, if you have a VarChar column that should only contain values that are covertable to a specific data type (ie: Int or Date), then...

Kristen-173977 (9/26/2015)

---

Not sure about...

Starting and ending dates seem to be an issue for many people. Are the database fields datetime data types? Then check if the code is considering the time...

Remove the with and option recompile.

Start with DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS.

Then, do your 5 iterations of each. See what happens with the execution times.

By doing with recompile,...

Vic Rauch-303403 (9/25/2015)

---

Thank you for all the comments. My question was how to make IsNumeric tell me the truth about an alpha field. UDP Broadcaster did post a...