EdVassie (3/19/2012)

---

You should also consider P2P replication.

...

Our testing has shown that if you only ever update from a single site, then these issues simply do not exist. But...

revozex (3/17/2012)

---

Hi Fellow Members,

I have Human Resource data containing many records with years only in Date of Birth column. Currently I'm storing 01-01-1967 if only 1967 is given as year.

How...

I propose the following amendment to "... only programming project with no disagreement whatsoever on code formatting is the one you work on alone", to wit:

"... only programming project with...

Perhaps you could post the connection string in use (minus usernames and passwords), as well as details on anything else in use (such as ODBC DSN's, if you're using them)?

There's also the middle of the road "Wait for the early adopters to report back" approach, which can be good for RTM and SP's alike. Waiting for SP1 isn't...

MyDoggieJessie (3/8/2012)

---

You'll need to take another backup after you've stopped the hyperbac service before you will be able to successfully restore it on the other server (remember to restart the...

I would have to disagree with the...

OCTom (3/9/2012)

---

It's interesting that people think SQL Server 2000 is ancient. I still see code from the '80's and early '90's written for the IBM S/38 and AS/400 machines. And,...

I have the same general approach to Service Broker that I have to DTS, and I do to SSIS: I try to use more standard tools more of the time,...

agustingarzon (3/6/2012)

---

... The users would pick the data types from a few available options (like some one might have mentioned earlier).

The amount of columns would be limited. And it would...

If you're willing, I'd very much like to get a copy of the full results of Microsoft's SQLIO for the following test scenario (or a more comprehensive one, if you...

I'd also recommend using SQL Profiler (SQL:BatchCompleted event) instead of SET STATISTICS * for measuring reads, writes, duration, and CPU time; Gail's Functions, IO statistics and the Execution plan[/url] article...

As Gail and others mentioned, the only good response is to parameterize all SQL in your apps; ad-hoc, dynamic, etc. Deliberately set the data type, the size, and so...

MiguelSQL (3/7/2012)

---

Hello,

Two things:

1- Restarting SQL in single mode (using the -m flag) will allow any person that is a member o the Windows Local Admin group to be automatically a...

agustingarzon (3/4/2012)

---

Honored with your suggestion, Jeff 😉

Thanks guys, I thought there would some difficulties crossing the database boundaries but with your suggestions it seems that this could work seamlessly.

Best...