Who is online?
154
guests and
0
members
Login
|
Register
home
articles
forums
blogs
did-you-know
quick tip
podcasts
files
login
about us
events
join us
write for us
newsletters
register
home
» search results
Search Results: Filegroups
9 results found
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
Page 1 of 1 (9 items)