|
|
-
|
|
Recently when I was working database backups copy to external drives or whatever destination , I tried it with new solution using XCOPY command. Before that solution I was using XP_CMDSHELL command in SQL Server to copy database backup file to external ...
|
|
-
|
|
As we have seen the last post for the basic concept of tablediff utility. We learned one example using static table, now I would like to go it with SISS package and also using more tables comparison. So, lets start it with some demo objects and created ...
|
|
-
|
|
Earlier when I was working with task to sync data for two tables between to databases, I got the chance to use the tablediff.exe utility provided by SQL server. It used to compare data for two tables which have similar columns and data type structure. A...
|
|
-
|
|
Recently when 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 p...
|
|
-
|
|
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....
|
|