It supports split to 64 files max.
- sqlideas.comdba, 2006 - present
List your Tasks using Task List feature - SQL Server Denali
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
Working with Service Broker for single database in SQL Server
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
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
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
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
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...
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
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
sqlIdeas: Changing Rows to Columns Using PIVOT - SQL Server
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
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...
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...
Archive files based on number of files configuration in SQL Server - SSISsqlIdeasArchive files based on number of files configuration in SQL
SQLIdeas - SQL Server High Availability - Manual Failover - Paresh Praja...
Availability As we have seen SQL Server High Availability configuration and listener for same, i would like to go ahead for manual failover