Tag Archives: SQLPrompt

Filtering sp_who

Posted on August 27, 2019 by thomasrushton

sp_who – useful – up to a point. Particularly when the server is busy, and you’re looking for something specific (eg to see if certain processes are out of a database before running an update) If the server is busy … Continue reading →

Posted in Uncategorized | Tagged , , , , | 2 Comments

Redgate SQLPrompt – Backup your code snippets

Posted on January 15, 2019 by thomasrushton

You’ve got a new computer? And you want to copy your code snippets over? Or you’ve got a new colleague and want to share your stuff? Or you’ve got multiple machines an want to keep snippets in sync? You’ll want … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | Leave a comment

T-SQL Tuesday – Bad Habits – Fixed by SQLPrompt

Posted on February 13, 2018 by thomasrushton

T-SQL Tuesday again. And it’s been a few months since I last blogged, let alone for this blog-party, but, hey, I’m here now. This time, Aaron Bertrand (blog|@aaronbertrand) has given two options – and, given the amount time I’ve been … Continue reading →

Posted in T-SQL Tuesday | Tagged , , , | Leave a comment

Redgate SQLPrompt Execution Warnings

Posted on May 14, 2016 by thomasrushton

What? Have you never run a DELETE or an UPDATE without a WHERE clause by accident? Was it on Production data, on the busiest day of the year? Actually, y’know what, that doesn’t matter. Even it happened in the middle … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 3 Comments

SQL Jobs – On a Calendar?

Posted on April 30, 2016 by thomasrushton

SQL Server backup jobs are IO-intensive, he says, stating the obvious. When you have a lot of servers which have been set up over the years, and you’re new to the environment, and want to see when storage is being … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , , , , | 19 Comments

Shock – Red-Gate SQLPrompt Slowed Me Down!

Posted on April 26, 2016 by thomasrushton

Red Gate’s SQL Prompt, touted as a productivity enhancer, actually slowed me down debugging a query. This doesn’t happen very often, so I thought I would share the story, such as it is… Once Upon A Time… I had created … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | 9 Comments