|
|
-
nilesh.argade Commented 2 Months ago through Blogs
To transfer large amount of data from prod to test -
1. Disable indexes, constraints etc.
2. Stop SQL agent jobs.
3. Change database recovery model to **simple**
4. Restrict database access to **single user** to avoid CPU\ memory or disk usage e...
|
-
nilesh.argade Liked 9 Months ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
nilesh.argade Commented 9 Months ago through Blogs
I recalled my memory in the days of Visual Basic6 and trying to share my experience.
I always use a statement ADODB.Recordser.Fields("empName") .Value **& ""**
to handle NULL values efficiently.
I have seen people handle it like -
If isnull(AD...
|
-
nilesh.argade Answered 2 Years ago through Quizzes
Sharing some thoughts -
1. Try to **re-produce the issue** on different server using similar configuration(assuming that there is Production, QA and Dev box), this will advise where problem does persist? it is with query or something else.
2. **C...
|
-
nilesh.argade Answered 2 Years ago through Quizzes
Hello,
Based on my experience I am giving feedback on “Temp table and Table Variable”
1. Temp Table (Global or Local) -
a. When large data set to be stored.
b. To take advantage of indexes
c. Join multiple times.
d. Store result ...
|