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,269 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,269 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,474 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,229 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,852 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,808 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,832 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,567 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,908 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,009 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,280 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers