Tags » SQL Tips And Tricks

SQL SERVER - Detecting Corruption with Suspect Pages Table - Notes from the Field #043

: This is a new episode of Notes from the Fields series. I often hear about database corruption and I like to stay away from the problems related to corruption. 530 more words

SQL Authority

SQL SERVER - Fix Error 7202 Could not find server in sys.servers. Verify that the correct server name was specified

The other day I received following error when I tried to restore a database from one server to another server.

Msg 7202, Level 11, State 2, Line 1… 95 more words

SQL Authority

SQL Authority News - Secret Tool Box of Successful Bloggers: 52 Tips to Build a High Traffic Top Ranking Blog

When I started this blog, it was meant as a bookmark for myself for helpful tips and tricks.  Gradually, it grew into a blog that others were reading and commenting on.   627 more words

SQL Authority

SQL SERVER - How to See Active SQL Server Connections For Database

Another question received via email -

“How do I I know which user is connected to my database with how many connection?”

Here is the script which will give us answer to the question.

34 more words
SQL Authority

Developer's Life - Summary of Superhero Articles

Earlier this year, I wrote an article series where I talked about developer’s life and compared it with Superhero. I have got amazing response to this series and I have been receiving quite a lots of email suggesting that I should write more blog post about them. 992 more words

SQL Authority

SQL SERVER - How to Force New Cardinality Estimation or Old Cardinality Estimation

After reading my initial two blog posts on New Cardinality Estimation, I received quite a few questions. Once I receive this question, I felt I should have clarified it earlier few things when I started to write about cardinality. 359 more words

SQL Authority