Templates and teamwork
SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.
2014-11-27 (first published: 2008-05-20)
10,183 reads
SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.
2014-11-27 (first published: 2008-05-20)
10,183 reads
RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions
2014-09-05 (first published: 2012-05-08)
20,451 reads
Documenting the database is always a challenge, and there are many techniques you can use to help all the people on your team understand what all your tables are used for. David Poole brings us an easy way to implement a framework for documentation.
2014-04-25 (first published: 2011-02-17)
14,522 reads
If your companies first foray into Big Data project starts with a big cheque then you are doing it wrong!
2014-04-14
360 reads
When should you use a SQL CLR Aggregate? Lots of people have struggled with this one, but David Poole found a use, and has some interesting performance data analysis as well.
2014-02-05 (first published: 2010-12-29)
17,192 reads
2013-09-12
5,862 reads
EAV models have their uses but the costs are often hidden and if not hidden, more than anticipated.
2013-01-21
8,166 reads
Unifying the reference data across an enterprise can be a bigger job than expected. This article describes one approach to doing so.
2012-12-20
3,586 reads
Even if you are not an infrastructure guy a good grasp of storage basics will stand you in good stead
2012-07-16
5,407 reads
Switching from 32 BIT SQL Server to a 64 BIT edition illustrates how removing a bottleneck from a system can have a detrimental affect overall
2012-01-31
16,947 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