Scalar Functions with Query Plans: Not all is obvious!
Scalar functions in Query Plans just don't always show the whole story!
2018-06-04
919 reads
Articles
Importing JSON Collections into SQL Server
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
NonClustered Index Structure
Learn how the clustered index keys affect the non clustered index structure.
2018-06-01 (first published: 2016-04-11)
18,971 reads
Quick Tips For Debugging Large Stored Procedures
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
Solving the Target Principal Name is Incorrect
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
30,681 reads
Automating a SQL Server Database Refresh
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
PowerShell Day-to-Day Admin Tasks – Part 6: Real-Time IT Dashboard
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,112 reads
Tables Without Clustered Indexes
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
Configuring R Services in SQL Server 2016
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,901 reads
Blogs
Voice of the DBA | Writings from Steve Jones, the Voice of the DBA
By Steve Jones
Houston AI-Lytics 2026–Powerpoint Slides Thanks to everyone for attending my session on running a...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers