How to list all CLR objects inside your database?
I wrote the following query that returns the list of all CLR functions/procedures/objects exists inside your database:
SELECT o.object_id AS [Object_ID]
...
2012-08-12
1,280 reads
I wrote the following query that returns the list of all CLR functions/procedures/objects exists inside your database:
SELECT o.object_id AS [Object_ID]
...
2012-08-12
1,280 reads
Dedicated Administrator Connection (DAC) allows administrators emergency access to SQL Server via SQL Server Management Studio (SSMS) or via command...
2012-08-09
1,478 reads
Another potential problem that you need to tackle as a DBA is running out of disk space on the hard...
2012-08-06
3,237 reads
SQL Server 2012 introduces user-defined server roles. These user-defined server roles are similar to fixed server roles with only difference...
2012-08-02
2,859 reads
In my post here, I’ve discussed the procedure to perform attended installation of SQL Server 2012 on a Windows Server...
2012-08-02
9,832 reads
I received an phone call from a friend today asking how to move master and resource system databases in Microsoft...
2012-07-29
6,846 reads
SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests...
2012-07-27
1,573 reads
Checkout my article (i.e. Retrieving Deadlock Graphs with Event Notification) that is published on SSWUG.org. This article shows the steps...
2012-07-26
2,910 reads
Today, I’ve written the following T-SQL script which you can use to monitor the status of transactional replication and performance...
2012-07-25
7,013 reads
This article demonstrated the steps which you must follow to gracefully truncate the publisher database transaction log file by resetting replication.
2012-07-24
11,447 reads
By Steve Jones
redesis – n. a feeling of queasiness while offering someone advice, knowing they might...
By Steve Jones
The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...
The other day I came across an interesting repo on github, KubeDiagrams. What this...
Guys, I am facing problems when running a backup routine JOB in SQL Server,...
1, Customer table [TBLMEMBER] 's structure CREATE TABLE [dbo].[TBLMEMBER]( [TRANNO] [int] IDENTITY(1,1) NOT NULL,...
What is the result of this query in SQL Server 2022+?
select bit_count('7')See possible answers