SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• convert a coloumn datatype ntext to varchar

  How to convert a coloumn datatype ntext to varchar . The table have around 1 lack rows.

  charipg

  1 replies

  13 years ago

  By: nigelrivett

• move db files to another directory

  I would like to move database files to another drive. I used sql like below: ALTER DATABASE Z_20090…

  sqlfriend

  15 replies

  13 years ago

  By: sqlfriend

• RML files

  Hi Experts, Anyone have any idea what a .RML file is i can hundreds of file in hundreds of folder i…

  VastSQL

  7 replies

  13 years ago

  By: VastSQL

• Finding Available free space from the Shrink File window in mgt studio sql 2008

  Hi how to do you find the available free space when you right click the db > select tasks > …

  JP10

  3 replies

  13 years ago

  By: Michael Valentine Jones

• Performance and Security Issues with Database Mail on the 2008 R2 server

  Hello -- We are planning on implementing Database Mail on our server with the initial intention of …

  kaplan71

  1 replies

  13 years ago

  By: Chris Harshman

• Modifying file groups or moving files

  I have a table with multiple partitions and multiple file groups per partition. is there a simple w…

  Bill (DBAOnTheGo)

  6 replies

  13 years ago

  By: Bill (DBAOnTheGo)

• backup files get smaller, what could be the reason

  I am just reading from a blog and use a query to check database backup file growth. I used the quer…

  sqlfriend

  6 replies

  13 years ago

  By: sqlfriend

• Improve performance for fetching records from Data warehouse tables having records in billions

  Dear All, Hi! I recently worked on a Data warehouse server which has performance issues. When I di…

  bharat sethi

  1 replies

  13 years ago

  By: TheMaskedDBA

• SSRS - Changing Service to use Domain Account

  To the best of my knowledge I'm following the correct procedure for changing the SQL Reporting Serv…

  rhunt

  2 replies

  13 years ago

  By: intp

• Access to the path '$RECHCLE.BIN' is denied.

  Hi, I have a long running SSIS package running on SQL Server 2008 R2 SP1 and hosted on a Windows Se…

  MikeRen

  1 replies

  13 years ago

  By: MikeRen

• Attach to existing database?

  We are moving Vendor's database to a new SQL cluster server. It's Sophos Antivirus software. Suppor…

  RVO

  4 replies

  13 years ago

  By: Bhuvnesh

• Not able to connect db user in standby database

  For the Reporting purpose, we need to use another server standby database and logshipping have been…

  SQL Galaxy

  9 replies

  13 years ago

  By: SQL Galaxy

• Track databases files growth rate.

  As a DBA I often need to watch SQL server disk space. I got alerts then I request more from network…

  sqlfriend

  5 replies

  13 years ago

  By: Chris Becker

• Big log File

  Hi all, I would what you recomend to do that i can limit the size of my log file that have 98Gb... …

  pedro.j.manuel

  4 replies

  13 years ago

  By: Chris Becker

• database log file

  If a database is setup to readonly and in simple recovery mode. Will the log file grow or not? than…

  sqlfriend

  6 replies

  13 years ago

  By: sqlfriend