SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Optimise procedure sql server 2008

  Hi Experts, I need to optimize the procedure below (SQL Server 2008) and badly need help: I am thin…

  ashvindevil

  11 replies

  11 years, 5 months ago

  By: Sean Lange

• Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'dbo.BDF_Form' because it is not full-text indexed.

  Hi Folks, I have a problem while retrieving a search query , please come up with suitable idea to m…

  lefrancisco1

  1 replies

  11 years, 5 months ago

  By: HanShi

• DDL Trigger - Suspect DB

  Just wanted to ask, is there a suitable way of capturing a database going into suspect mode by mean…

  david.alcock

  2 replies

  11 years, 5 months ago

  By: david.alcock

• CPU usage by Login id

  Guys How it possible to find the top 10 CPU utilization by the login/user in SQL 2008 r2 and above…

  Low Rider

  1 replies

  11 years, 5 months ago

  By: Cláudio Silva

• Healthy Diet And Herbal Supplements For Building Muscles

  An intro to born upbeat is the relation between intelligent approaches to wellbeing and current pra…

  neviealice

  1 replies

  11 years, 5 months ago

  By: Stuart Davies

• Export wizard failed?

  Hi, pl. suggestion me, what could be on issues during export to another new database by export wiza…

  SQL Galaxy

  8 replies

  11 years, 5 months ago

  By: oshobukola

• The benefit of installing Cumulative Update or Service Pack

  Hi All , 1. I wonder what is the benefit of installing Cumulative Update or Service Pack? 2. What h…

  WhiteLotus

  2 replies

  11 years, 5 months ago

  By: WhiteLotus

• Non-SysAdmins have been denied permission to run CmdExec job steps

  Hi Folks I am trying to run job from sql Agent and my first step is containg cmdExec Command but …

  SQlLogic

  7 replies

  11 years, 5 months ago

  By: AmarPo

• Deadlock issues

  I encounter deadlock issues almost every half an hour. Some user gets blocked by somebody. I don't …

  LearningDBA

  2 replies

  11 years, 5 months ago

  By: Shawn Melton

• Query to identify unmatched records for a Foreign Key

  Hello mates!, Grab your coffee and check this out... In this time i would like to ask for your advi…

  JaimePC

  7 replies

  11 years, 5 months ago

  By: sqlslacker

• New To DWH Environment

  HI, I'm new to DWH environment i'm facing lot of performance issues so check u plz let me know the …

  santoshkal

  1 replies

  11 years, 5 months ago

  By: Koen Verbeeck

• How can I update local database data from an online database?

  I have an online database and a local database. How can I update the local database data (only data…

  enriquemallon

  4 replies

  11 years, 5 months ago

  By: enriquemallon

• Find procedures in which CTE is used

  Hi, I want to find the stored procedures where cte is used, as error log is full with incorrect syn…

  Megha P

  1 replies

  11 years, 5 months ago

  By: Johan Bijnens

• count of rows.

  Hi i want count of rows. below query return null value(@count) please tell me how can i get count o…

  chalam87

  6 replies

  11 years, 5 months ago

  By: serg-52

• Anyone know of any real-world case studies on virtualizing SQL Server using vSphere/VMWare?

  I'm only large-ish project (not in production yet) that was originally planning on running our OLTP…

  TheGreenShepherd

  2 replies

  11 years, 5 months ago

  By: TheGreenShepherd