the problem is SQL uses a hard 20% rule to determine if statistics are auto-updated or not;on a million row+ table, that's not often enough

here's a work in progress i...

a better example: in Oracle in whatever database, you might add a new user "SQLPassThru", and give that user access to 3 specific tables, and nothing else.

that Oracle user would...

newbieuser (10/3/2009)

---

Thank you so much Lowell.

Is linked server, the only option to access Oracle database from SQL server stored Procedure? Is linked server, basically like a database object...

pretty sure a db link is an Oracle-to-SQL server ODBC connection.(well to many other db systems, but say SQL for now)

a linked server is the equivalent: a SQL-to-Oracle ODBC Connection.(SQL...

there's a great article here on SSC on creating a google like full text search[/url], which does everything you are asking and more; I'd suggest going that way first, as...

i have this "SCRIPT ALL INDEXES with Include" saved in my snippets, and supposedly it will also do the INCLUDE syntax, if it was used. I haven't fully tested it...

interesting, what does this return:

SELECT substring(name,1,8)as name,id,xtype,uid,user_name(uid),suser_name(uid) FROM sysobjects WHERE [name] LIKE 'table%'

there might be an easier way, but this is what i've been using:

i've got one database with three schemas "dev", "qa" and "dbo"

using this gets me all the tables,procs, etc....

wow..i'm leaning towards the opposite of Paul above. I vote for validation in both tiers.

I think check constraints and defaults, FkKs have a minimal impact at the database level, and...

blawrence (9/30/2009)

---

Hi Lowell,

All is perfection!

Thank you again and again, you have been an amazing help through this endeavor. You have been crystal clear in your explanations. Thank you again for...

I had also tripped over the same issue and if the following assumptions are true, this script might help:

the first column of the table is a sinlge column PK, identity...

as you get more familar with SQL, you'ss see that any column can bbe replaced with a hardcoded value, and vice vers in just about any SQL:

this is the enhanced...

instead of using the column name [fphone], simply change it to the static value of '1':

MyLinkedServer.PhoneNumber2 = '1'

your code seems to be doing stuff differently....are you updating the Linkedserver...

AFAIK, you trace flag(s) will remain in place until you stop the service...when you stop and restart, only the flags that are part of the command line for starting the...

this one is specific to the data:

ISNULL(MyLinkedServer.Initial,'A') AS fmi,

your original data source has what i though is the middle initial of the name, right? (if that's wrong, let...