2006-12-07
1,705 reads
2006-12-07
1,705 reads
2006-11-30
1,130 reads
These queries are used to compare the data in two tables. In these examples all the rows in each table is retrieved and compared using the UNION ALL command. I would recommend adding additional WHERE criteria for very large tables to reduce the number of rows that will be compared.These SQL statements are based on […]
2007-08-09 (first published: 2006-11-29)
2,786 reads
The script can be used to find all the tables that have the particular column name in it.
2007-07-25 (first published: 2006-11-06)
123 reads
I wrote this to calculate the median on a record set. All you need to pass is the table name and column name. If you would like to filter the record set, create a view that displays the correct record.The limitation of not being able to pass arrays to Stored procedure or functions was the […]
2007-02-23 (first published: 2006-10-30)
647 reads
In this video, Kathi continues her T-SQL series and exands how to use the WHERE clause.
2006-10-26
3,469 reads
2006-10-24
2,332 reads
In this second part video from Kathi, she covers how to write T-SQL in much more indepth. She covers how to handle NULLs and many more items in this video.
2006-10-12
2,787 reads
There are so many new features in SQL Server 2005 that there's one that can make a significant impact in solving many different types of problems. Andy Warren takes a look at one of the features that has been enhanced and is extremely useful, albeit quirky: TOP.
2006-10-05
19,012 reads
In this video, you'll learn how to write basic select statements. This beginner video takes you from the ground up writing T-SQL.
2006-10-04
3,402 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Have anyone implemented CDC, and if so, what has been your experience with it?...
I'm getting a error when using the Import and Export wizard to copy tables...
I have joined a new project, where the business uses Azure SQL Hyperscale for...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers