http://www.bing.com/search?q=source+control+sql+server

or

http://www.google.com/#hl=en&sugexp=les%3Bernk_timediscountb&gs_nf=3&gs_rn=0&gs_ri=hp&cp=15&gs_id=1l&xhr=t&q=sql+server+source+control&pf=p&tbo=d&output=search&sclient=psy-ab&oq=sql+server+sour&gs_l=&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.&fp=ff2852371cfa3161&bpcl=39314241&biw=1920&bih=985

I keep copies of any script I might need again in SkyDrive.

DropBox, so far as I know, requires an application to be installed locally before you can access...

Use source control for object changes in your database.

If you can't use source control, use a DDL trigger to track the changes.

But source control is really the correct solution.

Against small datasets, Nested Loop Joins are often the most efficient. SQL Server pretty much assumes table variables will have 1 row in them. Since it doesn't maintain...

There's no need to convert Like to = if it doesn't include any wildcards. Just use Like. SQL Server will treat it as an equality test if the...

pdanes (11/30/2012)

---

I'm working on the syntax of dynamic SQL with parameters, but I find myself coming back to the same question that actually started this thread: If I use the...

Most of the French alphabet is supported by Char/Varchar.

It gets complex, and the documentation is seriously (a) vague, and (b) incomplete.

Good. Just keep in mind that, if the table variable has more than about 10 rows, it's probably slowing your query down, and you might want to replace it...

Temporary files used by Reporting Services. Basically, don't mess with it unless you're willing to rebuild the server from scratch, because you could easily mess up things needed for...

There is a row version value stored by the system, in order to deal with snapshots, but it's not something you have access to.

If you need to track that kind...

I'd start with: http://www.vmware.com/files/pdf/sql_server_best_practices_guide.pdf

Yep. Test server is the way to go.

Is the data already in XML format, or is it relational (tables+columns+rows)? Can't quite tell from the post.

XML is handled by the application if you want it to be anything more than just text with funny punctuation.

SSRS isn't built to present XML as a graphical plan. ...

Can you replace the table variable with a temp table and see what that does?