CHECKSUM vs HashBytes
Hashing can be useful in Data Warehousing as well It can give you the ability to break large problems into...
2012-02-01
28,806 reads
Hashing can be useful in Data Warehousing as well It can give you the ability to break large problems into...
2012-02-01
28,806 reads
One of the most exciting features in SQL Server 2012 is the introduction of the Tabular Model. The Tabular model...
2012-01-31
3,489 reads
As I mentioned in a pervious post Master Data Services for SQL 2012 is a huge improvement over the SQL...
2012-01-19
3,594 reads
In my years as a BI Professional I have seen many ETL Frameworks. They range from homegrown internal solution to...
2012-01-04
9,558 reads
Microsoft is working on the next round of certification exams for SQL Server 2012. So now is the best time...
2011-12-28
1,618 reads
I was recently asked to provide some performance tuning recommendations for an ETL process that extracts data from Oracle using...
2011-12-21
7,712 reads
Data mining techniques can be used in virtually all business applications, answering various types of businesses questions. In truth, given...
2011-12-14
2,345 reads
I recently gave a couple of presentations about the new Business Intelligence features in SQL Server 2008 R2. Here are...
2011-11-11
1,511 reads
Unary Operator and Aggregating over time
In my last post I discussed how to arrange all of the GLs into a...
2011-11-03
3,244 reads
Part 1 – Parent Child Hierarchies and Pseudo GL Accounts
This post is born out of some real life lessons that I...
2011-10-26
5,416 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