Any chance you can change the data model?   It doesn't make any sense to have a separate table for students and employees, as you could easily incorporate a PersonType field...

What I suspect you just need is an index on the date field.   Just having a primary key doesn't necessarily improve things all by itself, unless you had some need...

First, be sure that each instances services are up and running. There are a couple of ways to do that:

1.) Bring up Task Manager and validate that each...

wweraw25 (1/11/2017)

---

I have a column something like below

Number

14522345

15235642

16289563

16287423

30245123

31451831

32452632

31458142

I need to split into two columns

Number A Number B

14522345 ...

wweraw25 (1/11/2017)

---

I have a column something like below

Number

14522345

15235642

16289563

16287423

30245123

31451831

32452632

31458142

I need to split into two columns

Number A Number B

14522345 ...

scotdg (1/6/2017)

---

I have to write a query that lists orders and partitions them by customer id# and displays the date, customerid, name, order_amount and count on each line. I then...

Stueyd (1/11/2017)

---

Thanks for the reply.

However the requirement has now changed...

Rather than having the server and disk data displayed together they now need to be on separate lines.

Just to re-iterate...

I have...

qjt (1/11/2017)

---

Thanks, SSCrazy

I run a command "DBCC MEMORYSTATUS "

It shows a list of use of memory

Available Physical Memory28611772416

Available Virtual Memory8778531528704

Available Paging File62421553152

Working Set2031136768

Percent of Committed Memory in WS100

Page Faults522152

System physical...