meta user
network profile
| bio | website | |
|---|---|---|
| location | Denver, CO | |
| age | 37 | |
| visits | member for | 2 years |
| seen | 15 hours ago | |
| stats | profile views | 179 |
Developing, modeling, administering, tuning, troubleshooting, extracting, transforming, and loading databases full time since 1996.
First professional assignment with databases began building CAClipper xBase applications back when a database with 2 million plus records was considered huge. Moved to FoxPro and Borland Visual Delphi in the mid 90's and then SQL Server in '98.
Have also worked with Sybase, MySQL, Oracle, Access, Multivalue Informix, Filemaker, 4D and the Microsoft BI stack.
|
Feb 8 |
comment |
Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN In summary... yes, I was misunderstanding the relationship between "parameter sniffing" and the plan cache. Knowing this better now brings it all together. Thanks guys. |
|
Feb 8 |
comment |
Quick way to validate two tables against each other Gave you a plus 1, but the aggregate provided by bacon bits was the icing on top. Thanks. |
|
Feb 8 |
comment |
Quick way to validate two tables against each other We can do a quick check against information_schema to make sure the schemas match. This does exactly what I was imagining... thanks. |
|
Feb 8 |
accepted | Quick way to validate two tables against each other |
|
Feb 8 |
comment |
Quick way to validate two tables against each other It is an option, it's what is being used for the ETL process, but the mustaches upstairs want a second opinion on if it worked or not so using SSIS to prove that SSIS got it right is not as convincing as dropping fancy words like CheckSum or MD5 Hash. |
|
Feb 8 |
comment |
Quick way to validate two tables against each other This has potential. I'll do some testing and get back. |
|
Feb 8 |
comment |
Quick way to validate two tables against each other The union all across a linked server approach had me worried. I like the aggregate and binary_checksum approach... going to start some testing with that now. |
|
Feb 7 |
asked | Quick way to validate two tables against each other |
|
Feb 6 |
comment |
How do you avoid a deadlock on the primary key of a table? Give this a read. sqlserverpedia.com/blog/sql-server-bloggers/… |
|
Feb 4 |
comment |
Change data capture - how to know who made the change? Good to know, I thought closed meant closed to voting as well. I pointed out in my comment that Oracle offers this in their CDC implementation. It sorta seems logical. docs.oracle.com/cd/A91202_01/901_doc/server.901/a90237/… |
|
Feb 4 |
comment |
Change data capture - how to know who made the change? If it were'nt closed, I'd have voted for it. Back to those $%#@## triggers I guess. |
|
Feb 4 |
accepted | Change data capture - how to know who made the change? |
|
Feb 4 |
accepted | Capturing datetime of change in SQL Server CDC |
|
Feb 4 |
asked | Change data capture - how to know who made the change? |
|
Feb 1 |
revised |
change-data-capture wiki excerpt added 320 characters in body |
|
Feb 1 |
awarded | Tag Editor |
|
Feb 1 |
revised |
system-tables wiki excerpt added 319 characters in body |
|
Feb 1 |
revised |
Capturing datetime of change in SQL Server CDC added 82 characters in body |
|
Feb 1 |
wiki | created change-data-capture excerpt |
|
Feb 1 |
suggested | suggested edit on change-data-capture tag wiki excerpt |
