Hello Experts, From past few days the Log reader agent of one of my databases(Simple Recover) is scanning the transaction log records and replication...
Hi Experts, I have a table which stores domain and its url s .All the urls in the table are distinct.I have a column which stores md5 hash of that...
I have table say table_A having many columns and millions of rows.There are two columns customerid,date on which index is created.I have a procedure...
Recently I created a partitioned table having day wise partition.I populated the table with some dummy data for 2-3 days.As I was testing I truncated...
I had configured logshipping on our production databases.And all the jobs(restore/copy/backup/alert) were running fine on both primary and secondary...
Recently I encountered this wait type on our production servers.The command column in sys.processes was KILLED/ROLLBACK.And this process was blocking...
Hii I was just reading an article about DDL triggers on MSDN. I created a trigger on my test server CREATE TRIGGER DDL_TRIGGER_1 ON DATABASE FOR...
Hii , I have been reading about contained databases on MSDN and I read on Aaron Bertands blog that you can connect to contained database by creating...
hii I have been reading about Autotruncate mode in SQL server. I found that SQL server truncates the log in 2 conditions. 1)When recovery model is...
Hii I have a requirement in which files will get copied from various FTP location s.The problem is my FTP servername/username and password are...
Separate names with a comma.
