This blog is an entirely personal project, unrelated to my current, former or future employers. My employer has nothing to do with its content including anything that is posted on this blog. Information on this site may contain errors or inaccuracies, the blog site’s writer do not make warranty as to the correctness or reliability of this blog site’s content. If you own rights to any of the images or articles, and do not wish them to appear on this site, please contact me via e-mail and they will be promptly removed.
About Author
Ritesh Shah is an author of many technical article on Microsoft Technology, especially on SQL-Server, .NET technology like C# and ASP.Net etc. He is having 10+ year of experience in IT industry and working as Consultant Project Leader and Database Administrator.
He is very active community member, you can find him at:
SQLHub.com
Experts-Exchange.com
Asp.Net
LinkedIN
Beyond-Relational
TwitterMy Book
SQL Server 2012 Performance Tuning book by Ritesh Shah
Search SQLHub.com
-
Recent Comments
Archives
- January 2012
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- January 2011
- December 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- May 2008
- April 2008
Categories
- -SQL-Server 2005
- .DTSX
- .NET
- .NET 3.5
- .NET framework 4.0
- .NET Quiz 2011
- 10% discount
- 100 article complete
- ACCESS
- access 2007 in SQL Server
- addrolemember
- ado.net
- Aggregate
- aggregate function
- ahmedabad user group
- all tables
- alter all column
- ALTER PROC
- ALTER SCHEMA
- ALTER TRIGGER
- archive
- archive data in SQLServer
- Argument data type ntext is invalid
- array in SQL Server
- array pass to Stored procedure
- ascii
- ASCII to CHARACTER
- ASHX
- ASP.NET
- Asymmetric
- audit trail
- Auto_Close
- – Context_Info
- backup
- backup encrypted database
- backup master key
- BCP
- bcp.exe
- beyondrelational.com
- BLOB
- body surface area
- bpa
- BSA
- Bug Fix
- Bug Fix
- bulk copy
- bulk insert
- bulk operation
- bypass aspx in .NET
- bypass aspx in .NET
- C#
- c-sharp
- calculate clustered index size
- calculate index size
- calculate non-clustered index size
- Cannot generate SSPI context
- cannot open database
- Cascading Delete
- cascading Update
- catalog view
- cdc
- cerate certificate
- certificate in database
- change collation
- change column name
- change data capture
- change database mode
- Channel 9
- CHAR
- character count
- character map transformation task
- charindex
- CHECK
- check database size
- check file exists in SQL Server
- checkpoint
- client/server application
- CLR function
- clustered index
- coalesce
- CODEPLEX Toolkit
- collation
- comma separated value
- comparison catalog view and information_schema
- comparison of SP and UDF
- COMPUTE
- concat_null_yields_null
- conditional split transformation
- configure mySQL in windows
- configure php
- configure php in IIS
- Contains
- ContainsTable
- convert local datetime to UTC
- copy backup from one location to another
- copy files
- copy files and folder from SQL Server
- copy ldf
- copy mdf
- COPY ONE TABLE FROM ANOTHER
- correlated subquery
- count
- count and null
- create clustered index on view
- create CSV file from SQL
- create database master key
- create full text catalog
- create full text index
- create login
- create master key
- create nonclustered index on view
- CREATE PROC
- CREATE RULE
- CREATE SCHEMA
- create symmetric key
- create synonym
- CREATE TRIGGER
- create txt file
- create user
- create view
- CROSS APPLY
- Cross Tab Query
- crystal report
- cte
- cube
- cursor
- DAC
- data abstract layer
- data access error
- data file size
- data management view
- data size in table
- database backup
- Database Engine tuning adviser
- database master key
- database trigger
- database tuning advisor
- DatabaseMailUserRole
- DataFlow
- DataLength
- date
- dateadd
- datediff
- datetime bug
- datetime format
- day calculate with CTE
- DBCC CheckDB
- DBCC INDEXDEFRAG
- DBCC Page
- DBCC SHOWCONTIG
- db_name()
- DDL TRIGGER
- deadLock
- decryption
- definition of cursor
- Definition OF SCHEMA
- delete
- delete all records
- delete duplicate records
- delete in bunch
- delete many records
- delete multiple records
- delete with JOIN
- DELETED
- denali
- difference between BCP and BULK INSERT
- difference between delete and truncate
- difference between len and datalength
- difference between len and datalength
- Difference between sql server 2000 and sql server 2005
- Difference between sql server 2005 and 2008
- difference between Stored Procedure and User Define Function
- Difference between WHERE and HAVING
- difference exec and sp_executeSQL
- difference of cube and rollup
- diffrence between rank() and rown_Number()
- DIFFRENCE OF SET AND SELECT
- division operator
- division operator return zero 0
- dmf
- DMK
- DML trigger
- dmv
- dm_db_partition_stats
- DRI
- DROP PROC
- DROP SCHEMA
- DTA
- DTS
- dynamic alter table script
- dynamic cursor
- dynamic pivot
- dynamic query with Uniqueidentifier
- dynamic select in SP
- dynamic sql
- dynamic word document with C#
- dynamic word document with image with C#
- email from trigger
- email when run out of space
- ENABLE XP_CMDSHELL
- encryption
- encryption with asymmetric key
- encry\
- environtment.currentdirectory
- error 28
- error 7303
- error 7411
- error 8152
- error fix
- EVENTDATA()
- example of Silverlight
- except
- exclusive lock
- EXEC
- EXEC sp_BindRule
- execute
- EXECUTE permission was denied on the object sp_send_dbmail
- expert exchange
- experts-exchange.com
- export data from SQL to CSV
- export data from SQL to excel
- export from SQL to Flat file
- FAQs in SQL Server
- fast_forward
- features
- fetch next
- fetch_first
- fetch_last
- fetch_prior
- filestream
- fillfactor
- find columns
- find currently running query
- find data file size
- find default value of column
- find disk space usage
- find error log file
- find first Friday
- find foreign key
- Find fully qualified path
- find GMT +5.30 time
- find guest user
- find Last Friday
- find lock
- find locked table
- find log file size
- find primary key
- find size of each table
- find stored procedure
- find table list
- find table size
- find user
- find user in all database
- find user permission
- find word in stored procedure
- fire fox
- Flat File Destination
- fn_PhysLocFormatter
- for xml path
- ForEach Loop
- formsof
- forward_only
- free ebook
- free second chance
- free SQL Server 2008 ebook
- FreeText
- FREETEXTTABLE
- frequently Asked question
- FTS
- full qualified path
- Full Text Search
- fuzzy lookup
- gandhinagar user group
- generic list in SP
- generic pivot SP
- get drive infor of windows
- getdate()
- getutcdate()
- grantdbaccess
- grantlogin
- group by
- grouping sets
- grouping sets in SQL Server 2008
- guitar
- guru sql server
- hand return value from C#
- hardening sql server
- HAVING Clause
- hint
- http connection manager
- HTTP Endpoint
- http handler
- identity
- identity_insert
- IE 8
- IE 8 RC1
- iFTS
- image in database
- image in sql-server 2005
- image store
- image store in sql server
- import excel file to sql server
- IMPROVED INSERT
- index
- index rebuild
- index reorganize
- Indic_General_90_BIN
- inflectional
- information_schema.columns
- information_schema.routines
- INFORMATION_SCHEMA.tables
- inline table valued function
- Inner Join
- insert image in sql server
- INSERT in SQL Server 2008
- insert into
- insert manual value in identity column
- insert trigger
- insert varbinary
- INSERT with Raw Constructor
- INSERTED
- Installation of Silverlight
- instance
- instead of trigger
- Integrated Full Text Search
- internet explorer
- intersect
- invalid precision for decimal data type
- isnull
- jacob sebastian
- Jason Olson
- JOB List
- john papa
- join
- keep eye on database file
- keep eye on hard disk space
- keep track of database file
- KEEPFIXED PLAN
- keyset cursor
- LDF
- Left Join
- LEN
- LIKE
- linked server
- linked server with excel
- list of all datetime format
- LN in Excel
- load XML into SQL
- locate physical row address
- LOG
- log file size
- Log in Excel
- Log in sql server
- log transaction
- LOG10 in sql server
- logical delete
- login
- M language
- machine.config
- mark wills
- master sql server
- master.dbo.xp_fileexist
- mbsa
- MCITP
- MCPD
- MCTS
- mDF
- memory leak
- memory leak in SQL Server 2008
- memory leak in SQL Server 2008
- Merge Join Transformation Task
- Merge Statement
- Michael Coles
- Microsoft
- microsoft baseline security analyzer
- microsoft best practices analyzer
- microsoft exams
- Microsoft News & Others
- microsoft sql server
- Microsoft sync service
- microsoft tech days
- Microsoft.ACE.OLEDB.12.0
- Microsoft.Jet.OLEDB.4.0
- micrso
- ms sq
- MS SQL Server
- MS SQL Server 2000
- MS SQL Server 2005
- ms sql server 2008
- MSDB..sp_HELP_JOB
- msdb..sysjobs
- msdb.dbo.sp_send_dbmail
- MSforEachDB
- Msg 15118
- Msg 1939
- Msg 1940
- Msg 7403
- Msg 8116
- msg 8152
- multi statement UDF
- multiple SQL Server in one server
- multiple ways to insert records
- multi_user
- multyplication operator
- mvp
- naming convention
- naming guideline of database object
- NDF
- NEAR in CONTAINS
- nested cte
- net start
- net stop
- network-related or instance-specific error
- NEWID()
- non-identity
- noncolustered index
- ntile
- null
- OBJECT_DEFINITION
- office 2010
- open master key
- openquery
- OPENROWSET
- order by
- order by total
- oslo
- osql
- OUTER APPLY
- OUTER join
- OUTPUT
- OUTPUT Parameter
- OVER
- padindex
- paging
- paging in SP
- parameter in HTTP Endpoint
- Partition by
- Password validation failed
- patindex
- performance counter registry hive consistency
- pinal dave
- PIVOT
- PIVOT Task in SSIS
- pivot with where condition
- policy enforcing
- Policy managment
- primary key
- proper case
- PSEUDO TABLE
- quarter
- query job
- query XML file
- QUOTENAME
- RANK()
- ranking rows in groups
- Read Committed Isolation Level
- read registry
- read typed XML
- Read UnCommitted Isolation Level
- read website in asp.net
- read xml
- recursive query
- regex.split
- regional language in sql server
- rename column name
- Repeatable Read Isolation Level
- restore DMK
- restore DMK
- restore encrypted database
- restore master key
- restricted_user
- Result Destination task
- retularexpression.regex
- return data
- RETURN DATA FROM DELETE
- RETURN DATA FROM INSERT
- RETURN DATA FROM UPDATE
- return value from SP
- revoke access of user
- Right Join
- ritesh
- Ritesh Shah
- rollup
- row level versioning
- row_number()
- SAGE
- scalar UDF
- sch-m lock
- SCHEMA
- schema change lock
- script task
- scrollable cursor
- search modified object
- search text of Stored procedure
- SELECT
- select duplicate records
- SELECT INTO
- select primary key
- select random
- SELECT UNION ALL
- SendMail
- Serializable Isolation Level
- server doesn't support requested protocol
- server trigger
- servername
- SERVERPROPERTY
- SERVERPROPERTY('ErrorLogFileName')
- Service Area Configuration
- service master key
- Session Variable
- SET
- set based theory
- set database offline
- set database online
- set default in all column
- set identity_insert
- set rowcount
- shrink log file
- shrink log file of all database
- SilverLight
- single_user
- SMK
- SNAPSHOT ISOLATION
- SPLIT
- split value
- split value in c#
- sp_addrolemember
- sp_configure
- sp_depends
- sp_executeSQL
- sp_fulltext_catalog
- sp_fulltext_column
- sp_fulltext_database
- sp_fulltext_table
- sp_MSforeachdb
- sp_MSforeachtable
- SP_MSTABLESPACE
- sp_procoption
- sp_refreshSQLModule
- sp_rename
- sp_send_dbmail
- sp_spaceused
- sql
- SQL DMO
- SQL Injection
- SQL Server "Denali"
- sql server 2005
- sql server 2008
- sql server agent jobs
- sql server energy event
- sql server instance
- SQL Server profiler
- SQl server quiz
- SQL SMO
- SQL-Server
- SQL-Server 2005
- SQLHub.com
- SSIS
- startup stored procedure
- static cursor
- store document in sql server
- stored procedure
- Stored procedure naming conventino
- string manipulation
- string or binary data would be truncated
- stuff
- sub cte
- subquery
- subquery as table
- substring function
- sum
- Symmetric key
- synonym
- Sys.Columns
- Sys.Databases
- Sys.Database_files
- sys.database_principals
- sys.database_role_members
- Sys.Foreign_Key_Columns
- Sys.Key_Constraint
- Sys.Objects
- sys.procedures
- sys.schemas
- syscomments
- sysindexes
- sysjobhistory
- sysobject
- sysobject.xtype
- system databases
- System.IO.DriveInfo
- System.IO.DriveInfo.GetDrives()
- system.serviceprocess
- T SQL puzzle
- t-sq
- T-sql
- T-SQL Challenges Beginners
- table naming convention
- table statistics
- TCP Endpoint
- teched
- teched event in Ahmedabad
- teched on road
- The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered
- title case
- TOP
- total
- total row in table
- transaction log
- trigger
- truncate
- txt file
- typed XML
- UDF
- Unable to start debugging on web server. Debugging failed because integrated windows authentication is not enabled. Please see help for assistance
- Uncategorized
- union
- union all
- union in CTE
- Uniqueidentifier
- untyped XML
- update
- update fun
- update image in sql server
- update null data
- update null for all column
- update puzzle
- update statestics
- Update table
- update trigger
- update with aggregate function
- update XML column
- update XML data
- update()
- upgrade sql server
- use of cube and rollup
- user
- user account in SQL Server
- user and login issue
- USER DEFINE FUNCTION
- user defined rules
- UTC datetime
- vb.net
- view
- View should be with schemabindings
- vinod kumar
- Visual Studio 2008
- Visual Studio 2010
- watch your hard disk space
- web.config
- wedding anniversary
- what is identity
- where
- WHERE Condition
- windows 7.0
- windows appilcation
- Windows Installer Cleanup Utility
- windows server 2003
- xlsx in sql server 2005
- xml
- xml relational data in sql table
- XP_CMDSHELL
- xp_fileexist
- xp_fixeddrives
- xp_instance_regread
- xp_regRead
- xp_sendmail
- xtype
- YUKON
-
Recent Posts
- Book Review – SQL Server Interview Questions and Answers
- Error Fix: Msg 605 Attempt to fetch logical page (3:1307866) in database 6 failed. It belongs to allocation unit 72057594113359872 not to 72057594113490944
- Playing with OPTION KEEPFIXED PLAN hint in SQL Server
- Playing with OPTION KEEPFIXED PLAN hint in SQL Server
- Some facts about Stored Procedure Compilation & Recompilation
-
Top Posts
- Use of RANK() and Partition by clause in SQL-Server 2005
- Image store in SQL-Server 2005 database and retrieve it in asp.net application with C#:
- Empty all table or delete all data from all table by sp_MSforeachtable in SQL-SERVER 2005
- Complete ref of SQL-Server Join, Inner Join, Left Outer Join, Right Outer Join, Full Outer Join, in SQL-Server 2005:
- WHERE and HAVING clause in Microsoft SQL-Server
- DDL Trigger in SQL-Server 2005 for Create table, alter table, drop table, create procedure, alter procedure, drop procedure etc.
- Installation of Silverlight for Visual Studio 2008 and NET Framework 3.5 along with small example:
- Complex Aggregate Function example in SQL-Server 2005 with SubQuery:
- CROSS APPLY and OUTER APPLY clause in SQL-SERVER 2005
- Delete many (multiple) records in bunch: SQL-Server 2005
SQL Hub
AD HOC Distributed Qeuries AWE option in sql server COALESCE() function in SQL-Server 2005 Common Table Expression CONTEXT_INFO(Transact SQL) correalated Subquery CTE CTE (Common Table Expression) CTP Delete-Select-Duplicate-Records email script email script in C# group by HTTP Endpoint Inner Join insert into join Left Join MDB memory management Microsoft MS SQL Server OpenDataSource Ritesh Ritesh Shah Select Select Duplicate Records session variable. SP_Configure sp_MSforeachtable SQL SQL-Server SQL-Server 2 SQL-Server 2005 SQL-Server SP1 CTP Stored Procedure subquery System.Net.Mail TCP Endpoint truncate transaction log in SQL-Server 2005 union all UPDATE USER DEFINE FUNCTION WHERE Condition XLSSQLHub Twitter
- On the way to Ahmedabad.... Still needs drive of few hours 5 days ago
- @pinaldave have peaceful sleep. Everything will be all right tomorrow 6 days ago
- Missing my computer a lot. Seems like it is a time to come back to Ahmedabad 6 days ago
- Teerth with his friend twitpic.com/9pyqn2 1 week ago
- Nothing like the food cooked by mom 1 week ago
Blog at WordPress.com. — Theme: Connections by www.vanillamist.com.
March 18, 2009 at 1:37 pm
Hello,
Can you help me ??
If you can please send on my email.
Many thanks advenced.
March 18, 2009 at 3:37 pm
Hi Abdullah,
what is your issue?
February 9, 2010 at 9:37 pm
Hey Ritesh, Dharmesh here….
I have problem in sql 2008. We did create a link server with MS access using server name cocsrv6. And we did develop lots of report over their. Now we did change our server name cocsrv6 to cocsrv8. If we run report we are getting error that we can not able to use cocsrv6. what is the procedure to change server name in report.