Search Results | SQL Server Performance Forums

Adding Values between Two Dates - SSRS Expressions

Thread by: Arman, Jul 11, 2012, 1 replies, in forum: ALL SQL SERVER QUESTIONS

Hi. I need you help in writing SSRS Expression which counts the Total Values from Start of Month(Date) and GetDate. For Example: =SUM(...

Getting Weeks Start Dates for a Given Month.

Thread by: Arman, Jul 10, 2012, 2 replies, in forum: ALL SQL SERVER QUESTIONS

Hello, I need some help from the experts to get the Start date for each week in a given month. For example: Month = June Week Started:...

TSQL - Avg disk utalization report from a database.

Thread by: Arman, Mar 1, 2012, 3 replies, in forum: ALL SQL SERVER QUESTIONS

All, I have a date in my table which contains the disk utilization data for each server and for each disk.As i put the sample below. Now i am trying...

SSIS Time Expression

Thread by: Arman, Nov 23, 2011, 1 replies, in forum: SQL Server 2008 Integration Services

All, I am working on creating an ssis package to move the data from one source to multiple destinations depending on Dates and Time for diffrent...

Source Location From a Table.

Thread by: Arman, Jun 15, 2011, 0 replies, in forum: SQL Server 2008 Integration Services

All, I need your help in creating one SSIS package. Below is the Detail : 1. Copy the data from source to a destination table base of some...

Restore Issue :

Thread by: Arman, Mar 24, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi, On my SQL SERVER 2005 /SP2, I took a 70Gb backup to diffrent 20 files to for copying it to DRP Server which is almost 3000 Miles from prod...

dbcc indexdefrag...Need Help

Thread by: Arman, Mar 19, 2008, 2 replies, in forum: Performance Tuning for DBAs

Last night i run DBCC INDEXDEFRAG and after few hours it complelety fill the log file, size of log file was about 30GB. Any idea that what happened...

Scan Density is same after reindexing

Thread by: Arman, Feb 27, 2008, 2 replies, in forum: Performance Tuning for DBAs

Hi All, I want to know that why the dbcc showcontig is giving me the same results after running dbcc reindex. I have sql server 2000 with sp4....

Index Size

Thread by: Arman, Feb 22, 2008, 1 replies, in forum: Performance Tuning for DBAs

Hi All, Can some one help me that how can i find the size the index. Also Can some one have the script that will give me all the indexes and their...

When to Rebuild indexes in SQL server 2000

Thread by: Arman, Feb 21, 2008, 1 replies, in forum: Performance Tuning for DBAs

Hi, I am a new into sql field. I want to know that when we have to decide to rebuild indexes. What kind of cammands i have to run and how to analyze...

When to rebuild Indexes in sql server 20000

Thread by: Arman, Feb 21, 2008, 3 replies, in forum: The Lighter Side of Being a DBA

Hi, I am a new into sql field. I want to know that when we have to decide to rebuild indexes. What kind of cammands i have to run and how to analyze...

diffence b/t Truncate_Only & No_log

Thread by: Arman, Dec 10, 2007, 3 replies, in forum: Getting Started

Hi , what is the diffrence between Truncate_Only & No_log when you are Shrinking the Log file. I know that NO_LOG option Truncate the Log but doesnot...

How to understand Performance issues.

Thread by: Arman, Nov 26, 2007, 4 replies, in forum: Getting Started

Hi All,I want or badly need to learn Performace Tunning. Any Help that from where I should start and what are the steps i should fallow to learn and...

Creare a DTS Package that runs on all the servers

Thread by: Arman, Nov 25, 2007, 1 replies, in forum: SQL Server DTS-Related Questions

Hi All, I have a Backup Store Procedure (which will give me latest backup history in one server's Databases )which i want to run a on all the servers...

Creare a DTS Package that runs on all the servers

Thread by: Arman, Nov 25, 2007, 1 replies, in forum: Getting Started

Hi All, I have a Backup Store Procedure (which will give me latest backup history in one server's Databases )which i want to run a on all the servers...