Viewing 15 posts - 16 through 30 (of 72 total)
XML and HTML have standard formatting conventions, and when I use tools to write this type of code the tools have a menu option to apply the standards and fix...
March 5, 2008 at 6:48 am
SSW has recommendations posted at http://www.ssw.com.au/ssw/Standards/DeveloperSQLServer/SQLServerStandard_3_StoredProcedureFormatting.aspx . They also have lots of guidelines on other topics associated with programming
March 5, 2008 at 6:45 am
Andrew Novick's Transact SQL User Defined Function's book has an excellent discussion on Documenation, Formmatting and Naming Conventions in Chapter 6. In this, some of his reasons for the comma,...
March 4, 2008 at 8:16 am
Steve, the new feeds seem to be working
February 10, 2008 at 6:51 pm
thanks, i figured it was something simple.
It was formatted in SSMS, what do I need to do to keep the formatting when I post it here?
January 29, 2008 at 2:10 pm
Steve, I notice that when I go to http://www.sqlservercentral.com/Xml/Rss/Articles/Editorial%20-%20MP3/ I just see a list of titles but no actual files are shown. When I go to other...
January 28, 2008 at 3:12 pm
I'm just looking at the clock in the bottom right corner of the Management Studio window. I highlighted the select statement in my sproc and then clicked Execute
January 28, 2008 at 9:40 am
Thanks, but the number of rows was cut in half and there was no reduction in execution time. so I'm still confused:unsure:
January 28, 2008 at 7:57 am
Steve, when I subscribe to just the mp3 format in my Zune, I get an error message that "The RSS appears to be valid but there is no content" and...
January 28, 2008 at 3:48 am
Steve, I'm still getting 4 files for every show via the Zune marketplace. Have you had a chance to look into this yet?
January 14, 2008 at 1:14 pm
you can start with the DB Tuning Wizard that comes with SQL Server.
October 11, 2007 at 5:55 am
August 23, 2007 at 10:59 am
Thanks, is this limitation documented somewhere? I did not see anything telling me that i could not do it the way I was trying to.
August 23, 2007 at 7:50 am
Check out the dynamic sql articles at http://www.sommarskog.se. he provide a good example of how to do this.
August 21, 2007 at 12:32 pm
Thanks why do recommend staying away from this dynamic sql?
I have mutiple identical dbs (for various companies in my corporation). I need to run the same query against several of...
August 14, 2007 at 8:47 am