Finally it looks like your posts are back Jason, and good job on the sample and test code. The addition of the index does remove the primary sort but optimizer...

Fingers

Steven W (5/30/2015)

---

I started the shrink file last night but I forgot to script it and instead just hit the "OK" button. I see the task running in activity...

Zingiberaceae

A currently active thread: "I don't use any clustered indexes actually... all of mine are non-clustered..."

Sometimes I do wonder where things went wrong with MS and SQL documentation/references/best practices...

😎

That's not making things easier, may I ask why not?

😎

For clustered indexes (non-heap tables) No, for Non-clustered indexes Yes,...

Lynn Pettis (5/29/2015)

---

Eirikur Eiriksson (5/29/2015)

---

Lynn Pettis (5/29/2015)

---

We know that the Crystal Ball shows nothing but the clouds, but where is the silver spoon?

< rant >

I am still amazed at how...

Another attempt using Lynn's fine code

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.SystemsRE') IS NOT NULL DROP TABLE dbo.SystemsRE;

CREATE TABLE dbo.SystemsRE (SystemID INT NOT NULL, IpAddress VARCHAR(200) NOT NULL);

INSERT INTO dbo.SystemsRE(SystemID,IpAddress)

VALUES

(10001,'132.135.3.100,...

Lynn Pettis (5/29/2015)

---

We know that the Crystal Ball shows nothing but the clouds, but where is the silver spoon?

< rant >

I am still amazed at how many people have to...

Then the approach has...

Quick question, how many tables are in the database?

My normal approach to this kind of problems is to add a filegroup / data file, move the data to the new...

TJT (5/29/2015)

---

I am trying to get this to work without sample data and I get IP_ADDR is not recognized. I really appreciated everyone's patience on this.

SET NOCOUNT ON;

WITH SAMPLE_DATA(IP_ADDR)...

Luis Cazares (5/29/2015)

---

thisisfutile (5/29/2015)

---

You picked up from this thread that Joe is banned? Maybe I...

Topic