Gather Always On Configuration using a DMV query
If you were like me, you would know your AG configuration by heart. However, what if you get busy with...
2018-04-26
353 reads
If you were like me, you would know your AG configuration by heart. However, what if you get busy with...
2018-04-26
353 reads
-- Health and status of WSFC cluster. These two queries work only if the WSFC has quorumSELECT*FROMsys.dm_hadr_clusterSELECT*FROMsys.dm_hadr_cluster_members
-- Health of the AGsSELECT...
2018-04-26
14,781 reads
SELECT * FROM sys.master_files AS f
CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) v;
2018-04-23
318 reads
WMI has been around for a while and it has grown significantly over the years. With Microsoft's focus on powershell,...
2018-04-20
11,189 reads
USE master
exec sp_MSforeachdb '
use [?]
print ''?''
print cast(databasepropertyex(''?'', ''Updateability'') as varchar(200))
if databasepropertyex(''?'', ''Updateability'') = ''READ_WRITE ''
dbcc shrinkfile(2,1)
'
2018-04-20
301 reads
What SQL command do you use to pull and filter data from a table ?
SELECT [Column List] FROM [Table Name]...
2018-04-20
411 reads
2018-04-20
For one of my clients, I needed to know and document not only database names, size and locations but also...
2018-04-19
547 reads
When you restore a database, it will also restore all permissions along with it. But what if you are restoring...
2018-04-19
10,215 reads
I was working for a client on their very critical and heavily used database. The application was an E-commerce website...
2018-04-19
2,520 reads
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers