Viewing 15 posts - 1,741 through 1,755 (of 3,061 total)
jcrawf02 (7/15/2010)
... any chance you have a link to further reading on the second paragraph?
Is more of a subtle change of mind set, you may want to start here... http://www.sqlservercentral.com/articles/Miscellaneous/dbmsvsfilemanagementsystem/1047/
July 15, 2010 at 7:56 am
Jeff Moden (7/14/2010)
Would anyone care to do a translation for the rest of us, please?
OP wants to know how to move data from SQL Server to Fox-Pro 🙂
July 15, 2010 at 7:40 am
It all depends on you naming convention.
In some cases the author of the naming convention may be tired of having to explain why tables are the only objects that lack...
July 15, 2010 at 7:36 am
Nested views should be used with moderation.
They are great when properly used - Ingrian encryption appliance relies on two layers of nested views and it works just fine.
On the other...
July 15, 2010 at 7:28 am
The secret is to be sure date_field and mask have matching formats
TO_DATE(date_field,mask)
like:
to_date('07/14/2010','mm/dd/yyyy') <= This is good
to_date('07142010','mmddyyyy') <= This is good
to_date('20100714','yyyymmdd') ...
July 14, 2010 at 6:44 am
Amazing documentation, Thank you a lot Tom.
I'm saving these jewels on my private library for future reference 🙂
July 14, 2010 at 6:09 am
If the idea is to start SQL Server in "normal" mode you can either...
1- Start the SQL Server Service or,
2- Command line: sqlservr.exe (assuming this is the default instance)
July 13, 2010 at 5:36 pm
hxkresl (7/13/2010)
So at this point I am limited to using only the cmd line until I can get the underlying problem solved?
Not clear to me what the problem is.
I...
July 13, 2010 at 4:26 pm
CavyPrincess (7/7/2010)
Perhaps this may help someone in the future.
Certainly. Very nice, well referenced documentation.
July 13, 2010 at 4:22 pm
hxkresl (7/13/2010)
Next I click Start->SSMS->Connect and I get this error:
"Login failed for user '<instance>\Administrator'. Reason: Server is...
July 13, 2010 at 4:15 pm
Steve Jones - Editor (7/13/2010)
Typically this is why it is implemented on the back end, often with constraints, less often with triggers.
Agreed.
PKs/FKs when enforcing RI in the -local- database.
Triggers when...
July 13, 2010 at 4:03 pm
Okay ... too much going on in a single post, let me pick one...
Anye Mercy (7/13/2010)
Is partitioning something that could help me?
Partitioning is usually implemented to help in administrative tasks...
July 13, 2010 at 3:58 pm
Script Component will do it.
Check here for details... http://msdn.microsoft.com/en-us/library/ms137640.aspx
July 13, 2010 at 3:47 pm
Been there, done that - several times, both directions.
Data is usually a walk in the park.
Fun begins with the code - the sensible thing to do is to rewrite it...
July 13, 2010 at 3:29 pm
azadsale (7/13/2010)
then is it ok if i clear the cache after this process(rebuilding indexes).will it...
July 13, 2010 at 12:27 pm
Viewing 15 posts - 1,741 through 1,755 (of 3,061 total)