Technical Article

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 […]

You rated this post out of 5. Change rating

2003-07-22

121 reads

Blogs

SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow

By

Want to build a data analytics foundation that transforms raw data into valuable business...

Using SQL Compare in Read-Only Databases

By

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

T-SQL Tuesday #179 Roundup: The Data Detective Toolkit

By

Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked,...

Read the latest Blogs

Forums

Date Type ETL Question

By Coffee_&_SQL

I'm not sure that I'm posting this in the right section, so please mods...

Possible oddity in msdb.dbo.backupset

By richardmgreen1

Hi all   I've written a script to keep track of how long backups...

Operand data type varchar is invalid for sum operator

By yrstruly

I have this view [dbo].[Asset Metrics - Client(Rama -Client-Test)], which makes use of multiple...

Visit the forum

Question of the Day

Data Migration Assistant Sources

In the current (Sep 2024) Data Migration Assistant, what are the possible sources for on-premises SQL Server instances?

See possible answers