SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• Large objects in SQL Server

  I know large objects aren't stored in rows (e.g., varchar(max) and BLOB data). Filestream data is …

  Golfer22

  1 replies

  13 years ago

  By: Bhuvnesh

• Reorganize Index

  Dear Friends I have made a maintenance plan to reorganize index daily, but this error showed to me …

  zi

  4 replies

  13 years ago

  By: zi

• Index reorg VS rebuild, round 1

  So, I read alot of people saying Rebuild over 30% fill factor 80%! reorg under 30% only! What is th…

  Bill (DBAOnTheGo)

  10 replies

  13 years ago

  By: Bhuvnesh

• How to run A SQL Job Of Restart Of Server, SQL Server 2008 R2

  Basics: I'm running a SQL Server 2008 R2 I am trying to run a SQL job or maintenance plan on the st…

  CaliDave

  18 replies

  13 years ago

  By: CaliDave

• SQL Monitor

  Is anyone using SQL Monitor to monitor their SQL instances? Per this thread http://www.sqlserverce…

  scogeb

  7 replies

  13 years ago

  By: Steve Jones - SSC Editor

• Connect to other Server types other than DB Engine

  Hello everyone, I just installed a SQL Server 2008 R2 (10.50.2550.0) with SP1 integrated. On my loc…

  SuperJB

  2 replies

  13 years ago

  By: SuperJB

• Shall i create temp tables in production

  Hi ALL, Shall i create temp tables in production ? Is there any problem please clarity Thanks

  RK2012

  5 replies

  13 years ago

  By: Jeff Moden

• How to find allocated space and used space

  Hello Team, How to find allocated space and used space for all databases in sqlserver instance ? Is…

  RK2012

  9 replies

  13 years ago

  By: SQLRNNR

• Adding new data file to tempdb, leads to data incorrection

  In one of the tempdb blog Here is link [/url], it is stated that sometimes when we add a new fil…

  Bhuvnesh

  7 replies

  13 years ago

  By: Bhuvnesh

• Permission on reporting server

  I would like to setup a windows group of people to view reports on a SSRS report server. They can n…

  sqlfriend

  6 replies

  13 years ago

  By: MyDoggieJessie

• grant permission to view/edit/execute all stored procedure

  Is there a way to grant a user to alter, view and execute all the stored procedure in a database? …

  sqlfriend

  2 replies

  13 years ago

  By: MyDoggieJessie

• Problem with Datetime Function

  I have SP which contains function convert(varchar(12),[datetime],112) =convert(varchar(12),getdate(…

  mahesh.dasoni

  23 replies

  13 years ago

  By: GSquared

• when the database are last used

  I would like to find out some databases not used any more on a testing server. My network person as…

  sqlfriend

  3 replies

  13 years ago

  By: jyuan68

• Index Performance.

  Hi all, I search a lot for this issue but I can't realize what happen. The case is, randomly (no v…

  abitguru

  11 replies

  13 years ago

  By: TheSQLGuru

• Rowcount of the biggest table

  Hi everyone, I'm trying to find total count of rows of the biggest table of our database but the qu…

  sunny.tjk

  8 replies

  13 years ago

  By: sunny.tjk