Study, practice, be sure to know everything that you need and attend the certification exams.

Vague answer to vague question.:-)

What would happen if someone sets the value of ZoneName to

'; DELETE TABLE IPPOOL;

Don't try this on a production environment.

You might want to read about SQL Injection to prevent this...

From what I can understand, you're trying to limit the upper value of type 1 to 24 and types 2 and 3 to 48.

This should do the trick.

Case when Avg...

Sean's code will work just fine as a join to a table that contains the ranges.

An iTVF as suggested by him, might get some performance improvements because you can't never...

jcrawf02 (5/8/2014)

---

WayneS (5/8/2014)

---

Ed Wagner (5/8/2014)

---

No real surprise there. I checked out the site quite some time ago and remarked to myself how miserable the questions were. I also...

Gangadhara MS (5/7/2014)

---

PLAN ATTACHED.

sp_helpindex 'DML.ExceptionstrackingTable'

IX_DMLIsDeletedFlagganganonclustered located on PRIMARYDMLIsDeletedFlag

IX_gangaddednonclustered located on PRIMARYDMLIsDeletedFlag, OriginalSubscriptionKey

NCIX_ActivationModelnonclustered located on PRIMARYActivationModel, ExceptionType

NCIX_BatchIDnonclustered located on PRIMARYBatchID

NCIX_EntitlementIDnonclustered located on PRIMARYEntitlementID

NCIX_ExceptionsTrackingTable_CalcProductKeyIDnonclustered located on PRIMARYCalcProductKeyID

NCIX_GrpIDChannelIDSeqNononclustered located on PRIMARYGrpID,...

I know that this might not be constructive, but I had to ask.

Why do you want that security measure to avoid repeated passwords, but you limit your passwords to 10...

I can't understand your logic. There's no way to get to the first desired row: 10000, 'Starting', 9, 1200.0

Could you explain further?

I agree on everything that Sean has said.

I guess from my part is that your DISTINCT on 125 million rows is generating problems. This might help, and proper indexing should...

+1

It's like asking...

This is just a guess on what you might be trying to do, just a lot simpler and (hopefully) faster.

It inserts everything at once instead of going one item at...

vanamali (5/7/2014)

---

I am sorry...is that really an answer? Congratulations you just added a new post to your 'post count'.

It takes lot of time and effort. I was asking that question...

I can't find a reason to use development time to insert additional line feeds when your mail client shoult format the email correctly.

For a deep answer on those questions, I suggest you to go to the books section[/url] in this site. You'll find great resources available there.

I'm not sure if this is considered simpler. 😉

SELECT duration, SUM(iduration)

FROM (

SELECT duration,

Item...