Administering

• Topics

  Started by

  Posts

  Last post

• bulk logged insertion

  Hi Experts, 1)What happens when i insert just ten records in bulk log recovery model will it get lo…

  VastSQL

  15 replies

  8 years, 11 months ago

  By: Gail Shaw

• How to get RESTORE FILELISTONLY resultset into a table?

  Does anyone know how to populate a table with the results of RESTORE FILELISTONLY for subsequent qu…

  Leo Nosovsky

  6 replies

  8 years, 11 months ago

  By: mwest32

• Replication Error: Invalid Column

  Guys, I am getting the following error in my transaction replication with pull subscription. Comma…

  am-244616

  4 replies

  8 years, 11 months ago

  By: Benki Chendu

• Reverse Engineer sp_cursorexecute

  I have a customer with a performance issue. When I trace the session all I am getting back is a st…

  JohnnyDBA

  5 replies

  8 years, 11 months ago

  By: JohnnyDBA

• Virtual Servers - are separate drives still Best Practice in SQL 2014

  Hi, On our SQL 2012 physical server, we setup separate drives for the system, tempdb, users databas…

  meyersh

  4 replies

  8 years, 11 months ago

  By: meyersh

• Optimization of Query

  Please share the important tricks related to Optimization 1.How to decrease the logical reads of e…

  Bharat21

  3 replies

  8 years, 12 months ago

  By: Bharat21

• Problem connecting to Integration Services

  Hi, this one has me stumped. I start SQL Server Management Studio for SQL Server 2005 and instead…

  richard-630966

  6 replies

  9 years ago

  By: frantel90

• Convert int date(YYMMDD) to datetime

  I wanted to run this by you guys. I have a date field that I want to convert from an int to date ti…

  drodriguez-762178

  20 replies

  9 years ago

  By: rerlston

• how many additional tempdb files can we add [max limit of tempd files ]

  hi all, what is the max number of tempdb files for a 64 core cpu system which is having 768 gb of r…

  naga.rohitkumar

  3 replies

  9 years ago

  By: Gail Shaw

• Index Rebuild

  Hi All, Can any body please provide me a script which rebuilds the all indexes on all user database…

  Raghavender Chavva

  15 replies

  9 years ago

  By: Gail Shaw

• Not able to restart the MSSQL Server Services

  Hi, I am working on SQL Server 2005 June CTP on Windows 2003 Server SP 1. I restarted my computer b…

  Swapnil Saurav

  17 replies

  9 years ago

  By: nigste3105

• The mail could not be sent to the recipients because of the mail server failure.

  Hi Friends, I am going to configure the Database mail notification on my SQL Server 2005. I have co…

  MSQLDBA

  6 replies

  9 years ago

  By: seanjohns_dba

• Multiple instances on a cluster?

  I'm looking at installing a 2nd instance of sql 2005 on a cluster. Since I haven't done this before…

  WayneS

  21 replies

  9 years ago

  By: Igor Micev

• Database not listed in SSMS object explorer

  I have a sql server 2005 server that has 100+ databases. One of the databases is not listed in the …

  kinzel

  2 replies

  9 years ago

  By: kinzel

• How to configure sql server 2008 memory

  Hello Room, I try to google and seach how to configure the 3GB, but I couldn’t find. The Data Cente…

  Ed7

  18 replies

  9 years, 1 month ago

  By: Gail Shaw