SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• using over partition by

  I'm trying to get a count of the l27_mfyp_id based on the below condition in my case statement. Wh…

  ajspencer

  5 replies

  11 years ago

  By: ajspencer

• Check DB Mail Status on All the servers...

  Hi there.. i have 70 SQL database servers and i setup DB Mail on the 70 Servers, i want to know is …

  fawad.majid

  1 replies

  11 years ago

  By: Lowell

• Converting job duration from Job History and use it on email notifications

  I am trying to convert the @runtime to hh/mm/ss format as it's currently printing milliseconds. Ple…

  eedgar 45478

  11 replies

  11 years ago

  By: eedgar 45478

• Use cursor to run dynamic SQL to find special characters used in database

  I need to find all uses of special characters in a database. I used the following code to do this: …

  Mark Finnie

  17 replies

  11 years ago

  By: Ross McMicken

• DATABASE level selection settings help

  Hi All, I have following table structure SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TA…

  Sana4u

  4 replies

  11 years ago

  By: Sana4u

• Insert DATE --Confused with convert

  Hi Experts, I have created a table Employee with Hire_date with datatype as datetime.Then inserted …

  challakarthik

  12 replies

  11 years ago

  By: ScottPletcher

• Help needed- Generate 8 char Alphanumeric Unique Sequence

  Please Help - GENERATE 8 CHARACTER ALPHANUMERIC SEQUENCES Requirements • ALPHANUMERIC FORMAT – >…

  ditha

  32 replies

  11 years ago

  By: DEK46656

• server role / database role precedence question

  user a is sysadmin. user a has public role in db x and nothing in db y which takes precedence? can …

  snomadj

  3 replies

  11 years ago

  By: Gail Shaw

• Need To Improve View Performance

  I have a SQL database with a number of tables that are loaded from an old flat-file system. the pro…

  Chris Wooding

  6 replies

  11 years ago

  By: Chris Wooding

• Performance optimization in stored procedure to perform sorting and filtering

  Hey i want to perform Filtering and sorting in my stored procedure. My filtering criteria would be …

  maria.pithia

  9 replies

  11 years ago

  By: maria.pithia

• Database can't be accessed ...- OFFLINE

  Hi All , I was having issue with one of my databases in SQL EXPRESS. It is offline this morning …it…

  WhiteLotus

  9 replies

  11 years ago

  By: WhiteLotus

• Calculate IOPs for production server?

  We have SQl Server in the production with dozens databases that reside on a SAN in the RAID 1 confi…

  ApolloDB

  7 replies

  11 years ago

  By: gary1

• ? on parsing XML field

  Hi I've looked this up and having a hard time understanding how this works I want to parse out an …

  jbalbo

  3 replies

  11 years ago

  By: Alan Burstein

• What is the Formula to estimate\forecast space for non-clustered index on a table

  Hello, What is the best way to forecast\estimate space for non-clustered index on a table? Example…

  LearnSQL!!!

  7 replies

  11 years ago

  By: ScottPletcher

• SQL Server Install Client tools only

  Hi, in order to keep my legwork to a minimum I am trying to give a number of developers the ability…

  DataDave

  5 replies

  11 years ago

  By: Racer10