Viewing 15 posts - 1,141 through 1,155 (of 1,583 total)
Very True.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 9, 2012 at 9:00 am
LOL - sorry I didn't meant to use that directly, it was just a concept to show you how to calculate the difference between the two datetime fields. Of...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2012 at 3:47 pm
This is pretty vague...what exactly do you mean? Are you wanting to restore the latest backup from Production to Development from a specific point in time or are you wanting...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2012 at 3:30 pm
Use DATEDIFF()???
Example:DECLARE @Time1 datetime = GETDATE()
WAITFOR DELAY '00:00:05:789'
DECLARE @Time2 datetime = GETDATE()
SELECT DATEDIFF(ss, @Time1, @Time2)
result: 5s
-- So Something like...
WHERE modify_timestamps > DATEDIFF(ss, modify_timestamp, create_timestamp) > 1
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2012 at 3:20 pm
Thanks Lowell:-)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2012 at 12:08 pm
If you run a snapshot via the GUI (which is what I always use) it immediately places table/object locks on the tables being bcp'd. This works okay for tables...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2012 at 11:09 am
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 service...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2012 at 10:37 am
Yes, that will be the cause.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2012 at 10:24 am
I know this seem like a silly question but do you have any other compression software running on either one of these servers i.e.(Litespeed or Hyperbac?)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2012 at 9:53 am
If the database is too large and/or there are way too many transactions/minute we do not use snapshot, but sync manually, start replication, then sync again for info that did...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2012 at 9:41 am
This is a highly active OLTP production server where we can easily take a 100 transactions/minute so creating snapshots (which place table locks) is not an option unless we carefully...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 8, 2012 at 9:40 am
This route will allow it to be created but immediately results in errors stating that the rows are not found and the subscriber...
Seems like there should be a setting somewhere...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 7, 2012 at 2:50 pm
Adding a user to the datareader role doesn't necessarily give them access to the database unless CONNECT has been granted at the database level. Permissions are inherited, and depending...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 7, 2012 at 10:37 am
Eugene Elutin (3/6/2012)
So, what else we can add:
1. they differ in purpose:
We are using PK for referential integrity (when paired with FK)
While UNIQUE NOT NUL index(key)...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 7, 2012 at 8:24 am
Here is a really good look at one kind of SPAM[/url]
😛
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 6, 2012 at 8:55 am
Viewing 15 posts - 1,141 through 1,155 (of 1,583 total)