Displaying posts published in

July 2013

Configure IIS 8.0 Log to SQL Server

Configure IIS 8.0 Log to SQL Server. Before a months I had written a blog to insert IIS logs from log file to SQL Server using log parser tool. I have configured IIS logs direct to SQL Serve instance by setting config files and using ODBC logging. Step1 : Need to create one database and IISLog Table. [...]

Transfer IIS log setting from SQL Server Logs to Custom Logs

Transfer IIS log setting from SQL Server Logs to Custom Logs. In my last blog i have configured IIS Logs to SQL Server but what should happen when SQL Server Service is down or Database is not available? SQL Server DownTime It can be happen that your SQL Server goes down or somebody stopped SQL [...]

Configure IIS 8.0 on Windows Server 2012

Configure IIS 8.0 on Windows Server 2012. Basically I am writing a blog on SQL Server Administration and SQL Server Integration service but this time my boss assigned me a different task “To configure IIS on windows server 2012″. Latter on we have decided that we will capture IISLog directly to the SQL Server Database [...]

Script to Remove Sysmail_mailitems History

Script to Remove Sysmail_mailitems History. I am getting a space issue with my system data file drive, meanwhile I have checked the size of database and I found MSDB database contains 32 GB of data. I am shocked by this information and I have eagerly checked the size of particular table and I found  ”dbo.sysmail_mailitems” table contains [...]

Partition Existing Replicated Table

Partition Existing Replicated Table. To create partition in existing replicated table you must have to remove article from replication. The reason is, to create partiiton in existing table you must have to recreate primary key and you can’t recreate primary key replicated table. so, remove table from replication is first step. Note : Before you [...]

Remove Article From Replication

Remove Article From Replication In transnational, replication you have to remove article from Subscription list and drop an Article. Step1 : Remove article from subscription. Step2 : Drop article. Step3 : Refresh Subscription. Step4 : Start snapshot sgent in replication to apply changes in snapshot. –> Replication Monitor. –> Expand Publisher and select Subscription. –> Goto [...]

Add Partitioned Table in Replication

Add Partitioned Table in Replication. Step1 : Create Partition Table. Step2 : Script to add Partition Table in existing Replication. Step3 : Refresh Subscription. Step4 : Start snapshot sgent in replication to apply changes in snapshot. –> Replication Monitor. –> Expand Publisher and select Subscription. –> Goto Agent Tab. –> Right click on Snaphot and [...]

Script to Partition in Existing Table in SQL Server

Partition in Existing Table in SQL Server. Step1 : Create Multiple File Group Database. Step2 : Create Simple Table with out partition. Step3 : Insert sample data into table with out partition. Currently we have created simple table without partition and now the step starts to create partition in existing table. Step4 : Create partition function. [...]

Partition Table in SQL Server

Partition Table in SQL Server To create table partition your database must need Multple file group database to apply Table partition. Step1 : Create Multiple Filegroup Database. Step2 : Create Partition Function to define partition block . here, i have created two partition block See Values(10) means first partition contains 1-10 and second partition contains [...]

Script to get Table Partition information

Script to get Table Partition information. This script gives you Table Partition information with Partition Number, Scheme Name and Function Name. Regards, Nirav Gajjar