meta user
network profile
| bio | website | |
|---|---|---|
| location | Denver, CO | |
| age | 37 | |
| visits | member for | 2 years, 1 month |
| seen | May 21 at 1:57 | |
| 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.
|
Mar 26 |
comment |
Booking system structure Does it meet the needs of the business logic? Simple is good if it covers the purpose of it's creation. In the booking record I assume that client and room are FK to clientid and roomid? My only suggestion... I usually recommend naming the same for clarity sake. |
|
Mar 21 |
comment |
Upgrade SQL Server 2012 Express to Evaluation Edition Yeah, sharepoint install makes it a little more fragile for sure. |
|
Mar 21 |
comment |
Upgrade SQL Server 2012 Express to Evaluation Edition How many databases on your express install? How much work to backup, install fresh, and restore? |
|
Mar 14 |
comment |
Can't choose which date sql server 2005 backup to read in sql server 2008. Is one a full backup and the others log backups? Don't rely on the file extensions because SQL doesn't actually care about that. |
|
Mar 8 |
comment |
Delete a variable number of records by a chronological order Also, I was trying to get around deprecation with the sub select but it's a nil issue now. Thanks again. |
|
Mar 8 |
comment |
Delete a variable number of records by a chronological order Apparantly I didn't get the memo about using parenthesis. Thank you SQL2005. Awesome. |
|
Mar 7 |
comment |
Change Data Capture and the __$update_mask binary Check out my NEW answer before you do. As cool as the CLR is... we found an even better way. Good luck. |
|
Mar 6 |
comment |
TSQL DateTime DataType - fractional seconds vs milliseconds Its turning out to be a "taking their word for it" problem on my end with the vendor proc. They are using the LSN time mapping functions related to change data capture which DO allow < instead of =< calls. So, we'll be fixing code. msdn.microsoft.com/en-us/library/bb500137.aspx |
|
Mar 6 |
comment |
TSQL DateTime DataType - fractional seconds vs milliseconds If the range was in our own code that would be what we would do but we are passing to other procs that only take datetime for range and are inclusive on both ends |
|
Feb 11 |
comment |
Quick way to validate two tables against each other Nice, thanks... good way to find differences after aggregate indicates differences exist. Thanks. |
|
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 |
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 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. |
|
Jan 29 |
comment |
Parameter Sniffing vs VARIABLES vs Recompile vs OPTIMIZE FOR UNKNOWN Wish I could mark two answers as correct, but again, thanks for the additional info - very instructive. |
