Just wondering, How you are migrating the login credentials... please post us your experience. Cheers, Venkatesan Prabu .J...
guessing there is hardware compatibility issue between your processor and RAM. Cheers, Venkatesan Prabu .Jhttp://venkattechnicalblog.blogspot.com/
dbcc log ('master',3) will help you to read the log file. Check my detailed article on this....
Hi, Hope, you have taken the backup properly with out any errors. Whether the user have enough access to restore the database. Check for any...
Why can't you think about DDL Triggers/DML Triggers (Magic tables)? You can track the changes by loading it in another table.. Cheers, Venkatesan...
A very interesting discussion, If you are fed up with you work. Why can't you think about different technologies. Oracle DBA or DBA in open source...
Hi, I faced a similar kind of scenario, 1. Changed the database property to Simple recovery model. 2. Used SSIS, Inserted the data into the second...
Hope, the below article will be useful for you, http://www.sql-server-performance.com/software/review/dba_dashboard_p1.aspx Cheers, Venkatesan Prabu...
Hope the below query will be useful, DROP TABLE venkat_table CREATE TABLE venkat_table(id INT,date DATETIME ,HalfHourdate DATETIME)INSERT INTO...
I didnt see any issue in your program. SQL should react properly as usual. Cheers, Venkatesan Prabu .J http://venkattechnicalblog.blogspot.com
Check my blog article on defaults, http://venkattechnicalblog.blogspot.com/2010/04/defaults-in-sql-server.html Cheers, Venkatesan Prabu .J
Hi, You can use row_number/rank/denserank function in SQL Server to get the largest salary...
Hi All, I am having a very urgent issue. Someone have shut down the SQL Server database and I need to find out who have done it. 1. Checked...
If you want fetch the record with the condition id = 1 and col = 'test' and id = 2 and col = 'test1' Then in that case, ITS CORRECT. Cheers,...
Its' advisable to have SQL authentication which is more flexible/handy. Anyway, if your requirement is windows authentication. Check my article in my...
Take a backup of your log files and database, use DBCC shrinkfile option to shrink your log file. Cheers, Venkatesan Prabu .J...
I have written an article on Index covering, http://venkattechnicalblog.blogspot.com/2010/02/covering-index-in-sql-server.html Placing an index on...
This indicates your database connectivity or session is getting expired or closed frequently. As specified by experts, check your database option....
SELECT * FROM Table1 WHERE columna NOT LIKE '[A-Z]%' Cheers, Venkatesan Prabu .J
Thanks to all. I have learnt something today. Cheers, Venkatesan Prabu .J
Separate names with a comma.
