Viewing 15 posts - 37,351 through 37,365 (of 39,720 total)
Part 4 links to the others:
http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp
Steve Jones
July 18, 2002 at 5:59 pm
Don't think that will work, but when you say duplicates, I assume you mean duplicates outside the PK? Or does the original table not have a PK?
Steve Jones
July 18, 2002 at 5:58 pm
I've always had one db per device. I suspect the only issue is really with backup and restore. I would move it, but that would be for better organization and...
July 18, 2002 at 5:56 pm
Vote 3 = Can't be done
Steve Jones
July 18, 2002 at 5:55 pm
Haven't seen it, but you might try posting this with another description in the T-SQL forum.
Steve Jones
July 18, 2002 at 5:54 pm
Pls don't cross post. All forums are checked by many people (using Active Threads at the top). We see all these posts.
Steve Jones
July 18, 2002 at 10:14 am
It's a gredy human issue. E Coli outbreaks in Colorado meat packers and USDA is somewhat either in bed or influenced by them.
Enron (need we say more), Worldcom, etc.
Greed in...
July 18, 2002 at 10:13 am
It really does look like a Data Mart issue, but that is more of a batch process, not real time.
I guess you could use replication to move relevant data (duplicated)...
July 18, 2002 at 10:06 am
That's a strange one. My guess is that it is rewriting the file for some reason before the backup.
Don't use INIT, try to ensure that each backup file has it's...
July 18, 2002 at 10:01 am
That's a tough one. IT's late and I don't have a good answer for you, but off the top of my head, I'd say aggregate on the client code. More...
July 17, 2002 at 10:07 pm
You will get an additional security check. However this is small overhead. The separate db should generate a separate thread for I/O, so it may make up for this.
Steve Jones
July 17, 2002 at 10:05 pm
Run profiler. Connect to your server and specify that you want the T-SQL events and the filter based on the database.
Steve Jones
July 17, 2002 at 10:04 pm
You'd need a self join and a subquery.
Join one looks for logins. This joins back to the same table for logouts, but with the same ID. Also, the logout time...
July 17, 2002 at 10:02 pm
There is not, but you can fake it (somewhat) with this:
http://www.sqlservercentral.com/columnists/sjones/tamestrings6.asp
Steve Jones
July 17, 2002 at 10:00 pm
select top 50
will get the first 50. For me, I do an order by and pass in the 50th result for the where clause to get the next 50
select top...
July 17, 2002 at 12:56 pm
Viewing 15 posts - 37,351 through 37,365 (of 39,720 total)