You can use the sys.partition_functions system catalog view to return a list of partition functions in SQL Server.
mssql
Return a List of Partition Schemes in SQL Server (T-SQL)
You can use the sys.partition_schemes system catalog view to return a list of partition schemes in SQL Server.
How to Fix “ALTER TABLE SWITCH statement failed” Msg 4982 (SQL Server)
If you get error message 4982 in SQL Server, it’s because your source table doesn’t have a constraint that restricts data to only the range supported by the partition that you’re trying to switch to.
How to Import a JSON File into a SQL Server Table
If you have a JSON document, there are several ways you could go about getting it into SQL Server.
If it’s a small document, you could copy and paste its contents. If it’s a larger document (or even a small one), you might want to import the whole file.
This article presents an example of importing a JSON file into a SQL Server database.
How to Insert JSON into a Table in SQL Server
If you have a JSON document that you need to insert into a table in a SQL Server database, the OPENJSON() function could be just what you need.
OPENJSON() is a table-valued function that returns JSON in tabular format. That is, it converts your JSON into a tabular result set consisting of rows and columns. Therefore, it enables you to insert it into a table.
What is STATISTICS TIME in SQL Server?
In SQL Server, you can use the SET STATISTICS TIME statement to display the time it takes to execute a T-SQL statement.
More specifically, it returns the number of milliseconds required to parse, compile, and execute each statement.
When SET STATISTICS TIME is ON, the time statistics for a statement are displayed. When OFF, the time statistics are not displayed.
The setting of SET STATISTICS TIME is set at execute or run time and not at parse time.
SQL Server Error 113: Missing end comment mark ‘*/’
SQL Server error message 113 occurs when you omit a closing comment mark.
This can occur when you open a comment but forget to close it. It can also occur when you accidentally type an opening comment.
There may also be odd occasions where you get this error due to other factors, such as the way your SQL utility handles certain keywords etc.
Find Out if a Table is Partitioned in SQL Server (T-SQL)
If you need to find out if a table has been partitioned in SQL Server, you can run a join against the sys.tables, sys.indexes, and sys.partition_schemes views.
How to Fix: JSON_VALUE Returns NULL with Long Strings (SQL Server)
If you’re using JSON_VALUE() to return values consisting of a long string, you might find that it returns NULL instead of the actual value.
Or, you might be getting an error.
What is STATISTICS PROFILE in SQL Server?
In SQL Server, you can use the SET STATISTICS PROFILE statement to display the profile information for a T-SQL statement.
STATISTICS PROFILE works for ad hoc queries, views, and stored procedures.
When STATISTICS PROFILE is set to ON, each executed query returns its regular result set, followed by an additional result set that shows a profile of the query execution.