SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• MAXDOP query hint doesn't work- SQL 2008R2 Enterprise Edition

  I have enforced MAXDOP on my query using hint, i have enforce it to 8 but when i look at the task m…

  curious_sqldba

  9 replies

  12 years, 8 months ago

  By: Orlando Colamatteo

• Disable/Enable Account

  Is there any way I can enable/disable a sql/nt account by running a stored poc?

  Tabbasum

  2 replies

  12 years, 8 months ago

  By: Tabbasum

• Select specific set of data from text column

  Hi Experts, How can i select the data from a table where the data is as follows. Requirement: Sele…

  SQListic

  4 replies

  12 years, 8 months ago

  By: SQListic

• Performance Issue: Where do you look?

  I want to know your opinions when a customer says the database is slow today. Usually I would: *Ch…

  Pyman

  11 replies

  12 years, 8 months ago

  By: RTaylor2208

• Copy Default trace from a server to your local machine

  If you wish to replay events captured by the default trace can you copy the files to your local mac…

  PearlJammer1

  4 replies

  12 years, 8 months ago

  By: PearlJammer1

• Restoring Database From Prod to UAT and Not Restoring USER,ROLES, SCHEMAS

  Restoring Database From Prod to UAT and Not Restoring USER,ROLES, SCHEMAS what methods and scripts…

  SQL learner22

  3 replies

  12 years, 8 months ago

  By: ScottPletcher

• Setting up server to add a node to a cluster.

  Ok a bit of a different situation that I am used to so I need a sanity check. Right now I have a on…

  Henry Treftz

  2 replies

  12 years, 8 months ago

  By: Pyman

• sp_configure ‘user options’, 2

  Hi, I accidentally ran the below command and I do not know what changes this command did. sp_conf…

  gary1

  2 replies

  12 years, 8 months ago

  By: HanShi

• Creating a Test environment for a 10TB database

  Hi All, Working on SQL Server 2008 R2 Enterprise Edt. Need to create a testing environment for this…

  Denesh Naidoo

  2 replies

  12 years, 8 months ago

  By: Grant Fritchey

• SQL backup on Cluster shared drive or Local drive.

  I have a SQL server 2008 r2 cluster enviroment. Due to space constraints on the storage drive i had…

  Low Rider

  2 replies

  12 years, 8 months ago

  By: Grant Fritchey

• Error: 17189, Severity: 16, State: 1.

  We're running 2008 SP2, 8 core, 64 GB, Enterprise Edition with about 200-500 connections. have min/…

  Lexa

  7 replies

  12 years, 8 months ago

  By: Hans Lindgren

• select only some rows and then the rest

  Hi Professionals. I am stuck on a way around a query and wonder if it is possible. I want to always…

  Oracle765

  17 replies

  12 years, 8 months ago

  By: Orlando Colamatteo

• Backup during re-index

  We have a database that at times can take up to 18 days to re-index. The database is in simple rec…

  Erin.

  1 replies

  12 years, 8 months ago

  By: Gail Shaw

• Shrink does not release space

  Hi =) Im trying to shrink my production database, because we archived about 200GB of data, but - I …

  JoseRocha

  28 replies

  12 years, 8 months ago

  By: Erland Sommarskog

• virtual servers users lock each other

  Hi Friends -thanks in advance for any help you can provid As shown on the picture above, we have …

  muammer.akilli

  4 replies

  12 years, 8 months ago

  By: Grant Fritchey