Sir ji this is MYSQL(open source) not my sql (instance) [:D] Frank I posted it here cos this more of generic issue not RDBMS specific.... Although...
Hi Friends, Yesterday we had a deadlock in one of our application which was running on mysql (Live since last 7 year and this was the first time this...
while generating the script you have once option called script database users and object level permissions. try this. Rohit
See this is a very open question and whenevr this sort of questions been asked in an interview.... then they want to judge your attitude and your...
Hi, I'll suggest you to go back and check the indexes of the table schema... I found a very interesting article on deadlocking issues....
Hi, You can export records using data export import wizard and it will give ou two options either export all or write a query to select the data....
Actually we've a server with almost 2-3 db's 250GB+, 3 db's 150-200GB and close to 15 db's between 50-120GB and server configuration is below HPDL...
I was just think abt the server configuration and db size assuming 40% growth every year. End of 1st Year: 21GB End of 2nd Year: 30GB End of 3rd...
You haven't mentioned intital size of the DB.... And how much we can expect it to grow over a period of 5 years
One more thing... whenever you try to shrink a file using tsql try below steps dbcc shrinkfile(<File Name>, NOTRUNCATE)-- this will rearrange the...
Hi Just few additions....You should keep the db in full recovery when you're taking tlog backups at regular interval and you're concerned abt point n...
Peer-to-Peer Transactional Replication can also be a good choice.
This can be a good idea if the db's are residing on same instance and one few records are inserted here n there and what about the performance impact...
Sonny,Did u tried what Arun suggested cos once the user has sa rights even if the user is a orphaned login even then it will be able to connect the...
Just trying to understand you req more clearly. You want to push data from one db to other db on the basis of the data addition to db A and same shud...
Seems that it's running under windows authentication...... Try logging in using windows authentication and use any login which is having local admin...
select id, TestRef from test where id in ( select max(id) from test where TestRef is not null group by Refid)
Welcome to forums.....what is the error message you're getting??Are sql services up???
it will be a good idea to rebuild all the indexes from this table once the old data is purged.
try this...select id, TestReffrom testwhere id in (select max(id)from testgroup by Refid)
Separate names with a comma.
