In all fairness, it would be useful on occasion to have a feature, let's call it "Delayed Consistency", allowing one to perform multiple DML operations within an batch transaction, perhaps...

Compare the execution plan between the two servers for an identical query using same parameters.

If this ID is a sequential integer, then use IDENTITY.

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...