Viewing 15 posts - 211 through 225 (of 851 total)
[font="Verdana"]I haven't been able to test my code, since you didn't supply any table definitions or example data. However, here's the approach. Hopefully you can get an idea...
June 4, 2009 at 8:20 pm
[font="Verdana"]I'd go for passing in the list as XML, even for the small list. The reason is that it's not difficult to get an object in .NET to write...
June 4, 2009 at 7:41 pm
[font="Verdana"]John's quite correct. Data warehouses are designed quite differently to an OLTP database.
If all you need to do is consolidate two databases (in the same structure) into one so...
June 2, 2009 at 12:04 am
Paul White (5/21/2009)
Would be fascinating to know who 'flamed' Gail.
[font="Verdana"]Can't get rid of mental image of a posse of baseball-bat wielding DBA's wanting to chat about kneecap concurrency...[/font]
May 21, 2009 at 8:17 pm
[font="Verdana"]Several things here.
You are not designing or writing for SQL Server, you are writing and designing for humans. Keep that in mind.
What do I mean? Well, for SQL...
May 21, 2009 at 5:41 pm
Paul White (5/21/2009)
Bruce,Darn it. I was looking forward to an energetic debate there but it seems we all agree - oh well 😀
[font="Verdana"]Just because we agree doesn't mean we...
May 21, 2009 at 5:12 pm
Paul White (5/21/2009)
Hey Bruce,I'm not usually one to disagree 😉 but:
Read uncommitted is just as valid as any other isolation level.
[font="Verdana"]Hey Paul,
I'm not really entirely sure you are disagreeing...
May 21, 2009 at 4:58 pm
[font="Verdana"]The pervasive use of NOLOCK as a "performance tool" is, I believe, a hang-over from the SQL 6.5 and prior days, when SQL Server was still page locking within tables....
May 21, 2009 at 2:27 pm
GilaMonster (5/21/2009)
Oh yay. 🙁Another email accusing me of personal attacks and damaging someone's public image by 'misleading' people about his statements.
Sometimes I wonder why I bother.....
[font="Verdana"]You bother because those who...
May 21, 2009 at 2:21 pm
john.arnott (5/20/2009)
Would not an OUTER join solution work too?
[font="Verdana"]I would use an outer join as well, but perhaps one slight variation (probably just in how I think, I doubt it...
May 20, 2009 at 9:46 pm
[font="Verdana"]Partitioning is certainly one strategy. Have you considered archiving off the "useless records" into another table?
Also, if the changes to the table are infrequent, have you considered building covering...
May 20, 2009 at 9:38 pm
[font="Verdana"]Are we talking a SQL Server T-SQL formula, or a SQL Server Analysis Services MDX formula, or a SQL Server Reporting Services inline formula or a VB.Net formula or an...
May 20, 2009 at 9:34 pm
Jeff Moden (5/20/2009)
Take Lynn's original advise... The third operand of ROUND will allow you to truncate instead of round. Heh... look it up in Books Online. 😉
[font="Verdana"]ROUND() has a...
May 20, 2009 at 4:04 pm
[font="Verdana"]The trick with teenagers is... you can't lock them in the shed, but you can lock yourself in the shed. :-D[/font]
May 20, 2009 at 3:07 pm
Viewing 15 posts - 211 through 225 (of 851 total)