Viewing 15 posts - 1 through 15 (of 68 total)
Thanks for your replies.
why I need this much of data : This is the requirement by Higher management for some analysis purpose, I know this much of data is of...
January 3, 2014 at 6:14 am
Thanks GilaMonster for your reply,
let me ask you in a different way for my better understanding,
I ran a query and it extract suppose 100K records , the query finished but...
July 8, 2013 at 7:06 am
No, that's will give the difference.
I want dates between those two like below
2013-08-01
2013-08-02
2013-08-03
2013-08-04
2013-08-05
2013-08-06
2013-08-07
2013-08-08
July 8, 2013 at 6:50 am
Total SPID's 26K
number of read from 6 to 991147
what can I conclude from it ?
July 8, 2013 at 6:43 am
you can use the below script to find when the table got accessed last time
WITH LastActivity (ObjectID, LastAction) AS
(
...
October 10, 2012 at 6:17 am
yes i agreed with n79799,
create a SQL job with Four Steps, first three will have the SSIS packages and the fourth one the command to update table. Make sure to...
September 10, 2012 at 6:34 am
why arent you using SSIS? you can easily do it using SSIS.
September 10, 2012 at 6:29 am
thanks for your reply,
let me ask in a different way.
suppose all three express/standard/developer fits application requirment
and we developed a application which keeps/calculate salary records of all the employee in...
July 23, 2012 at 9:12 am
we were using a tool called MAGIC for payroll, its a very old tool and the DB has become big now,
the vendore has now upgraded the tool so that it...
July 23, 2012 at 8:59 am
I hope below Script will Help you :
Backup all the databases
select name into #temp2 from master..sysdatabases
select 'BACKUP DATABASE ' +name+
' TO DISK = N''\\192.168.23.80\Backup\VITAS2SQLA_BACKUPS\Reporting server backup\'+name+'.bak'''+
' WITH...
April 13, 2012 at 9:40 am
This needs to be done at MYSQL server end, i never worked on MYSQL so cannot tell you how to create user or give permission at MYSQL. In my case...
February 17, 2012 at 3:19 am
the USerid and password you are using to connect to Mysql dont have appropriate permission
February 17, 2012 at 3:09 am
Thanks Again for your reply, i will try this also.
but i did it other way, i created a batch file and use that batch file in SQL JOb and all...
November 23, 2011 at 6:58 am
Viewing 15 posts - 1 through 15 (of 68 total)