SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Select ALL the text from a text data type

  I have a column that is a text data type that contains an xml document. The length of the data…

  andegre

  3 replies

  14 years, 7 months ago

  By: andegre

• sp_executesql()

  Hi, Does anyone know why or how sp_executesql() affects query performance? I found today that a sel…

  PHXHoward

  7 replies

  14 years, 7 months ago

  By: PHXHoward

• A basic question on indexes and string comparisons

  I have two tables: create table Fruit( PK_Fruit int not null, FruitName nvarchar(20) not null) [con…

  TheGreenShepherd

  2 replies

  14 years, 7 months ago

  By: TheGreenShepherd

• Cursor and script to parse IP

  I have a field called ClientIP that holds the IP address of the device. We have several VLAN's and …

  Hyabusact

  3 replies

  14 years, 7 months ago

  By: Hyabusact

• SQL database mail sending failure.

  hi......guys, Date2/17/2012 8:01:56 PM LogDatabase Mail (Database Mail Log) Log ID22 Process …

  Saggy

  5 replies

  14 years, 7 months ago

  By: Ant-Green

• xp_cmdshell Lunacy

  I have a job that has been running fine up until last Friday (Feb. 10th). Starting on Friday, the j…

  PurpleLady

  17 replies

  14 years, 7 months ago

  By: cw.izatt

• How to generate new sequence number in sql server.

  Hi, Is there any function/syntax in sql server like "nextval" for generating new sequence number. H…

  kiran.rajenimbalkar

  5 replies

  14 years, 7 months ago

  By: Jeff Moden

• Answers

  Hi , Can any one answer these 1)What is meaning of switch -m and -c when we bring sql server in…

  ramyours2003

  3 replies

  14 years, 7 months ago

  By: Jeff Moden

• SEQUENCE of A-101,A102

  I am using MSSQL 2008 I am tried for below , where primary key should be in A101,A102 Order No Date…

  pallavi.unde

  3 replies

  14 years, 7 months ago

  By: Divine Flame

• database mail sending problem

  Hi all, Am using Database mail in my project, in my local machine Its working fine for me But I con…

  vsprajeesh

  5 replies

  14 years, 7 months ago

  By: Jared

• DBA Support cost - Per DB ( Unit Pricing Model)

  Hi, For one of the RFP solution we are asked to give the DBA Support cost Per unit ( Different pric…

  ranjeesh007

  2 replies

  14 years, 7 months ago

  By: ranjeesh007

• One time installation of Application with SQL Server

  Hi This is the requirement... There is no need for the client to be aware of underlying database, s…

  SQL006

  4 replies

  14 years, 7 months ago

  By: spaghettidba

• Query optimization

  Purpose : I need to insert data of specific file of specific distributor in Table InvoiceTransactio…

  Saima Khan

  1 replies

  14 years, 7 months ago

  By: Gail Shaw

• Restore to a different File Group

  Is there a way to perform a restore to a different file group? I have a database "DataBase1" whose …

  JazzieG

  1 replies

  14 years, 7 months ago

  By: Ant-Green

• Keyboard shortcut to enable / disable IntelliSense

  Hi there, Is there a keyboard shorcut to turn on / off IntelliSense in Management Studio?

  guerillaunit

  3 replies

  14 years, 7 months ago

  By: Ant-Green