|
|
-
|
|
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......
|
|
-
|
|
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 ......
|
|
-
|
|
How to restrict number of connections to a database Today, one of my friend at workstation asked me "How to restrict the number of users connected to a DB in a SQL server"?
Initially, my answer was as easy as to configure the user connection option to the required number using sp_configure.
sp_con......
|
|
-
|
|
The below procedure will return the size occupied by the indexes in a table. This will be helpful to measure the size before and after the maintenance activities.
Create Proc SQLZealot_FindIndexSize( @OBJECT_NAME VARCHAR(255) )
As
Begin
DECLARE @temp TABLE
(
indexID BIGINT,
......
|
|