Viewing 15 posts - 55,276 through 55,290 (of 59,072 total)
You know me, Ryan... extraordinary claims require extraordinary proof... got code to prove that? ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2007 at 5:31 pm
I don't see any records in your post...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2007 at 8:23 am
Yes, there are some tables that know exactly which rows have changed... trying to teach you to "fish" a bit... read about "Triggers" in Books Online.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2007 at 8:21 am
What say the da?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2007 at 8:18 am
When I first started to read this, I thought "Jeez... that's a little obvious, Andy. Hardly worth an article."
Now that I see...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 23, 2007 at 8:00 am
You still mean writing in embedded SQL or what?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2007 at 11:54 pm
I'll go one further...
"Monitor and tune database resources and activities for SQL Server databases"
Does that include being allowed to beat the hell out of developers that write performance challenged code?...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2007 at 11:51 pm
Sorry... If your interview was for the postition of DBA and you do not know these things, you are simply not qualified to be a DBA.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2007 at 11:47 pm
This smacks of a "paging" problem... is that what you're trying to do?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2007 at 11:39 pm
What is "a" and what is "b"... they are not in the table you described. I realize there is a bit of a language barrier problem here, but do the...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2007 at 11:37 pm
Export to text file. Use SQL*Loader to load the text file. Stop using DTS.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2007 at 11:32 pm
Learn what?
Basic SQL?
ANSI SQL?
T-SQL?
Advanced T-SQL?
Performance tuning?
???
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2007 at 11:31 pm
Are you doing this using embedded SQL in your VB code? If you are, that is likely the problem...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2007 at 11:23 pm
Instead of telling us how you want to do something, it would be much more beneficial to yoru cause if you told us what you wanted to do and why....
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2007 at 11:20 pm
...and why are you using a cursor? ![]()
--Jeff Moden
Change is inevitable... Change for the better is not.
August 22, 2007 at 11:18 pm
Viewing 15 posts - 55,276 through 55,290 (of 59,072 total)