|
|
-
|
|
Delete duplicate records from a table...
|
|
-
|
|
Sql Server 2008 onward we have the option to pass a table variable into a stored procedure and perform task with that. It has some limitation like we can not perform DML command with that variable but with the help of that we can perform DML command instead...
|
|
-
|
|
Create Short Cut for Selecting a Table...
|
|
-
|
|
This query may halp you to shift bulk Indexes to another file group....
|
|
-
|
|
Few days before i have a requirement to find out the table name which are having a specific column with a specific value throughout the database.
for that i build a query which takes and as parameter
For example : A column occurs in multiple tables in a database and we have to find out thos......
|
|
-
|
|
Before Apply Indexes on any Table's Column go through some points
1.) Table Type: If your table is very highly transactional than try to keep less indexes on that table
that doesn't mean that don't go for indexing. But for selected columns only because
indexes......
|
|
-
|
|
When you are going to choose data types for your table be careful about it because it will directly impact your query performance.
that happens due to data pages memory limitation (DATA PAGES are fundamental unit of storage that have the actual data rows of any table).
Each page has 8KB size and......
|
|
-
|
|
As we know Indexing is most important point at performance context but here I am going to discuss something which should keep in mind for performance.
Following is very simple concept of RDBMS.
Table seek is good for large tables (large No. of rows) but for the small table (few no. of rows like......
|
|