Sean Lange (2/16/2015)

---

TomThomson (2/16/2015)

---

Sean Lange (2/16/2015)

---

Great back to basics question. I am shocked at the response rate.

I am really surprised that so...

For starters, you should read this article to gain a better understanding of tempdb and what it's for.

https://technet.microsoft.com/en-us/library/ms175527(v=sql.105).aspx

There are many opinions on tempdb, this is only one of them.

Are...

Sangeeth878787 (2/13/2015)

---

Hi,

What kind of requirement you had to do, do you have script for that, As a newbie I will try to learn and analyse which will helpful to improve...

carrieathomer (2/12/2015)

---

This is the nearest solutions i may use, using the following article.

http://sqlperformance.com/2013/09/t-sql-queries/random-collisions

my scenario,

More 1000000 users registers with site and uploads documents minimum 10. Even though i can use guid,...

Also, keep in mind that what is displayed to the user might not be what is stored in the db.

Using the you tube example, the random value likely is...

carrieathomer (2/11/2015)

---

let us assume i am going to store documents.

for every document i am going to set a primary key that will be an alphanumeric value (may be 4 digits)

n...

Good point, but the name of the video is likely not the primary key of the table.

For starters, as Lowell said, having a key that could be changed is...

Why? What does a sequence, identity, or guid not do for you?

What problem are you trying to solve with this approach?

SQL Server replication may work. It works fine for me. I have transactional as well as snapshot replication in place.

https://msdn.microsoft.com/en-us/library/ms151243.aspx

Had to jump in on this.

The best (worst?) system I have dealt with had every table consisting of an identity clustered PK, a created date time, a created by user...

I think you may be giving up to easily. Or, are very desperate. Or both.

Again, how many interviews have you been on? Do you know why you were not...

Please do not cross post. It's bad etiquette.

There are additional answers to your question on the other post.

hanialbarni (2/9/2015)

---

Hello

I am new graduate from university with Business Information System major.

I am thinking about to study one of the following certificates since I still did...

Can this be a simple case of there are just more people running this query, logging onto the system, running another query that is consuming resources, or any number of...

Windows authentication will not work. The server is not on a domain, it cannot authenticate the user to anything.

Try this.

1. Try creating an ODBC connection from your box.

2....