Pragmatic Tools: DTSxChange (Or DTS Must Die!)
Ah DTS packages…they suck. Seriously, it’s 2011. It’s been over a decade and we still have SQL 2000 and DTS...
2011-06-07
847 reads
Ah DTS packages…they suck. Seriously, it’s 2011. It’s been over a decade and we still have SQL 2000 and DTS...
2011-06-07
847 reads
Many applications need sequentially incremental number as unique/primary key for records. SQL Server 2008 supports identity columns as the primary...
2011-06-07
527 reads
In the next couple of weeks we’ll do a series of blog posts with some of the T-SQL enhancements that...
2011-06-07
453 reads
I’m not working, though I have checked some email and kept an eye on a few things while I’m in...
2011-06-06
496 reads
Ordinarily, column order of a SQL statement does not matter.
Select a,b,c
from table
will produce the same execution plan as Select c,b,a
from...
2011-06-06
2,172 reads
A fantastic white paper just released: Microsoft EDW Architecture, Guidance and Deployment Best Practices.
It’s a must read if you are...
2011-06-06
1,092 reads
We have a table that contains just over 1.7 billion records and requires a
daily feeding of around 9 million. It is split into 10, roughly equal,
partitions. I...
2011-06-06
4 reads
We have a table that contains just over 1.7 billion records and requires a daily feeding of around 9 million. It is split into 10, roughly equal, partitions. I...
2011-06-06
1 reads
We have a table that contains just over 1.7 billion records and requires a daily feeding of around 9 million....
2011-06-06
507 reads
It’s Grillin’ Time OK, so we won’t be grilling inside the meeting – or even at the meeting. But it sure sounds good. There will likely be Pizza and...
2011-06-06
By Steve Jones
I wrote a post recently about pruning branches in git. That’s part of the...
By James Serra
I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the...
By Brian Kelley
he rollback plan... what to do when things go wrong to get back to...
Hi all, We have a SSIS package that does 2 things in parallel: moves...
We have pretty big tables very sensitive to stats with many updates. Our systems...
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers