Six top SQL Server 2012 management tools you should know about
Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities,...
2013-03-26
1,454 reads
Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator’s capabilities,...
2013-03-26
1,454 reads
From time to time, I see the following question posted on various SQL Server forums by different users asking why...
2013-03-26
1,531 reads
Checkout the fifth part of my XML support and SQL Server article series here.
In this article, I discussed the basic...
2013-03-26
618 reads
Today, I’ve received an email from friend asking that that is there any way to find out the progress of...
2013-03-19
1,261 reads
This dynamic management function (DMF) returns the detailed information about low level activities on indexes such as input/output (I/O) operations,...
2013-03-19
2,169 reads
Today, we experienced performance issues with few databases that are hosted on one of our most critical production SQL Server....
2013-03-13
1,864 reads
Today, I received a call from friend asking how he can find out which database object belongs to which filegroup.
Well...
2013-03-03
1,421 reads
This is the third part of the three part article series on partitioning relational data.
In the first part of this...
2013-02-23
568 reads
Today, I am very happy because my first article (SQL Server Encryption) was published in SQL Server Pro. In this...
2013-02-23
1,078 reads
Virtualization is a hot trend in the computing world, offering businesses substantial cost and performance benefits that include server consolidation,...
2013-02-23
1,598 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