You can find everything about SQL Server here...

What is Database Architecture ?

noreply@blogger.com (Anonymous) — Sat, 18 Apr 2020 01:50:00 +0000

Each database will be divided into two types of implementations
•Logical implementation
Tables, views, procedures ..etc
•Physical implementation
.LDF, .MDF and NDF files

When using a database, you work primarily with the logical components such as tables, views, procedures ..etc The physical implementation of files is largely transparent. Typically, only the database administrator needs to work with the physical implementation.

What is Physical Data Base ?

noreply@blogger.com (Anonymous) — Sat, 18 Apr 2020 00:50:00 +0000

Physical Db will be divided in to 3 types:
1) .MDF 2) .LDF 3) .NDF

MDF is a file extension associated with Microsoft SQL Server primary data file.
LDF is a file extension associated with SQL Server Secondary Transaction log file.
NDF is a file extension associated with SQL Server Secondary Data file.
.MDF & .NDF having DB related data
.LDF having logs related data

On Physical Database contains File Groups and Transaction log
In File Group Contains Data Files
Data File contains Tables
Tables contains Extents
Extents contains Pages
pages Contains Rows

Transaction log is User defined file group by default it's

Logical - database objects like view,Sp,functions,Triggers,Indexes and roles etc..

What is DEP(Data Execution Prevention) ? How to configure DEP settings?

noreply@blogger.com (Anonymous) — Fri, 17 Apr 2020 08:49:00 +0000

What is Data Execution Prevention

Data Execution Prevention (DEP) helps prevent damage from viruses and other security threats
that attack by running (executing) malicious code from memory locations that only Windows and
other programs should use. This type of threat causes damage by taking over one or more memory
locations in use by a program. Then it spreads and harms other programs, files, and even your e-mail contacts.

To configure DEP settings for Windows Server 2003 & ....

Need to modify Boot.ini file to prevent from this type of issues.

Physical Path of Boot.ini
1. Go to C: Drive
2. Click on Tools >> Folder Options >> view >> Uncheck "Hide protected operationg system files (Recommended)" >> Click OK
3. Now you can see the Boot.ini file

Change from /noexecute=####### to /noexecute=AlwaysOn and restart the computer.

To configure DEP settings for Windows and later & ....

1. Click Start, click Control Panel, and then double-click System.

2. Click the Advanced tab. Then, under Performance, click Settings.

3. Click the Data Execution Prevention tab.

4. Click Turn on DEP for essential Windows programs and services only to select the OptIn policy.

5. Click Turn on DEP for all programs and services except those I select to select the OptOut policy.

6. If you selected the OptOut policy, click Add and add the applications that you do not want to use DEP with.

Ref:
http://support.microsoft.com/kb/875352#5
http://channel9.msdn.com/forums/TechOff/227400-What-is-Data-Execution-Prevention-and-why-does-it-shut-down-IIS/
http://technet.microsoft.com/en-us/library/cc738483%28WS.10%29.aspx

Actual error is
Unexpectedly my website giving "Service Unavailable" message

"To help protect your computer, Windows has closed this program.
Name: IIS Worker Process
Publisher: Microsoft Corporation
[Change Settings] [Close Message]"

To avoid this error please read above information

Note: Please configure DEP settings at your server.

Get the list of tables with row count in sql server

noreply@blogger.com (Unknown) — Fri, 11 Oct 2019 07:14:00 +0000

CREATE TABLE #COUNTS
(
TABLE_NAME VARCHAR(255),
ROW_COUNT INT
)

EXEC SP_MSFOREACHTABLE @COMMAND1='INSERT #COUNTS (TABLE_NAME, ROW_COUNT) SELECT ''?'', COUNT(*) FROM ?'

SELECT TABLE_NAME, ROW_COUNT FROM #COUNTS
WHERE TABLE_NAME LIKE '%_SNAPSHOT%' AND ROW_COUNT < 3
ORDER BY ROW_COUNT ASC,TABLE_NAME

--DROP TABLE #COUNTS

How to get the Month Names and total days in that month of a year

noreply@blogger.com (Anonymous) — Mon, 27 Mar 2017 10:56:00 +0000

How to get the Month Names and total days in that month of a year

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Venkat Thogati
-- Description: How to get the Month Names and total days in that month of a year
-- =============================================
Create

ALTER PROCEDURE [dbo].[usp_PrintCalenderMonths_TVN]
@Year VARCHAR (4) AS
BEGIN
SET NOCOUNT ON;
DECLARE @YearStartDate VARCHAR (20)
DECLARE @YearEndDate VARCHAR (20)
SET @YearStartDate = @Year+'0101' --instead of static one you may get by query also
SET @YearEndDate = @Year+'1231'
;with CTE1 as
(
SELECT CAST(@YearStartDate as DateTime) + 0 AS d
UNION all
SELECT DATEADD(day , 1,d) from CTE1 where DATEADD(day , 1,d) <= CAST(@YearEndDate as DateTime)
)
SELECT datepart(month , d) AS 'S.no', datename(month , d) AS MonthName , count(*) AS NoOfDays from CTE1
GROUP BY datename(month , d), datepart(month , d) OPTION (MAXRECURSION 0);
END

Now execute the below one
--Exec usp_PrintCalenderMonths_TVN 2017

Errors in the OLAP storage engine: The slice specified for the Year attribute is incorrect.

noreply@blogger.com (Anonymous) — Fri, 26 Feb 2016 06:13:00 +0000

OLAP Cube Processing Error
Errors in the OLAP storage engine: The slice specified for the Year attribute is incorrect. Errors in the OLAP storage engine:
An error occurred while processing the indexes for the 2005_11 - _CubeName - MeasureGroupName partition of the MeasureGroupName measure group of the _CubeName cube from the StudentOLAPDB database.

Solution -
Remove the code from slice text box and process it again (because it may have the data before 2005 or make sure that 2005 partition should have 2005 data only)

What is DBCC FREESYSTEMCACHE

noreply@blogger.com (Anonymous) — Mon, 16 Nov 2015 07:46:00 +0000

DBCC FREESYSTEMCACHE Releases all unused cache entries from all caches. The SQL Server Database Engine proactively cleans up unused cache entries in the background to make memory available for current entries.

However, you can use this command to manually remove unused entries from all caches or from a specified Resource Governor pool cache.

Ex:
-- Clean all the caches with entries specific to the resource pool named "default".
DBCC FREESYSTEMCACHE ('ALL', default);

-- The following example uses the MARK_IN_USE_FOR_REMOVAL clause to release entries from all current caches once the entries become unused

DBCC FREESYSTEMCACHE ('ALL') WITH MARK_IN_USE_FOR_REMOVAL;
Below query will return all the caches available :
--- ONLY for Educational purpose. Don't attempt to run on PROD Servers !!
select 'DBCC freesystemcache ('+''''+name+''''+')'
from sys.dm_os_memory_clerks group by name

-- clears cache for specific user database
DBCC FREESYSTEMCACHE ('userdatabase')

-- clears cache for tempdb
DBCC FREESYSTEMCACHE ('tempdb')

-- clears all the temp table and variables

DBCC FREESYSTEMCACHE ('Temporary Tables & Table Variables')

Best articles for "SQL SERVER – Fundamentals of Columnstore Index" / "Columnstore Indexes in SQL Server 2012"

noreply@blogger.com (Anonymous) — Tue, 05 May 2015 10:07:00 +0000

Hi guys, while I am searching for Columnstore Indexes in SQL Server 2012 / SQL SERVER – Fundamentals of Columnstore Index i found the below best articles

1. https://www.simple-talk.com/sql/database-administration/columnstore-indexes-in-sql-server-2012/

2. OCTOBER 29, 2011 BY PINAL DAVE SQL SERVER – Fundamentals of Columnstore Index

Get the list of table names from a data base for a particular schema

noreply@blogger.com (Anonymous) — Thu, 09 Apr 2015 06:20:00 +0000

Below is the query for to get the list of table names from a data base for a particular schema

SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'SchemaName' AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Other use full quries

SELECT * FROM sys.tables;

SELECT * FROM INFORMATION_SCHEMA.TABLES

SELECT * FROM sysobjects WHERE xtype='U'

What is Precision in SQL Server?

noreply@blogger.com (Anonymous) — Fri, 21 Nov 2014 10:49:00 +0000

What is Precision in SQL Server?

Precision is the number of digits in a number.
Scale is the number of digits to the right of the decimal point in a number.
For example, the number 123.45 has a precision of 5 and a scale of 2.
In SQL Server, the default maximum precision of numeric and decimal data types is 38.

sql server get identity after insert stored procedure

noreply@blogger.com (Anonymous) — Wed, 01 Oct 2014 11:13:00 +0000

In this step by step SQL Tutorial I will show you how to using SQL Server get identity after insert using stored procedure. For the purpose of this tutorial I will use SQL Server 2008 R2.

Other Versions of SQL Server:

SQL Server 2012
- The examples we used should work in SQL Server 2012
SQL Server 2008 / R2
- This blog post has been written using SQL Server 2008 R2
SQL Server 2005
- We suspect that this will work in SQL Server 2005 as well

NOTE: The method we will use contains some bugs which we will mention so ensure you fully test your code and make appropriate research.

Who is it for?

People who need to insert row and get IDENTITY value back Contents

Introduction to get Identity
How to get identify after Insert
Get Identity after insert in stored procedure

Introduction to get Identity

There are different way to get identity ID after insert and there are:

NOTE: Both @@identity and Scope_identity contained a bug that apparently was fixed certain version

@@IDENTITY - Returns last inserted identity using current connection. This means that you get last inserted identity which might not be necessarily be after your insert. If you have trigger that insert row and new identity inserted you might get this ID instead. Methpd below seems to be more reliable and @@identity should be avoided.
SCOPE_IDENTITY() - Returns last identity value that was created in current connection but also the statement scope. This means it should return Identify of your statement (not affected by triggers). I will use this method in my example.
IDENT_CURRENT(‘tablename’) - Returns last inserted Identity value in a specifed table. Regardless of the conneciton and should be used only in very specific scenarios.
OUTPUT INTO - This clause can be used with INSERT and you can ouput inserted rows (with Identity) to another table or table variable and access the value. This sounds like the most reliable way to get exactly the ID you want, however as we don't know the limitation of this method (if any) and extra code that is required in our case we will just use SCOPE_IDENTITY.

How to get identify after Insert

-- First let me create Test table

CREATE TABLE

dbo.Test (

ID INT IDENTITY(1,1) NOT NULL

,TestField NVARCHAR(50) NOT NULL

)

-- Below I insert one row into my Test table. This will generate new ID

INSERT INTO dbo.Test (TestField)

VALUES ('test')

-- and here's how you can get the identity back from the last inserted ID

SELECT SCOPE_IDENTITY()

Get Identity after insert in stored procedure

-- below is stored procedure T-SQL Script

CREATE PROCEDURE dbo.GetIdentityAfterInsert

@ID AS INT OUTPUT

BEGIN

--insert new row

INSERT INTO dbo.Test (TestField)

VALUES ('test');

--save identity value and return using stored procedure OUTPUT parameter

SET @ID = (SELECT SCOPE_IDENTITY())

END

How it works? The stored procedure accepts one parameter @ID (this actually should always be empty when you use SP) but it uses OUTPUT to return result.

So you can capture Identity can store it in variable using the following code

DECLARE @ID AS INT

EXEC dbo.GetIdentityAfterInsert @ID OUTPUT

SELECT @ID

NOTE: OUTPUT in the middle line is very important. If you don't put it than the variable won't be populated.

How to Optimizing in OLAP processing / Optimizing Cube Performance with OLAP / Tips for Optimizing SQL Server OLAP/Analysis Services / Cube Processing with ProcessData & ProcessIndexes

noreply@blogger.com (Anonymous) — Mon, 26 May 2014 09:27:00 +0000

We are facing the problem at Cube processing on daily schedule, 2 cubes are taking more time. on this topic we had around one week discussion with team to reduce the processing time of those cubes.

we tried for the below procedure and we got the good result and we are following this

Old Process: Every day cube is running with ProcessFull option ProcessFull

New Process: Now cube processing with ProcessData ProcessData & Process ProcessIndexes options

above one file is divided into two files and processing one by one
First need to process the ProcessData files - Cube is ready after completion of this step
Second process the ProcessIndexes files - Performance will increase after completion of this step

Please see the below old code & new code

in Old Process we have only one file called with "0. _CubeName.Partition.2012" and below is the code

in the New Process there are two files "0. _CubeName.Partition.ProcessData.2012" & "0. _CubeName.Partition.ProcessIndexes.2012" and below is the code

Please find the below screen shots of processing steps

Below are the list of Cube Processing Options

Microsoft – SQL Server – xp_delete_file – error 2 ? / Maintenance Cleanup Job Task Fails but Backup Jop is successful ? / Maintenance cleanup Task does not delete files?

noreply@blogger.com (Anonymous) — Mon, 26 May 2014 08:02:00 +0000

Error Message Screen Shot

Solution:

DECLARE @currentdate datetime

DECLARE @olddate datetime

set @currentdate = CURRENT_TIMESTAMP

--Change

set @olddate = @currentdate - 1

--Change number here depending how many days of backup file you

--want to retain on server.

-- Add below line for each database/path you might need.

EXECUTE master.dbo.xp_delete_file

,N'C:\MSSQL\Backup\Temp2\'

,N'bak'

,@olddate

Here first arg is

0 - specifies a backup file

1 - specifies a report file

Fifth argument is

0 - don't delete recursively (default)

1 - delete files in sub directories

For some reason, master.dbo.xp_delete_file sometimes returns the error listed below:

Msg 22049, Level 16, State 1, Line 0

xp_delete_file() returned error 2, ‘The system cannot find the file specified.’

To remediate:

Ensure that the folder referenced in the master.dbo.xp_delete_file exists

Ensure that the SQL Server or SQL Server Agent has access to the folder referenced

SQL Stored Procedure Modified Date Query

noreply@blogger.com (Anonymous) — Fri, 16 May 2014 13:17:00 +0000

While working on a problem I wanted to determine the last modified date for stored procedures (sprocs) in the SQL database I was working in. After some Google’ing I learned the following, from forums, multiple blog posts, etc. I figured it would be nice to have this information in a centralized area, so here you go....

SQL 2005 Stored Procedure Last Modified Date

Getting the last modified date for sprocs in SQL 2005 is really easy using the following query:

-- Queries the sys.objects system view to gather information

-- about user defined stored procedure database objects;

-- specified with type='P'.

-- SQL 2005 --

USE AdventureWorks; -- Database name

SELECT name, create_date, modify_date

FROM sys.objects -- User defined objects system view

WHERE type = 'P' -- Only return stored procedures

AND name LIKE 'mycompanyprefix_%' -- Only return sprocs with names beginning with "mycompanyprefix_"

SQL 2000 Stored Procedure Last Modified Date

Unfortunately, there isn’t an equivalent command for SQL 2000. The modified date columns in SQL 2000 weren’t being updated correctly and from the research I performed Microsoft didn’t fix the problem until SQL 2005. I tried writing the following similar query to the one that works in SQL 2005, but the created date & ref date are always the same.

-- SQL 2000 --

-- DOESN'T WORK --

USE Northwind;

SELECT name, crdate, refdate

FROM sysobjects

WHERE type = 'P'

AND name LIKE 'mycompanyprefix_%'

How to resolve source.udl error while executing the JOB on SQLServer?

noreply@blogger.com (Anonymous) — Mon, 25 Nov 2013 07:18:00 +0000

Hi All,

Guys I created one Job and it's scheduled for daily. some days it's running with out any issue and some it's giving the above error, I spent so much time to solve this issue but i couldn't, could any one please help me on this...

around from last 15 days I am fighting on this issue only and to complete this job it's taking 18 hrs, actually this is not an issue but some time it's giving the source.udl error.. and it's giving randomly not in on a particular day (like only on Tuesday, or Monday or sunday...)

if you observe in the above screen shot job ran successfully on 17th & 18th and it's failed on 19th again it's ran successfully on 20, 21 & 22 and it's failed on 23rd

Thanks in advance,

VenkataNarayana Thogati

How to find the list of tables containing column with specified name/ column name like ?

noreply@blogger.com (Anonymous) — Fri, 05 Jul 2013 10:53:00 +0000

select distinct TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME ,COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS 
where 
--COLUMN_NAME like '%KATID%'
TABLE_NAME like '%temp%'
order by  TABLE_NAME

PFA Sample Screen Shot

How to Find a string value in the current DB in SQL Server / How to find the SchemaName, TableName, ColumnName from the current DB by passing a string?

noreply@blogger.com (Anonymous) — Fri, 05 Jul 2013 10:35:00 +0000

/****** Object: To find the SchemaName, TableName, ColumnName from the current DB by passing a string ******/
/* Note: plz check the below commented code for Schema wise filtering and Table wise filter */
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--Exec [SP_StingFinderFromAllTheTablesInCurrentDB] 'Ven'
Create PROC [dbo].[SP_StingFinderFromAllTheTablesInCurrentDB]
@SearchStr nvarchar(100)
AS
BEGIN
DECLARE @dml nvarchar(max) = N''
IF OBJECT_ID('tempdb.dbo.#OutPut') IS NOT NULL DROP TABLE dbo.#OutPut
CREATE TABLE dbo.#OutPut
(
[Schema Name] nvarchar(100),
[Table Name] nvarchar(100),
[Column Name] nvarchar(100),
[Given String] nvarchar(max))
SELECT @dml += ' SELECT ''' + s.name + ''' AS [Schema Name], ''' + + t.name + ''' AS [Table Name], ''' +
c.name + ''' AS [Column Name], CAST(' + QUOTENAME(c.name) +
' AS nvarchar(max)) AS [Given String] FROM ' + QUOTENAME(s.name) + '.' + QUOTENAME(t.name) +
' (NOLOCK) WHERE CAST(' + QUOTENAME(c.name) + ' AS nvarchar(max)) LIKE ' + '''%' + @SearchStr + '%'''
FROM sys.schemas s JOIN sys.tables t ON s.schema_id = t.schema_id
JOIN sys.columns c ON t.object_id = c.object_id
JOIN sys.types ty ON c.system_type_id = ty.system_type_id AND c .user_type_id = ty .user_type_id
WHERE t.is_ms_shipped = 0 AND ty.name NOT IN ('timestamp', 'image', 'sql_variant')
--and t.name like '%_Cleansing' -- Table wise filter
--and S.name = 'Your Schema Name' -- Schema wise filter

INSERT dbo.#OutPut
EXEC sp_executesql @dml

SELECT *
FROM dbo.#OutPut
END

how to know outlook 2003 mail replied time in C#? Error Image

noreply@blogger.com (Anonymous) — Tue, 23 Apr 2013 11:30:00 +0000

What is the maximum number of Index per table in ,SQL Server 2005, SQL Server 2008 & SQL Server 2012?

noreply@blogger.com (Anonymous) — Wed, 10 Apr 2013 06:49:00 +0000

In SQL Server 2005 we can create 1 cluster+249 non cluster=250 indexes
For More Iformation: http://technet.microsoft.com/en-us/library/ms143432(v=SQL.90).aspx
In SQL Server 2008 we can create 1 cluster+999 non cluster=1000 indexes
For More Iformation: http://technet.microsoft.com/en-us/library/ms143432(v=sql.105).aspx
In SQL Server 2012 we can create 1 cluster+999 non cluster=1000 indexes
For More Iformation: http://msdn.microsoft.com/en-us/library/ms143432.aspx

How to find a column from Entire Database?

noreply@blogger.com (Anonymous) — Wed, 03 Apr 2013 07:44:00 +0000

use [DataBase Name]

SELECT tab.Name AS Tablename,SCHEMA_NAME(schema_id) AS Schemaname,col.name AS Columnname
FROM sys.tables AS tab INNER JOIN sys.columns col ON tab.OBJECT_ID = col.OBJECT_ID
WHERE col.name LIKE '%ShiftStartTime%'

10 reasons why SQL Server 2008 is going to rock OR SQL Server 2008 Features

noreply@blogger.com (Anonymous) — Thu, 23 Aug 2012 01:30:00 +0000

10. Plug-in model for SSMS. SSMS 2005 also had a plug-in model, but it was not published, so the few developers that braved that environment were flying blind. Apparently for 2008, the plug-in model will be published and a thousand add-ins will bloom.

9. Inline variable assignment. I often wondered why, as a language, SQL languishes behind the times. I mean, it has barely any modern syntactic sugar. Well, in this version, they are at least scratching the the tip of the iceberg. Instead of:
               DECLARE @myVar int SET
               @myVar = 5
you can do it in one line:
              DECLARE @myVar int = 5 Sweet.

8. C like math syntax.
          SET @i += 5. Enough said. They finally let a C# developer on the SQL team.

7. Auditing. It's a 10 dollar word for storing changes to your data for later review, debugging or in response to regulatory laws. It's a thankless and a mundane task and no one is ever excited by the prospect of writing triggers to handle it. SQL Server 2008 introduces automatic auditing, so we can now check one thing off our to do list.

6. Compression. You may think that this feature is a waste of time, but it's not what it sounds like. The release will offer row-level and page-level compression. The compression mostly takes place on the metadata. For instance, page compression will store common data for affected rows in a single place. The metadata storage for variable length fields is going to be completely crazy: they are pushing things into bits (instead of bytes). For instance, length of the varchar will be stored in 3 bits. Anyway, I don't really care about space savings - storage is cheap. What I do care about is that the feature promised (key word here "promises") to reduce I/O and RAM utilization, while increasing CPU utilization. Every single performance problem I ever dealt with had to do with I/O overloading. Will see how this plays out. I am skeptical until I see some real world production benchmarks.

5. Filtered Indexes. This is another feature that sounds great - will have to see how it plays out. Anyway, it allows you to create an index while specifying what rows are not to be in the index. For example, index all rows where Status != null. Theoretically, it'll get rid of all the dead weight in the index, allowing for faster queries.

4. Resource governor. All I can say is FINALLY. Sybase has had it since version 12 (that's last millennium, people). Basically it allows the DBA to specify how much resources (e.g. CPU/RAM) each user is entitled to. At the very least, it'll prevent people, with sparse SQL knowledge from shooting off a query with a Cartesian product and bringing down the box. Actually Sybase is still ahead of MS on this feature. Its ASE server allows you to prioritize one user over another - a feature that I found immensely useful.

3. Plan freezing. This is a solution to my personal pet peeve. Sometimes SQL Server decides to change its plan on you (in response to data changes, etc...). If you've achieved your optimal query plan, now you can stick with it. Yeah, I know, hints are evil, but there are situations when you want to take a hammer to SQL Server - well, this is the chill pill.

2. Processing of delimited strings. This is awesome and I could have used this feature...well, always. Currently, we pass in delimited strings in the following manner: exec sp_MySproc 'murphy,35;galen,31;samuels,27;colton,42' Then the stored proc needs to parse the string into a usable form - a mindless task. In 2008, Microsoft introduced Table Value Parameters (TVP). CREATE TYPE PeepsType AS TABLE (Name varchar(20), Age int) DECLARE @myPeeps PeepsType INSERT @myPeeps SELECT 'murphy', 35 INSERT @myPeeps SELECT 'galen', 31 INSERT @myPeeps SELECT 'samuels', 27 INSERT @myPeeps SELECT 'colton', 42 exec sp_MySproc2 @myPeeps And the sproc would look like this: CREATE PROCEDURE sp_MySproc2(@myPeeps PeepsType READONLY) ... The advantage here is that you can treat the Table Type as a regular table, use it in joins, etc. Say goodbye to all those string parsing routines.

1. Intellisense in the SQL Server Management Studio (SSMS). This has been previously possible in SQL Server 2000 and 2005 with use of 3rd party add-ins like SQL Prompt ($195). But these tools are a horrible hack at best (e.g. they hook into the editor window and try to interpret what the application is doing). Built-in intellisense is huge - it means new people can easily learn the database schema as they go.

Sharepoint Solved Issues

noreply@blogger.com (Anonymous) — Wed, 14 Mar 2012 14:32:00 +0000

Hiding field in SharePoint through JavaScript in Edit mode
1. Create one new list
2. Open EditForm.aspx using sharepoint designer
3. Copy the following javascript code before

Ref link: http://www.sharepointkings.com/2009/10/hiding-field-in-sharepoint-through.html

Hiding the "Toolbar" (New/Upload/Actions/Settings) for list or document1. Open required list or document
2. Click on "Edit Page" option using this navigation (Site Actions --> Edit Page)
3. Click "Edit" Option then click on "Modify Shared Web Part"
4. Select "No Toolbar" option from Toolbar Type dropdown
5. Click on apply and see the result

Removing "Upload Multiple Documnets"
1. Open Allitems.aspx using sharepoint designer
2. Copy the following javascript code between and

Ref link: http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/c603c25a-729b-4038-908d-3e8d8b5dfc39

Setting List View Column Width in sharepoint
1. Open required list or document
2. Click on "Edit Page" option using this navigation (Site Actions --> Edit Page)
3. Click on “Add a web part” and add “Content editor web part” from Miscellaneous part.
4. Click "Edit" Option then click on "Modify Shared Web Part"
5. Click on “Source Editor” button then copy the below code
6. Here 'Client Name' & 'Overall Score' are the column names, you can use your required column names here.

Ref link: http://kjellsj.blogspot.in/2009/06/sharepoint-jquery-setting-td-column.html

Did you know? SQL Server 2008 includes GROUPING SETS

noreply@blogger.com (Anonymous) — Sun, 30 Oct 2011 05:56:00 +0000

Did you know? SQL Server 2008 includes GROUPING SETS

Did you know? SQL Server 2008 includes Dimension Designer Enhancements

noreply@blogger.com (Anonymous) — Sun, 30 Oct 2011 05:55:00 +0000

Did you know? SQL Server 2008 includes Dimension Designer Enhancements

Did you know? SQL Server 2008 includes Intellisense

noreply@blogger.com (Anonymous) — Sun, 30 Oct 2011 05:54:00 +0000

Did you know? SQL Server 2008 includes Intellisense