Donato this is how i usually update a table from multiple sources...note the commented SELECT statement so i can run the bottom portion to test before and after:

SET XACT_ABORT ON

BEGIN...

i have this in my snippets as teh way to run DBCC commands on linked servers:

SELECT * FROM OPENQUERY( [linked server],'SET FMTONLY OFF; EXEC (''USE DATABASE; DBCC showfilestats WITH NO_INFOMSGS...

i've seen this when the file you are processing comes from a unix type source...instead of slash-n for the row terminator, which looks for CHAR(13) + CHAR(10), try changing your...

linked servers are slow.

usually a SELECT from a linked server, if it is joining on a local table, will copy the ENTIRE table from the linked server into your local...

i most often add a persisted calculated field for indexing purposes.

I've used it to pull out a substring from a field which is often searched, as well as dates with...

some powerful thread pruning occurred;

i had posted the following and then reported them to the SSC gods:

i'm thinking that chinnu.saha and pinky.bd420 are bots that are just designed to...

still not so bad, but the same solution: the end users will have to enter/select the prefix and suffix, which could even have defaults on them, that's all:

CREATE TABLE EXAMPLE(

id...

one easy way is instead of allowing a vlaue to be entered for your PONumber, make it a calcualted column instead:

CREATE TABLE Example(

ID int identity(1,1) primary key,

PONumber AS 'SomePrefix' +...

every quote that exists between your forst and last...

you've got to look at the execution plan to be sure...

a simple SELECT TOP 2000 FROM SOMETABLE would probably not bloat temp db, but throw in an ORDER BY, and...

I currently maintain a system that does EDI 864 records;(?? didn't really notice they are numbered)

if you have the schema and sample EDI file, I could look to see if...

I've been in touch with some of the guys at a SQLServerCentral related site http://www.sqlshare.com/ to build on skills i do not get to use every day.

I met a few...

this caught my eye, i've done a lot of stuff with following foreign key chains;

how would you expect the table T2 to be displayed? it has two children inder it...would...

just like sa and Builtin\Administrators, and login you create that is part of the sysadmin will inherit the ability to do anything to any database.

CREATE LOGIN [superman] WITH PASSWORD=N'NotARealPassword',

DEFAULT_DATABASE=[master],...

it looks to me that although logically the unique key is just two columns, in actuality for db purposes, shouldn't it include the deleted column as well?

Field1 ...