Tag Archives: T-SQL

Avoiding Stored Procedures

This editorial was originally published on Aug 13, 2012. It is bein re-published as Steve is on vacation. I ran across this piece from a developer on why he avoids stored procedures and thought it made some good arguments. The … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Output into a Table–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I often see people struggling to use triggers for auditing, or having issues with building them to handle multi … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Rounding Challenges–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Rounding is an interesting activity, and one that I think people sometimes don’t pay enough attention to. Recently I … Continue reading

Posted in Blog | Tagged , , | 4 Comments

Dropping Masking from a Column–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a quick one. As I experimented with Dynamic Data Masking for the Stairway to Dynamic Data Masking, … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Quick Scalar Tables–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This actually comes from Itzik Ben-Gan, by way of Kevin Feasel.  Kevin’s post is about CROSS APPLY, which is … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Rename a Primary Key–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Having system named objects is one of those things that people may debate, but as you move to more … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Getting Table Change Scripts–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the really basic things I think everyone should understand is how to get scripts from Management Studio … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Using sp_executesql Parameters –#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I haven’t used sp_executesql much. Instead, my habitually way of executing dynamic SQL has been with EXEC(). There are … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Basic XML Node Query–#SQLNewBlogger

  Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a question recently about querying an XML document. Certainly avoid this in the database if you … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Getting the Previous Row Value before SQL Server 2012

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across a post where someone that was trying to access the previous value in a table for … Continue reading

Posted in Blog | Tagged , | Leave a comment