Viewing 15 posts - 1 through 15 (of 422 total)
techmarimuthu (9/19/2013)How to do database migration in Sql server?i need basic and step by step instruction.....Please help meThanks in advance
i need basic and step by step instruction.....
Please help me
Thanks in advance
The easiest method is to use Generate Scripts under the database...
September 20, 2013 at 1:15 pm
Brandie Tarvin (9/19/2013)
It's done this to me twice this morning. I do have Statistics_IO and...
September 20, 2013 at 12:55 pm
Sean Lange (9/20/2013)Like this?order by name
Sean Lange (9/20/2013)
order by name
I think ORDER BY name is what you want. But to get the sort order correct you will need to pad the values with leading...
September 20, 2013 at 12:48 pm
OK...here ya go...includes Brian's suggestion for Holidays. I turned it into a stored procedure:
CREATE PROCEDURE dbo.UTIL_CreateDateCalendar
September 11, 2013 at 8:21 pm
I haven't had a chance to review the entire script in detail nor have I gone back to read all the comments so if the following issue has already been...
September 10, 2013 at 9:07 pm
Great script! :w00t:
September 10, 2013 at 5:14 pm
coolrana.kumar69 (9/7/2013)in Which Sensory we use CTE
I use CTEs now routinely instead of using sub-queries. Just a new way of doing it that seems more clear and structured to...
September 7, 2013 at 7:14 pm
Great article Jeff. Perhaps you could add the point that when inserting code into the "Code" IFCode tags that tabs should be converted to spaces before pasting in the code....
September 5, 2013 at 11:03 am
Post about CONTAINSTABLE
Full Text Indexing - Text Parsing Routine[/url]
August 27, 2013 at 8:33 pm
Hey...I found the answer:
Erland Sommarskog, SQL Server MVP. 2013-03-24.
How to Share Data between Stored Procedures
"Another solution, which requires SQL 2008, comes from Wayne Bloss. He creates a table type that...
August 27, 2013 at 8:28 pm
countryflora13 (8/23/2013)So, where do we have to put this script I mean can I put it in my website or what? please explain little more
One thing I use it for...
August 23, 2013 at 10:06 am
Let me add to the conversation. Since the procedure's parameters (except for the first one) all have NULL assigned as a default doesn't mean that the parameter will be processed...
August 16, 2013 at 6:33 pm
Once you know what account it's trying to run under (the failure message will tell you), then you can right click on the SSMS shortcut and "Run As" that user...
August 16, 2013 at 5:21 pm
Jeff Moden (8/15/2013)
Steven Willis (6/22/2013)
It looks like you have a winner! I ran a test of DelimitedSplit8K using your method against 3 other methods including the Itzik Ben-Gan method. Your...
August 15, 2013 at 5:22 pm
I'll make a list of possible changes for review so we can all contribute and not have to do stuff over and over. Thanks.
1 Negative numbers
2 Base 0 or 1
August 15, 2013 at 11:15 am