Viewing 15 posts - 35,671 through 35,685 (of 39,720 total)
sp_password null, <new>, sa by any administrator
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 3:25 pm
check our script library, there are a few different ones there.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 3:21 pm
The SQL Server db would be the warehouse. The movement of the ASCII file would be the ETL (extraction, transformation, and loading) phases.
A warehouse can be used for querying, bilding...
November 11, 2003 at 3:20 pm
don't think there is a way.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 3:17 pm
I'd create a clustered index. I hear over and over that the query optimizer likes this. Even if it isn't meaningful, I think having one helps.
That being said, create and...
November 11, 2003 at 3:15 pm
What is right before and after this?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 3:12 pm
Honestly, I haven't found a good way to do this. I suspect some type of UML tool like rational would work well, but they are so expensive and you have...
November 11, 2003 at 3:11 pm
I'm sure there's a way, but offhand I can't remember what it is.
this might help a little:http://www.sqlfe.com/default.asp (haven't used it)
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 3:09 pm
the only way you could check across all servers would be if you have linked servers connecting them.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 3:02 pm
Hey, I saw the Concorde out here at the Museum of Flight in Seattle. Looks pretty cool. Not economical, but everyhting can't be about money. Lots of pride in that...
November 11, 2003 at 3:00 pm
Thanks for the notes and suggestions. Busy with PASS now, but I'll try to test later.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 2:59 pm
How often does this happen? I've setup a separate table, have the user (through some interface) insert a value here and then have a job run every minute/10 minutes/hour/whatever, and...
November 11, 2003 at 2:56 pm
There are a number of products to do this. FMS Software makes one.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 10:26 pm
The clustered index is the data. So if you move it, then the data moves. The PK may or may not be the clustered index. They are not related, though...
November 6, 2003 at 10:06 pm
Chris is right. You cannot restore with people in the db. You could implement 2 phase commit as well, but that would be a pain and a lot of work.
Steve...
November 6, 2003 at 10:05 pm
Viewing 15 posts - 35,671 through 35,685 (of 39,720 total)