It would be enlightening to hear what environment actually requires the CHAR(13).  Everything I've tried is happy with plain old CHAR(10), or is smart enough to recognize that as an...

Just to nitpick, this drives me crazy:

SELECT 'string expression' + ';
END'
+ CHAR(13) + CHAR(10) + 'GO'
+ CHAR(13)...

There is no question that XML causes the data files to bloat.  On the other hand, it is much less ambiguous than swapping CSV files with knuckleheads who don't know...

The restore location is the original file locations, or you can use RESTORE VERIFYONLY ... WITH MOVE to specify somewhere else.  Either way, the restore location is always defined.

If you are using DBCC CHECKDB you should have no trouble looking up the syntax for adding REPAIR_ALLOW_DATA_LOSS.

And while you're at it, do some research on what might go...

You have to be a sysadmin (under default settings) to run xp_cmdshell.  Also, in both cases, the directory has to be readable by the SQL Server service account.  And I'm assuming...

You could experiment with these commands:
EXEC sys.xp_dirtree '\\tntfappl11.companyname.net\Project012\1.Cust\LDSH\4\7', 1, 1;

EXEC sys.xp_cmdshell 'DIR \\tntfappl11.companyname.net\Project012\1.Cust\LDSH\4\7\*.csv';

You would want to create a temp table or table variable...

Anyone recommending that you should avoid the FLOAT datatype should be reminded that all the functions in this calculation (SIN, COS, ATAN, SQRT) will convert their parameters to FLOAT and...

If you have tab-delimited files exported with BCP, and loade them into Notepad++ or another editor that can highlight special characters, you may see a lot of NUL (char(0)) values. ...

You don't provide rowcounts, but a large delete may be faster if done in chunks.

WHILE 1=1 BEGIN
    DELETE TOP (10000) FROM table WHERE condition;
  ...

It's not a question of syntax, you just can't change the ConfigurationFilter property of a configuration item at run time.

There are ways to change the values that are...

CREATETRIGGER should be two words, CREATE TRIGGER.

If you ever insert more than one row into Jobs, the trigger will fail at SET @foundguid = (subquery), as the subquery...

I have used DELETE with OUTPUT to implement FIFO queue behavior.  In one atomic operation it can delete the first row from the queue table and return the values from...

The only plausible interpretation of "table creation sequential order" to me is an order that puts referenced tables ahead of tables with foreign keys that reference them.  Creation date is...