Showing posts with label Daily Tips. Show all posts
Showing posts with label Daily Tips. Show all posts
Daily Tips- Tip #88 - How will you find 64-Bit Operating Systems and Processes ?
Sunday, January 8, 2012
You can identify 64-bit operating systems and processes with the Environment.Is64BitOperatingSystem and Environment.Is64BitProcess properties.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What are the types of Cursors in SQL Server ?
Sunday, March 20, 2011
1. Static
2. Keyset-driven
3. Dynamic
4. Fast-Forward only
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
How will you get the last error no in SQL Server ?
How will you get GUID in SQL Server ?
Daily Tips- Tip #85 - SQL Performance Tuning
sp_depends is the stored procedure is used to know which table use a rule or default.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #84 - SQL Performance Tuning
sp_unbindrule is the stored procedure which is used to unbind rule from table.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #83 - SQL Performance Tuning
sp_bindrule is the stored procedure which is used to bind rule to table.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #82 - SQL Performance Tuning
sp_helptext is the stored procedure which gives details about rules and defaults.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #81 - SQL Performance Tuning
sp_helpdb is the stored procedure which gives details about database.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #80 - SQL Performance Tuning
sp_help is the stored procedure which gives table details.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #79 - SQL Performance Tuning
sp_helpconstraint is the stored procedure to view constraints.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #78 - Performance Tuning .NET - How will you assure an objects disposal on all situations ?
Thursday, March 17, 2011
With the help of the 'using' statement.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #77 - Performance Tuning .NET - How will you return multiple values from a method ?
By Using the Out keyword on return parameters.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #76 - Performance Tuning .NET - Providing Sorting routines to your class
Implement IComparable in your class, which provides sorting routines of List and SortedList.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #75 - Performance Tuning .NET
Use System.Collections.Generic.Stack and System.Collections.Generic.Queue instead of System.Collections.Stack and System.Collections.Queue
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #74 - Performance Tuning .NET
Use System.Collections.Generic.List instead of System.Collections.ArrayList
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #73 - SQL Performance Tuning
Saturday, March 12, 2011
"SET NOCOUNT ON" reduces network traffic between server and client.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #72 - SQL Performance Tuning
use the SQL Server's Profiler Create Trace Wizard to run the "Profile the Performance of a Stored Procedure" trace to provide you with the data you need to identify poorly performing stored procedures..
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #69 - SQL Performance Tuning
To help identify long running queries, use the SQL Server Profiler Create Trace Wizard to run the "TSQL By Duration" trace.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Daily Tips- Tip #68 - SQL Performance Tuning
Avoid using temp table unnecessarily, if needed explicity create them.
1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning
Subscribe to:
Posts (Atom)
