When the infrastructure team patches windows server and reboots, I would like to have a solid checklist of things which should be done to say 'sql server and databases...

I hear a whole lot of people making that recommendation.  Try/Catch is usually not necessary, especially in the presence of SET XACT_ABORT ON, which will auto-magically produce...

No, Jeff, an identifier is by its very nature measured on a nominal scale. It is not an interval scale. It is not a ratio scale. It is not...

• This reply was modified 6 years, 9 months ago by Jeff Moden.

Jeff,

I spent the last 2 days or so on the first article.  I got about half way through.  I think I understand the concept.  One part I couldn't figure...

If it's a joined update, please...

in VS - yes we can use the variables to replace with the appropriate database name - This can be done on the synonyms so we can still avoid...

From the Article:

Triggers are not allowed in our production environment...

Heh... I realize that a lot of folks abuse triggers and write horrible trigger code but flat outlawing such an incredibly...

I take it you never need to make copies of prod then or, perhaps, you use the same method to make such copies?  There's just no way that I'd allow...

For ad hoc stuff, I don't use a programmatic method to commit or rollback.  Someone at one of the companies I used to work for did such a thing.  There...

@tsalha,

Are we talking about front end code or stored procedures here?  And, please pardon my ignorance of VS.  I've never actually used it.

I haven't used the MERGE statement since I got burned many years ago doing a

WHEN NOT MATCHED BY SOURCE THEN DELETE

As it turns out, you end...

We once used to utilizing them, but with the advent of database projects in VS, we abandoned them again from our development. This due to the reason, that VS...

Interesting.  I've...

p.s.  Two of the better articles in this world on what APPLY does can be found on Paul White's "author" page.  He has some other helpful articles there, as well. ...

1. In the second block of code, the SELECT statement has a column called value.  But the table that was created in the first block of code doesn’t have...