Today is July 30 and I am very happy; it’s my Birthday, celebration time!!! The most common question I receive on my every birthday is -what are my plans for birthday. Let me share my plans here today. Additionally, if you are interested to know when SQL Server was born read my post SQLAuthority News – Author BirthDay – SQL Server Birthday.
My first plan is that I am going to take a break from blogging on anything technical today and spend more time with my family.
Let me tell you about my second plan. I am very much pleased and encouraged with active participation from many of you on this blog. I have received so far more than 10s of thousands of comments on my blog. These comments are open for you all to read and you can use them in any fashion that can help you out. Without good participation there is no life in any community, whether it is offline or online.
For the same reason, I have introduced Top 7 Commenters section in the side bar of SQLAuthority.com. There are many active users who have been participating for a long time. One of them I just recognized is Imran Mohammed. This SQL Expert has been extremely helpful to the community and has been providing comprehensive answers to hundreds of questions. Hats Off to you Imran! I totally appreciate your knowledge and dedication to SQL community. Without passion and love toward helping community, this is absolutely not possible.
You can subscribe to SQLAuthority.com feed, which will display all the new posts of my blog as they are published.
You can subscribe to SQLAuthority.com comments, which will show all the new comments posted on the blog as they are published.
If you prefer to receive SQLAuthority.com articles in email, you will get all the fresh posts in email.
There is no automated feature for top commenters where I host, so I will have to calculate this manually. I will keep it updated on weekly basis. Every week we will see new names there. First column is number of post, and second column is number name with link to experts website or blog or email.
Every day I receive a couple of emails about starting a forum on SQLAuthority.com. I do plan to start the forum in future. Currently, there are plenty of very good forums on the web. SQLAuthority.com is a blog and below every blog post there is a discussion related to the subject discussed in the blog post.
SQLAuthority.com is all about community and people who are passionate about SQL. Everyone is welcome to participate here. There are many ways to participate.
- Discussing blog post
- Helping user who have posted their issues on blog
- Asking questions
- Writing Guest Post
- Submitting useful SQL Scripts
- Reviewing any Microsoft-related products
- Reviewing Books
Let me know if you have any other useful and interesting suggestions on how I can involve YOU more in my efforts to take SQL community to the next level.
If you are interested in participating in volunteer program do send me email at pinal ‘at’ SQLAuthority.com and we can discuss something out.
Reference : Pinal Dave (https://blog.sqlauthority.com)
37 Comments. Leave new
Hi Pinal sir ,
how send message to you,
how to add this blog to me ,
i have new learner in sqlserverDba.
thanks sir,
harishkumar.M
hi pinal sir,
1) how to find out uncommitted transcation in sqlserver using Dbcc command
2)In Data base one table is Updated are not how to findout please tell me sir.
thank
harishkumar.M
@harish
DBCC OPENTRAN will show the active transactions.
I think your second question is not clear enough.
Hi jacob sir,
thank you sir ,Giving answer………………
1)IN my production server, The backup before how to find out which tables are updated (or) not ?
2) how to find out in my table or database in indexes through using DBCC command.
3) i have ten lacks records in my table that rows move to warehouse without using import&export
i want spilt my records to 1 to 100000
2)100000 to 200000
3)200000 to 300000
………….
…………
n)900000 to 100000
with using hints ,i don’t barden to my production server .
use any commands …………………………
please tell me
thank you
harishkumar.M
hi Jacob Sir,
1)IN my production server, The backup before how to find out which tables are updated (or) not ?
thank you
harishkumar. M
@harish,
Is it important to know what are the tables modified before a backup? What are you going to do with this information?
SQL Server does not give an out-of-the-box solution to this. If this information is important to your application logic, you should probably keep a timestamp column in your tables to keep track of the modifications.
You might also be able to identify this by using some of the third party tools that can read the trn log and get this info.
regards
Jacob
@harish,
There should not be any question with Jacob’s word, this should be final as long as SQL Server and XML concern. I am agree with him too. There is no native way to do so, however you can have ApexSQL tool which can read your log file and can give you information, if you don’t want to buy 3rd party tool than you have to go for Audit trail and creating audit trail for all tables manually, is really big and tedious process and it can also reduce the performance.
If you can explain your need further, we may be able to give you some other workaround.
Regards,
Ritesh Shah
Hi jacob sir,
1) how to find out in my table or database in indexes through using DBCC command.
2) i have 30 lacks records in my table that rows move to warehouse without using import&export
i want spilt my records to 1 to 100000 using time period.
1)100000 to 200000
2)200000 to 300000
………….
…………
n)2900000 to 3000000
with using hints ,i don’t barden to my production server when i move to where house .using Bcp -b this command this ………………………….
use any commands …………………………
please tell me sir
Thank you
harishkumar.M
Hi pinal sir,
1)how to my Identity column RESEED
ex: EMPid 1000
………5000
in this time some identity column are deleted .
identity column order is not good .
so, how to reseed to start newly
Thankyou
harishkumar.M
You are a very good SQL server expert .
Thanks a lot for your nice article. But I had difficulty navigating through your website because I kept getting 502 bad gateway error. Just thought to let you know.
Currently you show TOP 5 commentators with comment count
But the count doesn’t seem to be updated
Also is dynamically changed based on the comments or are you running an update?
Happy birthday! Thanks for your great contribution!