|
|
|
SSC-Dedicated
           
Group: General Forum Members
Last Login: Today @ 10:37 AM
Points: 32,893,
Visits: 26,769
|
|
Mohit (11/12/2008) Toni Thank-you for the suggestion :).
I started working on the part-2 of this article, I will talk about all the suggestions in that article. If there are any more suggestions please feel free to make them. I am really greatful for all the help here :D.
- Mohit.
Heh... you know I've just gotta ask, Mohit... Where's part 2? ;)
--Jeff Moden "RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."
For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
|
|
|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: 2 days ago @ 12:37 PM
Points: 941,
Visits: 1,041
|
|
Hi Jeff :),
It's on its way, I been busy with my research on the Theises for Masters. I have next two weeks off work; I plan to finish writing few articles for SQL Server and get more research in heh (at least thats the goal). I have most of the article done. I just got to fix up my English and proof read it to make sure I didn't make any stupid mistakes again :P.
Mohit.
---
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN. Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding... * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. 
How to ask for help .. Read Best Practices here.
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55,
Visits: 155
|
|
here is a script i wrote that can normalise data from a single table into several tables with data and keys. it is useful when undertaking a normalisation process or when importing data into an existing database: [url=http://www.sqlservercentral.com/articles/Normalization/64428/][/url]
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55,
Visits: 155
|
|
| the repeats of the posts have been accidentally submitted due to an application error with sqlservercentral.com
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55,
Visits: 155
|
|
here is a script i wrote that helps normalise a single table into a number of tables. useful for normalising a database during the development phase.
http://www.sqlservercentral.com/scripts/Normalisation/66370/
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55,
Visits: 155
|
|
here is a script i wrote that helps normalise a single table into a number of tables. useful for normalising a database during the development phase.
[url=http://www.sqlservercentral.com/scripts/Normalisation/66370/][/url]
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55,
Visits: 155
|
|
here is a script i wrote that helps normalise a single table into a number of tables. useful for normalising a database during the development phase.
[url=http://www.sqlservercentral.com/scripts/Normalisation/66370/][/url]
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Sunday, September 25, 2011 6:50 AM
Points: 55,
Visits: 155
|
|
here is a script i wrote that helps normalise a single table into a number of tables. useful for normalising a database during the development phase.
http://www.sqlservercentral.com/scripts/Normalisation/66370/
|
|
|
|