Viewing 15 posts - 33,841 through 33,855 (of 39,736 total)
I also see consultants just hired as bodies. Sometimes just to take on some work that you might not be sure if you want to hire someone full time or...
July 14, 2005 at 8:04 am
I'm not sure where all of these are used. Probably a security site, like SANS.org might have some info. The system account is used for local services that need an...
July 13, 2005 at 3:08 pm
1. I think this is OK, but I can't be sure. If someone had a real license and wanted to give it up, I think this should be allowed because...
July 13, 2005 at 3:05 pm
Got this from the Red Gate folks:
You could probably look at the live log (SELECT * FROM ::fn_dblog(default, default)) to see if there are any transactions after the last backed...
July 13, 2005 at 2:59 pm
BCP will do it. I like DTS as a quick tool to do this easily, set the properties for the text file to have column names in the first row.
July 13, 2005 at 10:25 am
Ray has good advice with the nightly db backup. It's simple and easy. If you want to just grab one table, I'd run a quick DTS pacakge to export to...
July 13, 2005 at 10:21 am
There are some articles here as well on DBAs
http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp
http://www.sqlservercentral.com/columnists/sjones/thevalueofadba.asp
http://www.sqlservercentral.com/columnists/jyao/howtobeagooddbastrategyandtactics.asp
http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp
July 13, 2005 at 10:18 am
Jon,
That's a great question, but there's no way I know of. I'll ping a few people and see if they have an idea.
Steve
July 13, 2005 at 10:18 am
Wow, that is very interesting. It doesn't seem to give great specs on the process in terms of energy required vs energy received, but it seems somewhat self sustaining.
This would...
July 13, 2005 at 10:03 am
I like Remi's solution. Might want to add another column to order by
Select col1, col2, col3, 1 'ord' from dbo.OracleTable
UNION ALL
Select cast(count(*), null, null as SameDataType as col1), 2 'ord'...
July 11, 2005 at 6:35 pm
Which tool are you using? I'm sure Lumigent or the other firm's tech support could work with you to recover the data.
July 11, 2005 at 6:35 pm
July 11, 2005 at 6:34 pm
Viewing 15 posts - 33,841 through 33,855 (of 39,736 total)