Microsoft introduced native support for JSON in SQL Server in version 2016. In this article, Phil Factor shows how to import JSON documents into to SQL Server database tables, even if there is a bit of complexity in the original data.
2018-06-04
3,180 reads
Learn how the clustered index keys affect the non clustered index structure.
2018-06-01 (first published: 2016-04-11)
18,865 reads
SSMS is a good management tool, but it’s not a good development tool. When you’re writing some simple queries, it’s fine. When you’re writing code with lots of branching, dynamic SQL, temp tables, error handling, and so on… Not so much. Here are some tips Erik darling has put together after a couple years of wrangling the Blitz scripts in the First Responder Kit.
2018-06-01
4,954 reads
One small point to note when we receive the below error while connecting SQL server: The target principal name is incorrect. Cannot generate sspi context
2018-05-31
29,895 reads
In this tip we cover the basics of what needs to be done to setup a process to automate refreshing a dev or test environment with a recent database backup.
2018-05-31
4,463 reads
Creating a real-time IT dashboard is essential for IT professionals for managing their environments and to be proactive. A Few months ago, a great tool called ‘PowerShell Universal Dashboard’ or ‘PoshUD’ was officially released. In this article, Nicolas Prigent describes PoshUD, and how to use it to monitor your infrastructure using PowerShell.
2018-05-30
4,458 reads
2018-05-29
9,001 reads
When databases are being designed and developed, your developers might have overlooked creating clustered indexes on some of your database tables. Having a useful clustered index on your tables will improve the performance of your queries. Here Greg Larsen shows a simple script to identify those tables in your database that don’t have a clustered index.
2018-05-29
4,777 reads
R Services provides in-database analytics in SQL Server 2016. In this article we step through configuring R Services and get you started with in-database analytics.
2018-05-28 (first published: 2016-01-27)
4,895 reads
In this article, Robert Cain describes the steps to set up a VM using PowerShell using his PSAzure module.
2018-05-28
3,337 reads
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Comments posted to this topic are about the item Automating Database Cleanup for PostgreSQL...
Comments posted to this topic are about the item The Query Optimizer and Page...
Comments posted to this topic are about the item There Are a Lot of...
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers