Viewing 15 posts - 856 through 870 (of 2,463 total)
@sanket why tuesday full back which is not there (for arcserve )
see
I also have a daily direct backup of database via arcserve SQL agent to tape at 11pm:
Monday to Saturday...
November 7, 2012 at 3:31 am
Why you have used here where 1=1
November 7, 2012 at 3:26 am
poratips (11/6/2012)
I have another situation that my developer wants some tables from Prodction DB server to their desktop m/c.
We have already sql express installed and Database and tables...
November 7, 2012 at 1:09 am
poratips (11/4/2012)
Thanks Jeff.When i do again Database Refresh on a By Weekly or Monthly, so i need to follow the same steps or is it any other approach or method?
...
November 5, 2012 at 4:00 am
Any index on FiledDate OR FieldDescr column ? if not then create tow separate indexes.
November 5, 2012 at 3:21 am
Saravanan_tvr (11/4/2012)
Most of the MS prodcuts are keeping [uniqueidentifier] as primary keyPlease let me know, what motives is in?
just for security prospects .. so that nobody can identify...
November 5, 2012 at 3:16 am
arnipetursson (11/1/2012)
Since you are going to 2008, you should be using backup compression by default.
i read somewhere that compressed backups take cmparatively high CPU (from normal backup files) during...
November 5, 2012 at 3:05 am
what exactly do you mean by syncing ? drop and then create on destination side ?
additionally here u need to do some brick work to create some script which will...
November 5, 2012 at 1:00 am
harri.reddy (11/2/2012)
when i am using ssis package ,its gives me error
Paste the error here
November 5, 2012 at 12:46 am
declare @a int=1
declare @lsql nvarchar(300)
set @lsql = ''
while @a<2056
begin
set @lsql = ''
set @lsql = 'create nonclustered index testindex_' + cast (@a as...
November 5, 2012 at 12:29 am
mohsen.bahrzadeh (11/5/2012)
i want paging result data but i dont know how to do paging.please help me. thanks all.
What exactly do you want here ?
November 5, 2012 at 12:19 am
vinu512 (10/19/2012)
So, please guys.....any other suggestions of how I could get this to work??
for the time begin you can test the SSIS package manually . see if it get blocking...
October 26, 2012 at 9:21 am
GilaMonster (10/26/2012)
That's doubly wrong, because EXISTS with correlated subqueries does not perform equally with joins, it's usually very, very slightly better (and actually they're not even equivalent query forms)
Good learning...
October 26, 2012 at 9:01 am
Raymond van Laake (10/26/2012)
October 26, 2012 at 8:52 am
set the profiler trace see if it helps
October 26, 2012 at 1:26 am
Viewing 15 posts - 856 through 870 (of 2,463 total)