Ask yourself whether some of these cost and price related columns should really be attributes in a dimension, not measures on a fact table.

To block all readers suring your insert operation, either the TABLOCK or TABLOCKX hint will work.

If developers struggle to install and manage SQL Server on their local PC, imagine if they were left to manage the production database server? I guess it's like a DBA...

Hi Andy,

Let me run this past you.

So, the problem as I understand it is that we really don't need to be informed 1,000,000 times that (for example) an ETL...

First, I'll turn on the radio to NPR news (I hate political\entertainment talk radio and morning rock DJs shows). If there isn't a good feature on, then I'll switch over...

First thing, use a schema comparsion tool to confirm that all the indexes and code changes existing in development have been deployed to production.

Microsoft SQL Server Data Tools

https://msdn.microsoft.com/en-us/library/hh272690(v=vs.103).aspx

Open DBDiff

http://opendbdiff.codeplex.com/

RedGate SQL...

Ha! That's a trick question.

If you had asked how many database servers, then I could give you a total number...

Jeff Moden (10/5/2016)

Not really. ...

Maybe for an ISV, you have a group of developers who are always focussed on new development and then another team that does primarily maintenance and enhancement. However, everywhere I've...

I'd also mention the issue of page splitting, fragmentation, fill factor, and how it all relates to choosing the optimal clustering key combination.

https://sqlperformance.com/2015/04/sql-indexes/mitigating-index-fragmentation

Imagine you're stacking books on a shelf sorted...

Like today, within SSMS Object Explorer, you can right click on a stored procedure, table, view, etc. and select 'View Dependencies'.

Still there are occasions where it's useful to query...

Phil Parkin (10/5/2016)

If there is one feature I'd love to see added is the ability to stronly type worksheet columns, meaning for example that all values within a column would...

Excel is a marvelous tool for presentation and analysis, but .XLS and .XLSX are terrible formats for data interchange.

There have been cases where the business would submit excel documents...

It's important that the DBA be an integral team member. Include their database development and deployment tasks as part of sprint planning and invite them to daily stand-up meetings. Invite...

Let this archived thread be an enduring lesson to anyone currently in the process of building a database...