Profile

Cover photo
Paresh Prajapati
Works at sqlideas.com
Attended B.E.I.T.
Lived in India
1,765 followers|1,158,332 views
AboutPostsCollectionsPhotosVideos+1's

Stream

Paresh Prajapati

Shared publicly  - 
The SQL Ideas;Towards the innovative SQL ideas;Everything about SQL and Database. Stay updated with the SQL ideas.
1

Paresh Prajapati
owner

Discussion  - 
1
Arthur Zubarev's profile photo
 
You covered only the case of reading from a table, but there are interesting moments when it comes to DML.
Add a comment...

Paresh Prajapati
owner

Discussion  - 
The SQL Ideas
sql, database, sql server, dba, sqldba, database administrator
View community
1
Add a comment...

Communities

Paresh Prajapati
owner

Discussion  - 
The index is a most important factor in the optimization and performance. Whenever we work for the query optimization, we are mostly looking for indexes, then check any other factors. Also scheduling the job for the maintenan...
1
1
Add a comment...

Paresh Prajapati

Shared publicly  - 
The SQL Ideas
sql, database, sql server, dba, sqldba, database administrator
View community
1

Paresh Prajapati

commented on a post on Blogger.
Shared publicly  - 
 
Hi D P Tripathy,

It supports split to 64 files max.
As a maintenance activity DBA need to take care of the database backups and monitoring for the same because database backups are more important in recovery.Production live databases have more sizes and because of heavily size...
1
Paresh's Collections
Communities
Work
Occupation
Database Administrator
Skills
SQL Server, Database, DBA, Database Administration
Employment
  • sqlideas.com
    dba, 2006 - present
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Previously
India - Gujarat - Ahmedabad
Contact Information
Home
Mobile
9924626601
Email
Skype
prajapatipareshm
Story
Tagline
SQL, Database, DBA, Database Administrator
Introduction
Working as Database Administrator.
Education
  • B.E.I.T.
Basic Information
Gender
Male
Looking for
Friends, Networking
Relationship
Married
Paresh Prajapati's +1's are the things they like, agree with, or want to recommend.
Code Snippets in SQL Server Denali
www.sqlideas.com

SQL Server Denali introduced one more feature which can easily and reduces our t-SQL coding. This feature is "Code Snippets". It allows to i

Agent XPs Disabled - SQL Server
www.sqlideas.com

I notified so many times by the Object Explorer when I go to check the SQL Server Agent jobs. The notification is “Agent XPs disabled”. Then

"Login failed for User" in SQL Server - Reason II
www.sqlideas.com

I hope you already read my previous post for the "Login failed for User" - Reason 1. And you have very idea on that how a user was foiled du

List your Tasks using Task List feature - SQL Server Denali
www.sqlideas.com

Problem : Sometime we need external tools to list our day to day tasks mostly when work for the SQL Server as it does not have any built in

Custom Code Snippet - SQL Server Denali
www.sqlideas.com

In previous post of code snippet, i have wrote for how code snippet is useful and how to use in query editor. It is good enhancement of quer

Working with Service Broker for single database in SQL Server
www.sqlideas.com

You may work with Service Broker in SQL Server. I am just learning Service Broker and implemented practical with an example which I evaluate

Service Broker - Conversation between Databases in SQL Server
www.sqlideas.com

Recently I have posted for Service Broker for single database in which I have explained it with table history example and it was invoked wit

New Logical functions coming in SQL Server Denali CTP3
www.sqlideas.com

As I have started to learn new functions arrived by SQL Server Denali CTP3 version and I have posted some of them. You can learn Analytical

Delete files using Ole Automation Procedures in SQL Server
www.sqlideas.com

To delete the files using Ole Automation Procedures in SQL Server we need to first enable 'Ole Automation Procedures' using sp_configure as

Stored Procedure Internal Activation in Service Broker - SQL Server
www.sqlideas.com

As we have seen earlier posts for Service Broker for single database and Service Broker between databases, we have implemented it with examp

Grouping Sets vs Native method of Group By - Performance review in SQL S...
www.sqlideas.com

Previously i have posted for the overview and usage of the Grouping Sets as how can we get the aggregate data of different group sets with G

Perform database backup using SQLCMD utility in SQL Server
www.sqlideas.com

I just went through the SQLCMD command line utility to perform database backup in SQL server where it does not have SQL agent. Below is the

Download all files through FTP in SQL Server
www.sqlideas.com

We have completed the reading of earlier methods to receive single file and receive file dynamically through the FTP in SSIS. Hope you like

sqlIdeas: Changing Rows to Columns Using PIVOT - SQL Server
www.sqlideas.com

Changing Rows to Columns Using PIVOT - SQL ServersqlIdeasChanging Rows to Columns Using PIVOT - SQL Server

sqlIdeas: Configure Listener for high availability in SQL Server 2012
www.sqlideas.com

Configure Listener for high availability in SQL Server 2012sqlIdeasConfigure Listener for high availability in SQL Server 2012

sqlIdeas: How to increase the number of characters retrieved from the se...
www.sqlideas.com

How to increase the number of characters retrieved from the server for XML data - SQL ServersqlIdeasHow to increase the number of characters

sqlIdeas: Archive files based on number of files configuration in SQL Se...
www.sqlideas.com

Archive files based on number of files configuration in SQL Server - SSISsqlIdeasArchive files based on number of files configuration in SQL

HHA Exchange
market.android.com

Schedule: View your schedule in real-time. See patient Info i.e. Care plan and Directions. Electronic Visit Verifications: Use Mobile specif

SQLIdeas - SQL Server High Availability - Manual Failover - Paresh Praja...
beyondrelational.com

Availability As we have seen SQL Server High Availability configuration and listener for same, i would like to go ahead for manual failover