4,954 reputation
11239
bio website billfellows.blogspot.com
location Kansas City, MO
age 39
visits member for 3 years, 2 months
seen 13 hours ago

Developer, devourer of pie, disciple of databases, dictator of datum, drinker of tea, delirious with alliterative devices

@billinkc


1d
comment Best approach for populating date dimension table
I however approve of using yyyymmdd as your surrogate key for the date dimension. That column isn't exposed to users so no worries about them querying for years of 91256712.
1d
comment Best approach for populating date dimension table
DateId is an identity? As a general rule, I'm opposed to smart keys but date dimension is the one place where I not only find it forgivable, I prefer it. What value is there in creating a column called DateTime? It's never going to have more than one time per day. What about Holiday name. Is this supposed to just be Federal holidays? What if there's overlapping holidays? Finally, why do you care about a "best approach" for populating a date dimension. It could take 5 minutes to populate and then it's done for the rest of the data warehouse's life. It basically the one thing that never changes.
Aug
22
comment How to enforce the structural constraints of rectangularly arrayed data?
Is this purely to validate plates are of a particular configuration? Would you process a 2x3 well differently than a 4x6? Based on your sample well data points, could one think of a well as some multiples of 2x3?
Aug
22
answered Replicating a View to a Table. Issues with schema binding, view indexing
Aug
22
comment Replicating a View to a Table. Issues with schema binding, view indexing
Are you pushing the data from Dev to Prod on a periodic basis or are you periodically copying the data from the tables that comprise the Customers view into the physical table Customers?
Aug
22
comment What's new in SQL Server 2014 T-SQL since SQL Server 2008 R2?
Specifically, under "What's New (Database Engine)", look at the "Transact-SQL Enhancements" link which I can summarize for you as "not a damn thing". 2008 to 2012 however, they packed lots of delicious candy in there
Aug
21
comment Error when trying to deploy SSIS package
What does the ssisdb.catalog.operation_messages have to say about the deployment operation? What if you try a different deployment mechanism, do you get any more detailed error messages? This is a tsql deployment
Aug
21
answered Convert yymmdd to datetime using ssis derived column
Aug
20
comment Convert yymmdd to datetime using ssis derived column
What is the appropriate action to take when the data is insufficient? In your sample, 101 and 0 won't convert to a valid date as the string is too short but there could also be bad values recorded - 30 days in February, etc
Aug
20
revised Stored Procedure null parameter within where clause
Chicken little apparently on sql injection
Aug
20
answered Stored Procedure null parameter within where clause
Aug
19
comment What is better? Delete and insert or update?
Push your updates to a table using your fast insert mechanism and then do a set based update
Aug
19
comment What is better? Delete and insert or update?
@Colin'tHart Obviously the SQL Server instance resides on Windows but they could be using executing python on Linux or Mac. Knowing whether I have to constrain my answers to Windows only solutions is helpful
Aug
19
comment What is better? Delete and insert or update?
What OS are you performing this on?
Aug
18
comment SQL Server 2008 R2 to 2012
In the same vein as Aaron, do you know it's the ETL that is running slower? When we migrated from 2008 to 2012, we had performance issues that weren't resolved until we reindexed our tables.
Aug
15
comment Can't use Fuzzy Lookup in BIDS
Any chance you can provide a minimal repro? What the source & how the fuzzy lookup is configured?
Aug
12
comment Script not emailing from Maintenance Plan/SSIS
SELECT TOP 30 * FROM msdb.dbo.sysmail_mailitems AS SM ORDER BY SM.mailitem_id desc; This will pull back the last 30 emails the system tried to send. Do you see your missing emails there? What is the sent_status?
Aug
8
comment Is it Possible to Recover Data from a BLACKHOLE table?
@Vérace Yes, but the little corporal also said "I think I'll invade Russia"
Aug
8
comment How to deal with very large transaction logs in SQL Server
This would be closed as duplicate if it's migrated to DBA.
Aug
8
comment Is it Possible to Recover Data from a BLACKHOLE table?
This question appears to be off-topic because it is about the impossible. As user and the documentation states "The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. Retrievals always return an empty result"