Not sure how things are allocated, but databases are limited to the 2B object limit.

http://msdn.microsoft.com/en-us/library/ms143432%28v=sql.120%29.aspx

I'd set it to single user or restricted user, with immediate rollback and then restore. This is what sestell1 suggested as well.

That way I can Check things before/after the restore...

There are probably more, but I'd make a rational argument that part of the reason schedules are missed is because developers are not allowed to develop comfortably. They should have...

Tom John-342103 (11/7/2013)

---

At one point, one of the telcos started to offer billing to the nearest second or something like that where the competition could only do it to the...

Pros, you can upgrade dev machines and easily move to other/new developers. You can work at home or remotely without changes.

Cons - bandwidth needs to be there. If there are...

I think this video also has some numa explanations: http://technet.microsoft.com/en-US/sqlserver/gg508899.aspx

As Gianlucca said, the idea is that memory is linked to a node so that it ensures resources are available for...

Eric M Russell (11/7/2013)

---

Ask 100 people how they would envision a "perfect" solution, and you'll get 100 different answers, only 10 of which are even remotely feasible. Implementing and deploying...

Tom John-342103 (11/7/2013)

---

In some business situations, time is of the essence. If a competitor rolls out a great new offer that requires you to change your systems, and you...

skeleton567 (11/7/2013)

---

If users have to circumvent your system to do their job, you have failed. If your support people are constantly handling quality issues and failures, you have failed...

The exact quote from the email I saw. I did not press further as to what "clunky" was, but...

There's a list here of well known ports: http://en.wikipedia.org/wiki/List_of_TCP_and_UDP_port_numbers

In the past, we've typically gone with 51433, just to make it easy for people connecting. However check to be sure it's...

Well, you can import encrypted data. It's just data like anything else.

However, it will be encrypted inside the database as well.

If the file is encrypted (not just the data), then...

I think that's a good estimate of what's being used. It's not what's needed, but it's what's in used based on the workload. You can't assume the same buffer pool...

I think once you get to know your users and company, often it does appear you have telepathy if you're good.

SequelSurfer (11/4/2013)

---

I'm thinking possibly not 😀

Not sure where that score came from but I'll definitely take it, and I had a 29.8...