Using OVER() to Fix Bad Version Numbers
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
2016-10-17
2,364 reads
Mike McQuillan
Stairway to U-SQL Level 10: Table-Valued Functions and UDTs
Table-Valued Functions and User-Defined Types can help you write parameterised U-SQL views in an elegant manner. They also aid code reuse.
2016-10-12
2,842 reads
Stairway to U-SQL Level 8: Joining Tables in U-SQL
U-SQL provides a number of ways to join data sources together. This articles introduces the joins available and how you can use them.
2016-09-14
3,539 reads
Stairway to U-SQL Level 7: More Partition Schemes
Following on from our previous introduction to indexes and partition schemes, we review the distribution schemes used by horizontal partitioning.
2016-08-24
1,703 reads
Stairway to U-SQL Level 6: U-SQL Indexes and Partition Schemes
Find out how to speed up your queries by indexing and partitioning data, U-SQL style.
2016-08-10
3,270 reads
Stairway to U-SQL Level 5: Databases and Tables in Azure Data Lakes with U-SQL
A guide to using databases, schemas and tables in Azure Data Lakes, using (of course!) U-SQL.
2016-07-27
3,168 reads
Stairway to U-SQL Level 4: U-SQL and Data Lake Tooling with Visual Studio
A guide to using Visual Studio to create U-SQL projects and scripts.
2016-07-20
3,030 reads
Guide to MCITP: SQL Server 2008 BI Developer
A guide to the SQL Server 2008 Business Intelligence exams.
2012-05-11
12,375 reads
2011-10-04
2,475 reads
Guide To MCITP: SQL Server 2008 Administration
Find out what you need to learn for the SQL Server 2008 Administration certification exams.
2011-08-05
8,981 reads
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers