I don't think that code generators will replace all of IT. I think that code generators will replace all of the repetative developments that we do...
As I was saying a couple of weeks ago before a got super busy.... I started thining about this little project as a way to come up to speed with C#...
SourceForge aka sourceforge.net is a Open Source website devoted to Open Source developement. Here is the tag line from the website:...
Satya, The link you provided was where I got the reference. INSERT, UPDATE, and DELETE statements at the Publisher on text and image columns are...
I know I CAN use writetext. The question is do I HAVE to use writetext... Thanks, Joe O'Brien
All, I am in the process of pulling together a bunch of scripts and stored procedures I have used over the yeats to generate a series of...
All, I trying to set up replication (one way transactional) from one 2000 instance to another. We have many text fields that we would like to...
anyone have any ideas about how to determine the estimated time of arrival for SQL Server sp4? Joe E O
Two points - it has always been since Sybase/Sql server 4.2 that a user specified checkpoint will not truncate the log... If you want the...
Defragmentation is required for a healthy database? SO if you do it every nighty your database will be supper fast and healthy? Ok, prove it. Show me...
The comment I made was a rhetorical regarding the need to defragment. In my current position the first week I started the performance was awful...
Why oh why are you doing this? Becaues EM makes it easy? Joe E O
How about posting the DDL for the table and the query that was running slowly? I having a hard time believing that fragmentation would change the...
How do you know the poor performance was caused by fragmentation? Was the query that was perfroming poorly doing an index scan?? Joe E O
I don't believe that you have proven that the problem is related to drive fragmentation. You are experiencing waits pageiolatch_ex and...
Is the concern realated to security? If so install ssh and do a secure file transfer. That seems easier that monting sharers and what not. Are you...
Why is it the worst article? Most of the inforamtion is at least partially wrong.... 1) They're not standard SQL. Most products have it but there's...
What was the change in the query plan after the stats where deleted? Did it stop or start using a different index? When you profile - did you see a...
This article http://sqlteam.com/item.asp?ItemID=2599) is one of the worst piece of jibberish I have ever seen posted on a database related website. I...
Separate names with a comma.