Viewing 15 posts - 37,216 through 37,230 (of 39,511 total)
if it's the same structure, write a query to get the data you want to move, i.e.,
select Col1, Col2, Col3
from BigTable
where Col1 >10
Once you have your queries,...
July 8, 2002 at 1:38 pm
Nice article, however I think some of the lesser experienced might like some more commentary on how it works. For me, however, its nice to see how someone else does...
July 8, 2002 at 1:33 pm
You can also write some script to remove them manually.
Steve Jones
July 8, 2002 at 1:29 pm
Wow, someone is doing there job. I had assumed this was some sort of MD5 or other one way hash, but apparently not.
I guess NT Auth is starting to look...
July 8, 2002 at 10:22 am
Reinstall Visio. Haven't had issues with this, but I don't like it as a tool for modeling because it gets cumbersome and is not reliable for reverse and forward engineering.
ER/Studio...
July 8, 2002 at 10:08 am
Does this table have a different collation? Can you access it from Query Analyzer?
Might be a data issue.
Steve Jones
July 8, 2002 at 10:04 am
No. Easiest way to do this is run Trace and check for activity in that db. Maybe for a month. If nothing appears, then you can archive it.
Steve Jones
July 8, 2002 at 10:03 am
Completely agree with Brian (and thanks).
The GUI does cause slowdowns and issues in deployment. A few references (from my point of view):
http://www.sqlservercentral.com/columnists/sjones/wp_gui.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp
Steve Jones
July 8, 2002 at 10:01 am
Or sp_spaceused.
Either will force you to do some calculation.
The full backup is also a good indication of space used. Run one for each filegroup.
Steve Jones
July 8, 2002 at 9:47 am
The only other (easy) way to do this is a bunch of triggers on all tables that insert the data into other tables. There are some tools (I think Lockwood...
July 8, 2002 at 9:46 am
Interesting and thanks. Glad I could summarize it.
I didn't have any bugs, but the warning from Erwin when I changed tables bothered me, so I decided to find out exactly...
July 8, 2002 at 9:42 am
I am always suspect of "I think it works differently"
EM may script different than what you would do, but that does not mean you are doing it wrong.
If you have...
July 3, 2002 at 2:49 pm
Viewing 15 posts - 37,216 through 37,230 (of 39,511 total)