Surrogate keys are only better in terms of being easier to join.  But if the source data has a natural key there almost always value in enforcing that even if...

Thanks. Question is do you really have room for improvement, when you your table is large as 176M rows and your view on top of that table returns everything...

Transactions are designed to maintain consistency across multiple transactions(and allow the...

Unless you're actually storing the result in a database field is there any performance difference between varchar or char?  If you are just for example returning the result...

• This reply was modified 2 years, 5 months ago by ZZartin.

I find it interesting...

Another option if you don't want to be moving data between your local and the prod server, creating temp tables, CTE's etc... would be to use SSIS and just do...

Keep it simple: Simple designs are often the best designs. By keeping things simple, you can reduce complexity and make your software easier to use.

On this note, the over all solution...

This entirely depends on what the system consuming the XML is expecting.

Why is it acceptable that a test environment is less secure than a production environment?

Cry last time I rebuilt my computer I used an old windows install(it...

Getting back to this post, if you know how to think and how to write good T-SQL (accurate, performant, well documented with comments, and well formatted for readability), I'm...

My questions are that if granting permissions and end user proficiency are a problem how is the solution of creating a filter table better?  That still requires the user to...

Eh... hopefully this is just a one off....

Something looks off with that UPDATE that is being done on the table the trigger is on, it's setting a variable instead of updating a column on the table and...

What is the nature of the process that will be using the file?  There's a lot of options to get a table out of SQL Server into a file and...