Any Suggestion Experts!
Hi. I need you help in writing SSRS Expression which counts the Total Values from Start of Month(Date) and GetDate. For Example: =SUM(...
Thanks a lot of the reply Madhivanan !
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:...
Thanks for your reply! The problem is that in my table i have data for many servers each with having various drives. So i have to know the server...
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...
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...
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...
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...
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...
It is Granting the Connect Permissions to User XYZ.
EXEC master..sp_help_revlogin in the source server and save the output to run on the target server.
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....
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...
Thanks !! [H]
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...
Franklin, I use these when i have to back up log in case Log file grows too big.,I use one of the option Truncate_Only or NoLog Backup log...
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...
You can take the Full Back but 1st Disable the logshipping Jobs for that Particular Databases and after the Full backup Completed, you can enable...
Separate names with a comma.
