|
|
-
|
|
We can easily restrict the access of database using Logins but to hide it's tough.
SQL Server has feature to hide all databases from SSMS.
To do that follow the steps.
1. Create or Go to Property of existing Login.
2. Move to Securable tab.
3. In per...
|
|
-
|
|
hi friends
To get a list of all sql server collations we can execute following system function.
This will return name and description of various collations
**select * from fn_helpcollations()**
...
|
|
-
|
|
Today i studied an interesting thing related to GO statment
See in the following queries executed .***The batch preceding GO will execute the specified number of times***.
create table test( id int not null identity (1, 1) primary key)
go
...
|
|
-
|
|
While update,Delete,Insert, if need to send modified/deleted records information back to caller(asp.net or any other client for that matter), use OUTPUT clause in query as follows.
DELETE dbo.TableName
OUTPUT DELETED.*;
...
|
|
-
|
|
Until now, I always believed the maximum number of partitions a table could have was 1,000. This is correct for 32-bit SQL Server. In 64-bit, however, up to 15,000 are permissable....
|
|
-
|
|
It's the point where the number of rows returned is "no longer selective enough". SQL Server chooses NOT to use the nonclustered index to look up the corresponding data rows and instead performs a table scan....
|
|
-
|
|
Today I came across the problem.
When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP.
The moment I am getting the error "An INSERT EXEC statement cannot be nested."
To resolve the Issue
Do the steps.
**To ...
|
|
-
|
|
It is very small point but developers are unaware of it that's why i am sharing it here.
Len function in sql server returns total no of characters in any string which is passed to it as a parameter,but it excludes trailing blanks
example
select ...
|
|
-
|
|
I just learnt that, based on the frequency of data access and type of storage, there are three different categories of data.
**Hot Data**: Data that is frequently accessed and stored on high speed storage/disks.
**Warm Data**: Data that is moderat...
|
|
-
|
|
ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($)
after getting one bug i learn this from bol...
|
|