Viewing 15 posts - 32,086 through 32,100 (of 39,748 total)
I agree with Ian. SQL follows the OS clocks, and if they're not updating, that's an issue. If you have machines in other time zones, use a standard clock, like...
May 14, 2007 at 7:53 am
I did miss the "not at all", which is bad. You definitely need to test systems, though honestly I'm more concerned about the Windows or application level than the SQL...
May 14, 2007 at 7:51 am
Ranges. Determine some range for each server and let it grant IDs within that range.
Or set up a central number distributor. Service Broker would be great, but any distributed query...
May 14, 2007 at 7:45 am
AFAIK, this cannot happen with SQL logins. Are you sure they're not using Windows auth?
May 14, 2007 at 7:44 am
I'd agree as well, but really caution you to be sure your disks are your disks. I've had other vendors really try to build a couple large arrays and then...
May 14, 2007 at 7:43 am
As ALZDBA pointed out, you might not want to change the connection. There shouldn't be "users" in a package, but logins that point to a particular server. If you want...
May 14, 2007 at 7:42 am
Blocking is not bad. It's a sign that you have concurrency issues and the server is preventing someone from reading while data is being changed.
I'd use Profiler and really dig...
May 14, 2007 at 7:38 am
I could see allowing duplicates in a table for some reason, but you'd still want a PK in case you ever needed to work with a row. Even in a...
May 14, 2007 at 7:36 am
Not a lot of T-SQL, or guess if code is correct. There are lots of questions on SSMS, where you have a simulated environment and need to do something like...
May 13, 2007 at 8:36 pm
Typo, fixed now. The $10-20k they see as a investment (for technology, not people), makes it easy to decide to do. Of course they already believed in having a good...
May 13, 2007 at 8:17 am
the Dynamic SQL above is really the only way to do this. the IN statement can't take a bunch of parameters or a comma list by itself.
Be sure when you...
May 11, 2007 at 10:00 am
In that case, restore it as master_old or some other name, not as "master" on another instance. You just want the data in the tables, not the functionality.
May 11, 2007 at 9:50 am
It's not that specific, but it's a nice summary, Rudy.
I like it too!
May 11, 2007 at 9:27 am
May 10, 2007 at 12:59 pm
Cross posted from another thread, not necessarily in response to Simon. Though I do think Simon raises great points:
I think I've done a poor job of stating my BI position,...
May 10, 2007 at 11:29 am
Viewing 15 posts - 32,086 through 32,100 (of 39,748 total)