Queries

You’ve got one SQL Server hosting a bunch of databases, and performance is bad. Which database should you focus on first?

2019-05-02

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.79 (138)

You rated this post out of 5. Change rating

2016-06-10 (first published: 2015-04-02)

22,767 reads

Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...

As I use containers more and more to run various things, I decided I...

Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...

I maintain an application written years ago, where the database is on a Windows...

I’m working on a jewelry e-commerce project and need advice on designing an efficient...

Comments posted to this topic are about the item The Duplicate Cursor

Can I run this code:

DECLARE ANewTable CURSOR FOR 
SELECT * FROM ANewTable