Viewing 15 posts - 286 through 300 (of 465 total)
opc.three (8/21/2013)
August 22, 2013 at 5:03 am
Well, I got it running using exec xp_logininfo 'nmp\paleoces', 'members'and looping to extract all members. That works, although it seems to me it's asking the same question, just in...
August 22, 2013 at 4:58 am
I do everything myself, application side and database side. I do not allow (myself) access to tables directly. Views, read-only, even if it's just a "SELECT everything FROM table" statement....
August 21, 2013 at 2:53 pm
sqlsurfer101 (8/19/2013)
August 20, 2013 at 12:10 am
sqlsurfer101 (8/19/2013)
August 19, 2013 at 2:04 pm
Lucky man! I'd love to have a sideline like this.
Yeah, it's a pretty interesting place. Some of the top management is straight out of a Dilbert cartoon, but the people...
August 9, 2013 at 3:51 am
ChrisM@Work (8/9/2013)
You're welcome Mr Danes. Assuming you're a taxonomist first and a programmer second, this is a fairly standard method to identify cardinality issues in a query.
No, actually I'm primarily...
August 9, 2013 at 2:33 am
ChrisM@Work (8/9/2013)
August 9, 2013 at 2:01 am
One thing I didn't see anyone mention is size. An index is likely (not necessarily, of course) smaller than the table, so even in the worst case of a full...
July 5, 2013 at 5:59 am
I'm getting a little tired of all the jerkoffs who immediately jump in with comments like "You shouldn't be writing SQL code." Do you suppose anyone believes you were born...
July 5, 2013 at 5:46 am
GilaMonster (4/24/2013)
April 25, 2013 at 3:31 pm
GilaMonster (4/23/2013)
You write here that the database is consistent as of the completion time. Does consistent mean as it is at exactly that instant?
No, I said 'close to the...
April 23, 2013 at 11:20 am
Lynn Pettis (4/23/2013)
pdanes (4/23/2013)
GilaMonster (4/23/2013)
pdanes (4/23/2013)
April 23, 2013 at 9:50 am
GilaMonster (4/23/2013)
pdanes (4/23/2013)
So a backup is a 'snapshot' from the moment in time that the backup process was initiated? And operations performed during the backup process do not get incorporated?
No,...
April 23, 2013 at 9:07 am
GilaMonster (4/23/2013)
pdanes (4/23/2013)
What state are such backups in when they are taken?
The same state they would be in if they were taken without a full/diff running
What does a transaction log...
April 23, 2013 at 8:30 am
Viewing 15 posts - 286 through 300 (of 465 total)