i just sat in on a SQLSaturday #79 in Davie(Fort Lauderdale) presentation on how to improve performance in exactly this situation;

the Presenter was Dimitri, and he had a great example...

much easier to comprehend...that whole pseudo code to abstract the logic actually made it harder to understand.

the rules you pasted are actually multiple separate and distinct check constraints....all of...

http://www.quest.com/litespeed-for-sql-server/

SQL LightSpeed is a third party applicaiton that creates backups for SQL server; it's faster than native backups and also compresses the backups to a smaller size.

you'd have to have...

zozilany (8/15/2011)

---

I am trying to create a Linked Server to an MS Access database on a computer other than where SQL Server resides. I can create the linked server if...

Sachin Nandanwar (8/14/2011)

---

Just because you define it as a "Best Practice" and it gives me an overhead in maintenance then surely I am better off in not using those "Best...

don't you have to explicitly state you are inserting nvarchar? otherwise there is an implicit conversion wich is incserting the question marks

this may help a little;

this gets all the directories in a given directory.

from there, you can cursor thru to build what i had hard coded to 4 specific directories:

--some variables

declare...

ok here's a full emaaple then, all in TSQL:

this is getting every *.txt file in four different folders, and inserting them all into the same table.

my table "BULKACT" would be...

would the table already exist that you want to import into?

would all the csv files be the same format?

if the above two things are true, you could use xp_cmdshell to...

--if you are going to put this in MASTER, and want it to be able to query

--each database's sys.columns, you MUST mark it as a system procedure:

--EXECUTE sp_ms_marksystemobject 'sp_UglySearch'

Sean's so right on this...this is not a production tool.

if you have a MillionBillionRow table, and it has 15 varchar columns...it's going to tablescan that table 15 times.

this is...

sp_msForEachDB ' SELECT ''?'' AS DBName, name As UserName from ?.sys.database_principals'

here's the BOl article about it:

http://msdn.microsoft.com/en-us/library/ms142491.aspx

the xml example that we talked about would look like this, i think:

<expansion>

<!--first word is our keyword, all the others are...

yes exactly. in your example,...

anything not in the stop list is searchable...but you might want to look at the thesaurus, where you can add cross references for words that don't exist in your data.

a...