TRUNCATE TABLE Does NOT Preclude A Point-In-Time Recovery

There is a lot of information in the world that people just assume is true because it has been repeated so much. Twinkies have an unlimited shelf life.  McDonalds hamburgers have so many preservatives, they will never get moldy. The problem is this information is frequently wrong. But the incorrect information is so widespread and […]

Local Variables Declared Repeatedly

I ran into some unexpected behavior with local variables that I think should be pointed out. Normally, local variables can only be declared once in a query. For example, this code: produces this error: Msg 134, Level 15, State 1, Line 2 The variable name ‘@TestInt’ has already been declared. Variable names must be unique […]