Hi Guys, When you generate a script to create a Stored Procedure, below three statements are generate by default. SET ANSI_NULLS on SET NOCOUNT on SET QUOTED_IDENTIFIER on Why do we...
2015-12-17
33 reads
Hi Guys,
When you generate a script to create a Stored Procedure, below three statements are generate by default.
SET ANSI_NULLS on
SET NOCOUNT on
SET...
2015-12-30 (first published: 2015-12-17)
10,277 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers.
I...
2016-01-01 (first published: 2015-12-16)
4,098 reads
The SQL Agent is our friend! Setting up SQL Server Agent to automate jobs and alerts is a great idea....
2015-12-16
715 reads
I ran across a bug in SSMS 2016 CTP 2 back in August. If you try to right click and...
2015-12-16
445 reads
A few weeks ago I was reading a blog post by Andrea Allred (b/t) and was just amazed by what...
2015-12-16
596 reads
What do I care about when I’m playing with indexes? That’s easy. I want as few indexes as possible efficiently referenced...
2015-12-28 (first published: 2015-12-16)
3,545 reads
A few days ago, while delivering my session, The Data-Loading Performance Presentation, I was asked when, performance-wise, Identity should be...
2015-12-28 (first published: 2015-12-16)
3,828 reads
Recently I worked on a neat little POC with Patrick Leblanc for a customer in Education who wished to perform sentiment...
2015-12-24 (first published: 2015-12-16)
2,375 reads
A script to have handy to tell you which schannel protocols are enabled / disabled for PCI or certificate compliance. This one works well for local servers. If you...
2015-12-15
25 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
I've got a web application for my side business. I've added a SQL Server...
Comments posted to this topic are about the item Looking for New Blood
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers