SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL Process hung with PREEMPTIVE_OS_PIPEOPS as lastwaittype

  :w00t: This is my Prod Server , I know this is P1, I was checking the disk space by using xp_cmdsh…

  vkundar

  3 replies

  13 years, 7 months ago

  By: Orlando Colamatteo

• SQL 2005 vs SQL 2008

  I have a client I am writing a VB.NET 2010 program. The client is running SQL SERVER 2005. I am usi…

  lonhanner

  1 replies

  13 years, 7 months ago

  By: Orlando Colamatteo

• SQL Memory

  Hi, Our production server currently using memory 112000 MB against max 109 GB. it is 100% what are …

  HBK_4700

  1 replies

  13 years, 7 months ago

  By: Gail Shaw

• Splitting backups at specified size

  Hey fellow SQL DBA's! Here's something I have been researching - I am trying to create a backup jo…

  kingrudedog

  5 replies

  13 years, 7 months ago

  By: Orlando Colamatteo

• Error With Query

  I Have Two Table Arazi and AraziEghdamat and the Relationship between them is 1(Arazi) to Many(Araz…

  vahid.arr

  4 replies

  13 years, 7 months ago

  By: Steven Willis

• The maximum length of strings. (Varchar(max)).

  Generating code / scripts I run into problems with the length of strings. I use management studio t…

  ben.brugman

  6 replies

  13 years, 7 months ago

  By: Jeff Moden

• Query Optimizer and value of local variable.

  Let's take code example from this article (part Parameters and Variables): CREATE PROCEDURE List_o…

  Shcherbunov Neil

  2 replies

  13 years, 7 months ago

  By: Shcherbunov Neil

• OR vs. UNION

  Hi, I'm made some tests and read about this on some blogs but I'm not sure my conclusions are corre…

  PiMané

  4 replies

  13 years, 7 months ago

  By: PiMané

• Query AD (Active Directory)

  I know you can query AD for logins,email,location but if I want to know if the users are active or …

  kd11

  5 replies

  13 years, 7 months ago

  By: Scott D. Jacobson

• Can't Connect to Remote Server

  Hi experts, 1. I have two servers. Server A and Server B. 2. They are located in two different plac…

  shohelr2003

  2 replies

  13 years, 7 months ago

  By: Thinknook

• STUFF & ISNULL

  Hi, I'm new in SQL Server, i want the working process of STUFF & ISNULL. How it works & h…

  mubarak.a

  3 replies

  13 years, 7 months ago

  By: Gail Shaw

• 8 other pcs are connected through DSN, but..

  I have 8 pcs that are working off of the sql 2008 server, but have another pc that connecting on an…

  54.69.6d.20

  2 replies

  13 years, 7 months ago

  By: 54.69.6d.20

• Using digital certificate

  Hello, How to configure SQL Server engine to use digital certificate? Thanks in advance. Regards, R…

  SQLRO

  1 replies

  13 years, 7 months ago

  By: amit2301

• SQL user test mail not working?

  Hi, Mail session working fine with sysadmin user sa, etc after connect SQL user test mail seesion i…

  SQL Galaxy

  1 replies

  13 years, 7 months ago

  By: Suresh B.

• unable to start the sql service

  when we are moving tempdb from d to f drive , files are successfully moved . when we tried to res…

  ramyours2003

  2 replies

  13 years, 7 months ago

  By: Suresh B.