Generic paged data like MySQL LIMIT

This works, however code is creating a live temp_1 table in the database instead of using a #temp_1 temporary table because is just would not work.The next idea I had was to use a unique table name per connection for temp_1, but I would really rather use temporary tables.I am hoping some SQL guru's can […]

2003-07-22

115 reads

Blogs

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Permissions required for row counts to show up on Object Explorer Details

By

I ran into a rather obscure permissions problem the other day. Since I wasn’t...

Read the latest Blogs

Forums

First DW design - advice appreciated

By as1981

All, Up to this point I've only worked with relational databases. I'm trying to...

Backup Strategy For distributed availability groups

By juniorDBA13

What is the recommendations for backups in distributed availability groups? I have AG setup...

What happens when I drop a huge table with LOBs? will the space be reused?

By NJ-DBA

Thanks in advance for your help. I have a 5TB database with mutliple filegroups. ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers