Thanks John 🙂

Thank you John and Perry

Were you using Number Datatype for MentorNumber column in excel sheet? If no, was it of datatype General?

There are couple of ways to handle this issue. There are some things...

And this is what we do on production environment :

1. 4 tempdb datafiles on Primary File Group with exactly same size (1024 MB) and same autogrowth value (1 mdf and...

There are couple of important things we need to take care of. We must keep in mind that all applications whether those are web hosted or those are executable/batch files...

Makes Sense. Thanks.

Chris Harshman (12/21/2016)

---

SQL Learner - VKG (12/21/2016)

---

In the nutshell, it is well said above that using Replication or other option is better to be used in place of linked server....

In the nutshell, it is well said above that using Replication or other option is better to be used in place of linked server. Just adding one more thought that...

Thanks a lot Guys. It makes sense and I will be taking care of the same.

In the nutshell, what I got from here is; changing any heap into clustered index requires about same amount of space as that of table until that operations is completed....

Thanks for update. That's fine for 10 GB as you are saying. But the thing is, I am running out of space. Is there any other way to achieve the...

I believe, there is also nothing wrong in query you built. Why is it not working?

SELECT

OYHSSQ,

OYNMTP,

OYNAME,

OYADD1,

OYADD2,

OYCITY,

OYSTAT,

OYZIP4,

OYCNTC,

OYPHAR,

OYPHXX,

OYPH04,

OYPHEX,

OYFL18,...