EXEC sp_executeSQL
Today I am going to talk about the stored proc sp_executesql and the benefits it has over EXEC @SQL. Microsoft actually recommend that you use the sp_executesql stored procedure...
2014-10-27
10 reads
Blog Posts
Last Weeks Top “Reading” Links #106
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-10-27
451 reads
Minion Reindex is here
We released Minion Reindex by MidnightDBA unto the world, accompanied by a press release on SQLServerCentral.com, and people have responded so incredibly positively. We’re quite...
2014-10-27
710 reads
Reducing the size of the distribution database & improving transactional replication performance: Part 3
Part 1 of this series of articles looked at the intricacies of SQL Server transactional replication, and made the observation that the...
2014-10-27 (first published: 2014-10-20)
6,821 reads
Remove Witness from SQL Server Database Mirroring
1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option. 2) To remove the witness, delete its server...
2014-10-27
23 reads
Oh! I forgot When I took last Database Backup ? How to determine this? TIP # 66
In last few tips TIP #64 & TIP #65 we get information how to take backup & How to ensure it can...
2014-10-25
291 reads
Be Careful! Backups Can Bite You!
Here is a riddle for you…
You are requested to move a database from an old server to a new server....
2014-10-24 (first published: 2014-10-20)
7,596 reads
Find all triggers in a SQL Server Database
Reading Time: 2 minutes
What Are Database Triggers?
Do you know what triggers lurk in your database?
Triggers can be implemented to enforce...
2014-10-24
515 reads
Overview of Published Articles – 2014Q3
Here is an overview of the articles I published in the third quarter of 2014.
INTENSE SCHOOL
MCSE Prep (SQL) – Using Parameters...
2014-10-24
785 reads
Reblog: October 17 to October 23
Photo credit – Jenn and Tony Bot
Sometimes old stuff is just as cool as new stuff. Over the past few years,...
2014-10-24
793 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Alamat Kantor BCA KCU BOGOR Tlp:08217555651
WA CS 628217555651 Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota...
Alamat Kantor BCA KCU Sukabumi Tlp:08217555651
WA CS 628217555651 Jl. A. Yani No.33-35, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat...
Alamat Kantor BCA KCU Karawang Tlp:08217555651
WA CS 628217555651 Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Purwadana, Telukjambe Timur, Karawang,...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers