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)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy