|
|
-
|
|
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,
......
|
|
-
|
|
I have come across many times in a situation that I need to check the existence of a procedure in multiple databases in a given server.
Hope, this would help you guys too...
Create Proc SQLZealot_FindProcInDBs (@ProcName Varchar(500))
As
BEGIN
Create Table #TempDBNames (ID int identity(1,1)......
|
|
-
|
|
In this post, am going to explain how implicit conversion would lead to a performance issues in query processing.
Implicit conversions are results of mixing various datatypes for processing. When implicit conversion happens in a query, it denotes with a “Compute Scalar”operator. A very ......
|
|
-
|
|
All of us know the basic statement of SQL as insert/update/delete.
And am sure of one thing Insert is for inserting the data and delete is for deleting the data.Both are in-place operation.
Have you ever thought What is an Update in SQL server? - Is it an in-pace operation or multi-phase(delete fo......
|
|
-
|
|
Few Days ago, we had a particular issue with Linked Server. Before I start with the issue, let me give a small outline of the enviornment.
We have two servers A and B where a data porting is happening from A to B through a Linked server.Support person has manually invoked the job from the query ana......
|
|
-
|
|
Do you think a Heap would have a Page fragmentation? As long as a heap is not logically
ordered, do you think a heap would undergo a page fragmentation???
Fragmentation happens when logical ordering is different from the physical ordering.
A heap will not have ......
|
|
-
|
|
It is always good to have a clear precise header for stored procedure for tracking and understanding the functionality implemented. The following is the one I use in my procedures.Please comment if you can add more info to the same.
/**********************************
Author :
Created Date :
Sto......
|
|
-
|
|
This is a very good question. I guess it can be a good question in interviews too.
Coming to the answer, am answering the question as two parts:
There are two types of statistics:Index stats(stats created on index) and column stats(stats created on individaul column)
1.Does rebuild index update t......
|
|
|
|