Tag Archives: T-SQL

Fun with Savepoints–#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 spent a lot of time with savepoints, but I did find a question recently and thought I’d … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Break Problems Down

Recently I was pouring over a few questions in the forums and noticed something that I would think is obvious, but apparently it isn’t so for other people. A poster was attempting to run a query across multiple databases and … Continue reading

Posted in Editorial | Tagged | 1 Comment

Republish: Embrace Stored Procedures

I’m getting home today,but not sure how wiped out I’ll be. So, one last republish: Embrace Stored Procedures

Posted in Editorial | Tagged | Leave a comment

Finding Objects in a Schema #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 things I needed to do recently was move some objects from one schema to another. I … Continue reading

Posted in Blog | Tagged , , | 5 Comments

No More Mysterious Truncation

If you read the Microsoft White Paper on SQL Server 2019, there’s a gem buried on page 17. It mentions a trace flag, which some of you might appreciate. Here’s a little repro:   As you can see, the plee … Continue reading

Posted in Blog | Tagged , | 6 Comments

Moving Objects to a New Schema

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I haven’t had the need to move an object from one schema to another in years. Really since SQL … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Republish: I Feel Like a Magician

I’m off in the UK and buried with other work, so a republish today. I Feel Like a Magician

Posted in Editorial | Tagged | Leave a comment

T-SQL Tuesday #106 – Trigger Headaches or Happiness

Since I took over the T-SQL Tuesday a few months ago, I decided I ought to host again. Especially since I’ve done it twice, but Wayne Sheffield got his third spot last month. Gotta keep up with Mr. Sheffield. Triggers, … Continue reading

Posted in Blog | Tagged , , | 37 Comments

Generating a Constrained Random Date–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. There have been lots of posts on the topic of generating random values, and some great articles. One of … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Remember the Default Window

I ran across a question recently from a user about why they had strange results from a windowing query. This is better explained with an example, so let’s look at one. I have some data in a table. This is … Continue reading

Posted in Blog | Tagged , | 5 Comments