INDEXING TOPIC LINK

Comments

Post a Comment

Popular posts from this blog

Package Deployment in SSIS using example

Image
http://www.learnmsbitutorials.net/package-deployment-ssis.php Introduction Hello Friends, welcome to learn #MSBI step by step I'm your #MSBI host Gurunatha S.Dogi. Little About Me : I'm one of the trainer in Questpond having more than 8 yrs of experience in #server tools, #programming and #seo. I do take trainings for freshers or an individual with 3 yrs of experience. My focus area to teach / concentrate freshers to make them comfortable in learning technology step by step. In short to make their basics strong to get started into tech world. If you want to learn #MSBI step by step then feel free to touch base with the below mentioned details. Today, In this session we will learn how to do SSIS project deployment or SSIS package deployment step wise or to deploy SSIS project into production server. SSIS Project Deployment Step by Step Deployment : Deploying is nothing but moving something from one place to another place. For example let's say dep...
Read more

Filegroups - Creating a new file group and making it the default

Image
Ref-1 https://blog.sqlauthority.com/2009/05/31/sql-server-create-multiple-filegroup-for-single-database/ https://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/07/11/881.aspx https://www.sqlshack.com/database-table-partitioning-sql-server/ https://blog.sqlauthority.com/2013/08/15/sql-server-sql-basics-what-are-filegroups-day-9-of-10/ Filegroups - Creating a new file group and making it the default There are many occaisons where you may want to use multiple filegroups, especially if dealing with large tables and fragmentation is a worry. The script below shows a complete end-to-end example of how to create a file group and mark it as the default so all newly created objects are placed on there. Note, there is nothing you can do about [PRIMARY] so if you have creation scripts or drop / recreate index scripts with [PRIMARY] in them then that data will always go on the [PRIMARY] file group. -- Create the database CREATE DATABASE te...
Read more

Complex Queries !

https://www.c-sharpcorner.com/article/most-asked-sql-queries-in-interview-questions/ Sample tables are listed to visualize the data and associate with query answers given. ==================    Consider below tables   ==================    EMPLOYEE empid   empname managerid   deptid  salary  DOB   1       emp 1       0       1       6000    1982-08-06 00:00:00.000   2       emp 2       0       5       6000    1982-07-11 00:00:00.000   3       emp 3 ...
Read more