Viewing 15 posts - 91 through 105 (of 313 total)
I like having practical, real-life examples and advice. Much appreciated. Thank you.
April 13, 2011 at 11:36 am
You raise a very good point and one of big personal concern. I recently put solar panels on my house, but I'm not free of the grid. Instead,...
April 11, 2011 at 9:37 am
The resource database doesn't need to be backed up. It it should every become corrupt, it can be easily replaced.
Makes sense. Thanks again! I'm good to go now.
April 1, 2011 at 10:50 am
Thanks for taking the time to reply!
I think you have already answered this next question, but in case you have more to say, I'll go ahead and ask it:
I came...
April 1, 2011 at 10:22 am
Our agency is just now upgrading from SQL Server 2005 to SQL Server 2008 R2. I took this change as an opportunity to finally read your book. And...
March 31, 2011 at 3:48 pm
It's ironic... your Step C) is all that needed to be done and it would be the same as this "SQL Spackle" article.
Oh ya. Thanks for pointing that out....
February 4, 2011 at 8:59 am
JJ B. If you're not currently using a loop or the method in the article, what are you using?
I'll tell ya, but you have to be kind (not that you...
February 3, 2011 at 9:27 am
Believe it or not, this kind of thing can have a production purpose. I have to send "narrative" from our database to a database in another agency. The...
January 31, 2011 at 11:14 am
I've been using something similar to your query for a while now, but I hadn't known about the option to convert to varchar(max) and get rid of the tokens. ...
January 12, 2011 at 9:34 am
CTEs. Output clause!!
And goodness, I can't believe no one has mentioned table-result User Defined Functions. What heaven.
When we get to SQL Server 2008, I know...
December 20, 2010 at 9:55 am
This was new to me and you did an excellent job of explaining how it works. I was with you every step of the way. 5 stars.
December 7, 2010 at 9:07 am
It can't be that much of a performance hit to check whether or not a parameter's value is null ...
I can testify to the potential hit on checking for...
November 15, 2010 at 9:48 am
This was a guy who created primary keys everywhere called "NoUseWhatsoever", "asds", "fgfgfg". For the latter two look at your keyboard.
Yikes! I definitely feel your pain there.
October 25, 2010 at 12:25 pm
Hugo wrote:
And consider what so many people call a junction table - a table that represents the many-to-many relationship between two tables. I will usually model these as just the...
October 25, 2010 at 10:11 am
Viewing 15 posts - 91 through 105 (of 313 total)