Although it was a rainy day so many attendees were there to participate SQL Server Universe Monthly User Group Meeting. At the beginning Dinesh’s TV interview was on the screen until the meeting begins. And then we had 3 sessions one on Data migration to Dynamics, one on execution plan myths, and last one was about Paging Results in SQL ...
Before few weeks I got a book from Oreilly Blogger Review program to review a book. I took enough time to read this book. This book covers most of the new trends and features in SQL Server 2012 with good explanation. I was addicted to the first chapter to get to know about the SQL Server Data Tools. Because previously ...
Before few weeks I got a book from Oreilly Blogger Review program to review a book. I took enough time to read this book. This book covers most of the new trends and features in SQL Server 2012 with good explanation. I was addicted to the first chapter to get to know about the SQL Server Data Tools. Because previously ...
Before few weeks I got a book from Oreilly Blogger Review program to review a book. I took enough time to read this book. This book covers most of the new trends and features in SQL Server 2012 with good explanation. I was addicted to first chapter to get to know about the SQL Server Data Tools. Because previously I ...
At the beginning of this week, I got a task from Susantha to modify a stored procedure. After the modification, I had to test to compare the result sets before modification and after modification. That procedure only returns a data table. So I had so many test data on another table. Then I wrote a script to go through the ...
At the beginning of this week, I got a task from Susantha to modify a stored procedure. After the modification, I had to test to compare the result sets before modification and after modification. That procedure only returns a data table. So I had so many test data on another table. Then I wrote a script to go through the ...
In the beginning of this week I got a task from Susantha to modify a stored procedure. After the modification I had to test to compare the result sets before modification and after modification. That procedure only returns a data table. So I had so many test data on another table. Then I wrote a script to go through the ...
I have seen in many video tutorials they have different tabs for Editor, Results, Messages and Execution Plans. And they are stretched over the complete screen. Most of the times need to resize the result area to see our results. Actually, it's annoying me. Then I noticed in one of Paul Randal’s video he uses Separate tabs for Results editor ...
I have seen in many video tutorials they have different tabs for Editor, Results, Messages and Execution Plans. And they are stretched over the complete screen. Most of the times need to resize the result area to see our results. Actually, it’s annoying me. Then I noticed in one of Paul Randal’s video he uses Separate tabs for Results editor ...
I got a few questions to answer quickly in last week just like a test. Then I suddenly answered then after that I tried to find correct answers to them. I found answers for most of them. And one of them was there as it was. A Windows server has 32 GB of memory and dedicated for SQL Server database. ...
I got a few questions to answer quickly in last week just like a test. Then I suddenly answered then after that I tried to find correct answers to them. I found answers for most of them. And one of them was there as it was. A Windows server has 32 GB of memory and dedicated for SQL Server database. ...