TSQL

SQLServerCentral Article

The difference between BIN2 and Case-Sensitive collations in SQL

  • Article

Here you will learn about the key differences between the binary and SQL/Windows collations. You will see that even with all sensitivity flags enabled, SQL/Windows collation cannot behave the same way as the binary collations.

5 (2)

You rated this post out of 5. Change rating

2024-03-15

1,259 reads

SQLServerCentral Article

SQL Window Functions Series: LAG() and LEAD()

  • Article

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.

5 (3)

You rated this post out of 5. Change rating

2023-12-11

5,173 reads

Technical Article

How to Move a Table into a Schema in T-SQL

  • Script

To move a table into a schema in T-SQL, you can use the ALTER SCHEMA statement along with the TRANSFER option. Here are the steps to do this: Assuming you have an existing schema named "NewSchema" and a table named "YourTable" that you want to move into this schema: Open SQL Server Management Studio or […]

You rated this post out of 5. Change rating

2023-09-29 (first published: )

1,725 reads

External Article

One use case for NOT using schema prefixes

  • Article

I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server.

In spite of what may be a controversial title to many of my regular blog readers, I don’t really want you to stop that practice in most of your T-SQL code, because the schema prefix is important and useful most of the time. At Stack Overflow, though, there is a very specific pattern we use where not specifying the schema is beneficial.

2023-09-13

Blogs

Calling a REST Endpoint from Azure SQL DB

By

External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas...

Monday Monitor Tips – Adding Redgate Monitor Custom Metrics from SQLMonitorMetrics

By

This post talks about adding custom metrics from the sqlmonitormetrics.com site automatically and how...

Microsoft 365 Security and Compliance for Administrators, a Book Review

By

I was asked to review the following book by the publisher, and I must...

Read the latest Blogs

Forums

how can vs see SSIS under my regular user id but not my admin?

By stan

Hi, we run vs 2022.   I'm stumped how when i run VS as admin...

error in both ssis and ssms - something about losing connections - new error

By stan

hi for about 4 or 5 days now, i've been seeing various connections (to...

The Biggest Database Professional Challenges Today

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Biggest Database Professional Challenges...

Visit the forum

Question of the Day

The Last DBCC Date

How can I easily get the last DBCC CheckDB date from T-SQL in SQL Server 2022?

See possible answers