Administering

• Topics

  Started by

  Posts

  Last post

• ROWVERSION & TIMESTAMP

  hi to all, What is the basic difference b/n rowversion & timestamp. when to use each over othe…

  SQL*

  2 replies

  17 years ago

  By: Carl Federl

• DB available space ZERO!!!

  Hi SQL Server Central peeps ... I have 2 DB's with DB available space ==> 0.00MB issue Both have 9 …

  Feeg

  4 replies

  17 years ago

  By: BU69

• Profiler tracing question

  I am trying to setup Profiler to trace a specific userid on a specific db that is doing a delete ag…

  Anonymous

  1 replies

  17 years ago

  By: ddonck

• emptying the log file and move log to other log files

  I have 3 log files and need to remove couple of log files from one of my DB in sql server 2005 and …

  sqlqueue

  1 replies

  17 years ago

  By: ddonck

• Difference between permission to connect to database engine and login

  Under status tab of sql server login properties, there are two settings 'permission to connect to d…

  Atif

  4 replies

  17 years ago

  By: abhijit.dey

• Fixing Fragmentation After Shrinking

  Despite the downside of shrinking databases, I may have to in order to free up some disk space unti…

  homebrew01

  17 replies

  17 years ago

  By: Tim Walker.

• Passing string as parameter to stored procedures

  Hi I am writing stored procedures in sql 2005 server. I want to pass string as parameter to retri…

  raveen4u

  1 replies

  17 years ago

  By: John H Marsh

• generate script for existing table in the database by using T-sql command

  Hi, generate script for existing table in the database by using T-sql command,with out using manage…

  venki_1276

  1 replies

  17 years ago

  By: John H Marsh

• Spliting Data into file groups VS Partioning

  Guys, I have a 60 million row table which I split into a file group that has 4 files. This has impr…

  am-244616

  1 replies

  17 years ago

  By: manishankar_83

• SQL Server 2005 installation paths

  I’m instaling SQL Server 2005 on production server on Advanced options page: 1.I have selected D:\…

  klnsuddu

  4 replies

  17 years ago

  By: hi_abhay78

• Track sql code on servers

  What is the best way to capture all of the code executed on my sql servers which i want to save atl…

  Tara-1044200

  4 replies

  17 years ago

  By: RBarryYoung

• Large (and growing) database administration/considerations

  I have a large database (18TB) which will keep growing around 700GB to 1TB every month. I was wonde…

  R Oliveira

  12 replies

  17 years ago

  By: GSquared

• Advice Sought: Best Practice for Separate Servers

  Looking for some guidance from the gurus here. In my company we have right now one production SQL …

  Steve S-428612

  12 replies

  17 years ago

  By: Steve S-428612

• Can we rebuild the indexes for all the share point databases in SQL Server 2005 using Maintenance plan task, Rebuild Indexes?????

  hi, We have MOSS 2007 databases in SQL Server 2055 EE ( SP3). My Question is: Can we use the Mainte…

  rambilla4

  2 replies

  17 years ago

  By: rambilla4

• adding instances and backing up system db's

  I'm looking for some best practices and also how other dba's implement names instances. We are runn…

  Mike Gray-474150

  4 replies

  17 years ago

  By: Shawn Melton