Search Results: Filegroups

• 
  SQL Server: FileGroups?

  SQL Server maps a database over a set of operating-system files. Data and log information are never mixed in the same file, and individual files are used only by one database. The use of Filegroup is limited to Data Files only. Database objects and files

  Author:  Sarabpreet Anand     Date: 6/28/2011     Section: Article

  tags : create object in another filegroup, data placement control, datafile, Filegroups, secondary filegroup
• 
  SQL Server: When to create Multiple Files & Multiple Filegroups for a Database?

  SQL Server maps a database over a set of operating-system files. Data and log information are never mixed in the same file, and individual files are used only by one database. One DB can have multiple filegroups and\or multiple files in a filegroup. The u

  Author:  Sarabpreet Anand     Date: 6/23/2011     Section: Blog

  tags : File placement control, Files, Multiple Filegroups
• 
  SQL Server: Create your objects on your desired Filegroups and validate the same

  Hi Friends, To get better understanding of Filegroups and to know how to create and associate an object to a filegroup read my latest article on SQLServerGeeks.com @ http://www.sqlservergeeks.com/articles/sql-server-bi/33/filegroups It also shows to a way

  Author:  Sarabpreet Anand     Date: 6/28/2011     Section: Blog

  tags : about Filegroup, data placement control
• 
  Filegroups in RAID 5

  Hello All, I have a server having two partition(excpet windows OS partition) , each having 17.5 TB space and RAID 5 is implemented and one partition(d: or e:) resides on multiple disks. In my project majority of queries having multiple joins, I have obser

  Author:  Naveen Naveen     Date: 9/21/2011     Section: Forum

  tags : filegroups, RAID5
• 
  SQL Server – DBCC CHECKDB

  Hello Folks, You might have heard about DBCC. If not, I am going to give you some heads up: DBCC Commands stands for Database Console Commands. They are being used for: Checking database integrity Performing Maintenance Operations on databases, tables, in

  Author:  Piyush Bajaj     Date: 10/20/2011     Section: Blog

  tags : DBCC CHECKDB, SQL Server, What is DBCC CHECKDB
• 
  Fastest way to copy tables from one database to another

  Hello Sachin, Thanks for your reply but I am still getting same error. I am new to DBA activities, hope giving steps in detail will help you to look into problem. --Steps I have followed: --Step-1) Create a database(test) with two filegroups: USE [master]

  Author:  Naveen Naveen     Date: 7/27/2011     Section: Forum
• 
  Fastest way to copy tables from one database to another

  I want to copy some tables from one database to another in sql server. I am looking for fastest way because I have to copy many tables and and each table contains millions of data. I want to utilize back up and restore facility of SQL Server. If I keep se

  Author:  Naveen Naveen     Date: 7/26/2011     Section: Forum

  tags : back up, filegroups, restore
• 
  Filegroups in RAID 5

  How can I ensure that if I keep filegroups on similer partition(d: or e:) they resides on multiple disks Depends on the SAN configuration some distribute the LUNs across multiple spindles & share the spindles between multiple LUN while others give the

  Author:  yusuf yusuf     Date: 9/22/2011     Section: Forum
• 
  SQL Server: Use Powershell to Move Indexes to New File group

  Recently I was involved in a project where in non-clustered indexes were to be moved to a different file group for the sake of performance benefit. It has to be done for multiple databases. I came up with a powershell script to do the same. An index can b

  Author:  Ahmad Osama     Date: 3/20/2013     Section: Blog

  tags : drop_Existing, filegroups, indexes, PowerShell, Powershell scripting