|
|
-
|
|
Recently we i was working on tuning of stored procedures and i experienced with one performance issue, that was high Logical Reads. Logical Reads? "Number of pages read from the data cache" - It occurs every time when the database engine request a pag...
|
|
-
|
|
I wrote about my previous just learned tips about covering index and will publish my future post for the detail understanding it. We should generate index statistics and index usage report periodically, so we can have more idea of the index utilization....
|
|
-
|
|
Last time I have wrote about pivoting and the next after that post describes for dynamic columns which used for pivoting. We have seen the example and the same example implemented with dynamic columns. You can read both posts which are following, 1. S...
|
|
-
|
|
We have seen example of Changing Rows to Columns Using PIVOT. Hope you liked that post and you enjoyed a lot also. As we know that we need to hard-code the values for pivoting which we have did for color values. for the values updates in table or whenev...
|
|
-
|
|
Recently while working with database move to other location , I used tsql script to move them. There are some methods to move the database files to other like detach and attach files from new location and other one is with modifying database file locati...
|
|
-
|
|
As per requirement in custom logic we need to require CTE (Common Table Expression) something like for the hierarchy, to find duplicate and remove data or for some other stuff. Recently i have used CTE within CTE for one logic and maxrecursion option as...
|
|
-
|
|
Recently i was asked by my friends to delete the files bases on number of files, not based on days. Such a way we can keep number of files every time and rest files get archived. I will give you an example here as i have three folders and want to keep different number of files in each folders only....
|
|
-
|
|
As I know database restoration is a best practice on periodically to check and verify database backup copies and issues while restoration due to some stuffs. I have wrote for the database backups as how can we perform full database backup completely and...
|
|
-
|
|
For very sensitive and secure databases, it is required to track all the activities and changes done with the database objects. And it should be very secure as well, so nobody can play with database objects....
|
|
-
|
|
During working with one logic, i got chance to work with PIVOT operation. Sometime we need do require rowdata as column in our custom logic, then we can use some temp table and then populate agreegate data in temp table. But With PIVOT w......
|
|