|
|
-
|
|
It is been long time due to certain critical issues and ofcourse the QUIZ in beyond relational,I could not get in touch with you all.
Few words about QUIZ, It was a nice exeperience for me to answer the question. I have learnt a lot participating the QUIZ competition. I would recommand every one t......
|
|
-
|
|
This post is really inspired by Nakul's wonderful post: http://beyondrelational.com/blogs/nakul/archive/2011/12/29/sql-server-t-sql-different-ways-to-generate-a-comma-separated-string-from-a-table.aspx
However, Whenever I faced a situation to concatenate the values in a table there was always a req......
|
|
-
|
|
LOGBUFFER is one among the IO Wait types in SQL server. This wait type is one of the very rare wait type. As I described earlier, it has got relation with WRITELOG. Just to iterate the same, please look at the operations when transaction happens(also look at the WRITELOG wait type explanation.(http:......
|
|
-
|
|
In replication, we need to add objects as articles to replicate the data to different server.The important point is here that if we have any reference(foreign keys) associated with the articles(tables choosen to be replicated), then we need to consider the parant table also to add as article, Or the......
|
|
-
|
|
ASYNC_NETWORK_IO, as the name suggests it is a wait type associated with the network. Infact it deals with the network buffers.
Does it mean it is completely a network issue? - Never, it might be a network issue or not. However we need to check our end to investigate and solve the underlying proble......
|
|
-
|
|
PREEMPTIVE_XXX wait types are basically associated with the worker thread outside SQL engine. These wait types have been newly introduced in SQL server 2008. (SQL server will not have any control over the work.) Thank you to SQL server team introducing these wait types in SQL server 2008 to nail do......
|
|
-
|
|
Today Am going to explain something about the ring buffer which is an internal structure in SQL server that captures various information like security errors, any kind of exceptions, scheduler information, resource monitor information etc.
How did I reach to RING BUFFER all on a sudden is nothing b......
|
|
-
|
|
When a transaction happens, say for an example data is bening inserted, there are mainly two things happens:
1. data page in the buffer cache is updated.
2. Data is written to the log cache.(This is to ensure the ACID property incase of any rollback.)
When the transaction is in COMMITTED phase......
|
|
-
|
|
These wait types are indicative of a shortage of memory objects.This special type of wait occurs when a task is waiting for a thread-safe memory object. The wait time might increase when there is contention caused by multiple tasks trying to allocate memory from the same memory object.This wait type......
|
|
-
|
|
Analysis of waitstats is the first step that I would take with any performance tuning activities on a system. Thats important because it is an easy and efficient way to understand the issues with a system at a very high level. There are many different wait types assocaited in SQL server which gives ......
|
|