I have experience lots a time, where people use to name there stored procedure with the prefix sp_Name1.. like this, but this is actually not a good practice, it may lead to degrade performance of you SQL server.
The reason behind this is, whenever you write stored procedure with a prefix sp, the SQL Server first check the stored procedure in System Stored Procedure, and then in the users defined stored procedure. Instead if you gave prefix other then 'sp' for example proc_getData like this the SQL server first check the Stored procedure in the user Stored procedure directory.
So do the better practice and enjoy T-SQL programming.
About Me
- Vikram Mahapatra (Viki)
- Mumbai, Maharastra, India
- He has more than 7.6 years of experience in the software development. He has spent most of the times in web/desktop application development. He has sound knowledge in various database concepts. You can reach him at viki.keshari@gmail.com https://www.linkedin.com/in/vikrammahapatra/ https://twitter.com/VikramMahapatra http://www.facebook.com/viki.keshari
Tuesday, March 23, 2010
Wednesday, February 3, 2010
'Go' New Language from Google
The syntax of Go is close to that of C except for the type declarations; other syntactical differences are the missing parentheses around for and if expressions. It is designed for exceptionally fast compilation times, even on modest hardware. The language requires garbage collection. Certain concurrency-related structural conventions of Go (channels and alternative channel inputs) are borrowed from Tony Hoare's CSP, but many (such as Edsger Dijkstra's guarded commands) are omitted. Unlike previous concurrent programming languages such as occam or Limbo, Go does not provide any in-built notion of safe or verifiable concurrency. Go also has some features of the Pi calculus such as channel passing.
Features not included in Go are exception handling, type inheritance, generic programming, assertions, and method overloading and pointer arithmetic.One Of these, the Go authors express an openness to generic programming and exceptions, explicitly argue against assertions, while defending the choice to omit type inheritance on efficiency grounds.Unlike Java, maps (also known as hashes or dictionaries) are an intrinsic part of the language, as are strings.
Visibility of functions outside of their defining file is defined implicitly according to the capitalization of their identifier, in contrast to C, where an explicit static keyword is used.
Features not included in Go are exception handling, type inheritance, generic programming, assertions, and method overloading and pointer arithmetic.One Of these, the Go authors express an openness to generic programming and exceptions, explicitly argue against assertions, while defending the choice to omit type inheritance on efficiency grounds.Unlike Java, maps (also known as hashes or dictionaries) are an intrinsic part of the language, as are strings.
Visibility of functions outside of their defining file is defined implicitly according to the capitalization of their identifier, in contrast to C, where an explicit static keyword is used.
Subscribe to:
Posts (Atom)