I don't know, Lowell. It doesn't make much sense to me to have a nonclustered index on the same field as your clustered index unless the nonclustered index contains...

Lynn Pettis (11/13/2013)

---

Just finished the interview, and I feel like a Junior DBA....

All the best, Lynn. I'm sure you'll do well. Hopefully, you'll...

Kurt W. Zimmerman (11/13/2013)

---

SQLRNNR (11/13/2013)

---

crookj (11/13/2013)

---

Gas (sorry...

Probability

Random

Trainee SQL (11/13/2013)

---

Hi all,

I am facing a problem in writing a query.

Here is my requirement

i have a <products> table with columns <productid> <productname> <manufactureDate> <DeliveryDate>

and some columns are filled with...

Greg Edwards-268690 (11/13/2013)

---

venoym (11/13/2013)

---

L' Eomot Inversé (11/12/2013)

---

wolfkillj (11/12/2013)

---

My new blog post on appropriate data types for storing latitude and longitude coordinates is up.

Thanks for indulging me in a little...

subbareddy542 (11/13/2013)

---

hi,

first can u create one function to use below code.

CREATE FUNCTION SPLIT(@VAL VARCHAR(MAX))

RETURNS @T1 TABLE(COL1 VARCHAR(MAX))

AS

BEGIN

WHILE CHARINDEX(',',@VAL)>0

BEGIN

INSERT INTO @T1 VALUES(SUBSTRING(@VAL,1,(CHARINDEX(',',@VAL))-1))

SET @val=SUBSTRING(@VAL,(CHARINDEX(',',@VAL))+1,LEN(@VAL))

END...

Koen Verbeeck (11/13/2013)

---

First of all, this question is way too easy. Enterprise has all the features, so you don't even have to think.

Secondly, developer is the same as enterprise feature-wise,...

Napoleon

I have to agree with Jeff, Steve and Kurt. As I turn more gray with each passing day, I think that perceived age can work against you later in...

I have .NET pages that call stored procedures where I specify the parameter values by name and they work with no problems. Since some parameters are optional and have...

Spam

Tree