Viewing 15 posts - 301 through 315 (of 321 total)
I noticed the line wrap problem in the daily message dated 9/25 titled Replication Statement Delivery Options - Part 2 (SQLServerCentral.com 9/25/2007) from SQLServerCentral.com [subscriptions@sqlservercentral.com].
I'll try to forward the message...
September 27, 2007 at 5:23 am
Hate to beat a dead horse, or maybe I just need to get in the last word… Today I had to listen to yet another anti-Access rant based on hearsay...
September 14, 2007 at 5:03 am
Related question--if a table needs a multi-column index as a primary key (to ensure uniqueness) should (some of) the same columns need a different index to support queries on those...
August 16, 2007 at 4:47 am
MS Access is a very powerful and useful application. I have never seen it bashed by anyone who has used it extensivly -- except for the DBAs which are not...
August 14, 2007 at 6:41 am
FWIW, the text of stored procedures is available in the sys.objects view as ObjectDefinition.
The below is a procedure I run daily to capture any changes in my stored procedures/functions/etc....
July 30, 2007 at 6:17 am
A really dumb beginners question re Public Sub Main:
Where (and in what language) is this defined?
Where is the object Dts created?
June 26, 2007 at 12:57 pm
I have seen no performance impact between joins across DBs within the same server v joins within the same DB.
I have seen severe performance problems with joins involving multiple servers....
May 4, 2007 at 4:30 am
I've stopped using Query Designer myself; the first problems I noted were creating/and checking my own SQL statements. If you have not seen the spurious whitespace errors, it must be something...
April 25, 2007 at 8:20 am
I have been bit several times (but few enough that I remember the lesson) when I try to rely on a row order that I KNOW is correct. I think the...
April 17, 2007 at 1:29 pm
Thanks for the registry key information!
March 28, 2007 at 7:58 am
Thanks for your post!
Are you registered? I was unable to send you a private message.
(Just wanted to note that you had typed "fisically" when you probably meant "physically". It's...
March 23, 2007 at 9:02 am
It's easy to be deceived. If you have an order by clause in a view, the view editor adds the top 100 % foolishness to the query. So when you...
March 23, 2007 at 4:59 am
I'd like to see a dummy's guide to assigning permissions to a (new) view for a new user. In particular, defining the logon, creating a group, adding needed permissions for...
March 20, 2007 at 1:08 pm
I don't disagree with anything you say, except for your comment about select * which was not part of the original discussion.
I'm talking about the order in which columns are...
March 15, 2007 at 6:12 am
Viewing 15 posts - 301 through 315 (of 321 total)