In most places, we use some kind of field naming convention. Many times we have one or more fields with similar name in all tables for some kind of tracking. You can use this query to find similar names in all tables.
2002-04-29
230 reads
There are times you want to kill all the connections in a database. This would do that trick. This can be very useful when you replace a database regularly and some connections still exist so your automated restore fails. You can issue this command to kill all the connections before issuing a restore command.
2002-04-17
2,475 reads
During some maintenance task, you might not want any one to connect to a database. This script would help you do that. If you need to run this script, you might also need my other script to kill connections.
2002-04-17
770 reads
2002-04-01
767 reads
This script would help find primary key, foriegn key, unique constraints, check constraints on a table. With slight modification you can use it to find various information about a table.
2002-04-01
592 reads
2002-04-01
682 reads
This script would help you find users, their logins, roles etc in a database.
2002-04-01
339 reads
By Brian Kelley
It tells us to take the time to master the foundational basics of whatever...
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Hi everyone I have two tables storing stock prices. Each table comes from a...
hi i need "sample size" in my report's 4th data region which is a...
Hello experts, I want to be more organized about the SSL certificates we have...
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers