SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Performance issues: dynamic SQL and multiple value conditional

  Hi guys! First time i post there /o/ I would like a better aproach for a procedure i have developed…

  diego_silva_pires

  7 replies

  15 years, 10 months ago

  By: diego_silva_pires

• Production DBA Begineer's Task list ?

  What kind of TASK or Job a Begginer's Production DBA should be ? can anybody list some professional…

  diva.mayas

  4 replies

  15 years, 10 months ago

  By: Nchax Phoku

• Will 12 GB of 'Maximum server memory' work without AWE enabled?

  I'm starting to get a server is out of memory error (MSSQLServerOLAPService Event ID: 123). I'm run…

  Greg_

  3 replies

  15 years, 10 months ago

  By: george sibbald

• date format

  Hello, I have tables with DATE datatype columns which are in format yyyy-dd-mm. My question is how …

  Hadrian

  1 replies

  15 years, 10 months ago

  By: Dave Ballantyne

• Why does SQL Server sometimes block on a simple UPDATE?

  System: SQL Server 2008 SP1 Standard Edition on dual Xeon server. 12G RAM, about 750 GBytes free s…

  David Data

  2 replies

  15 years, 10 months ago

  By: David Data

• script to find obsolete .bak files

  Hi, I am looking for a script (Preferable VB) connects to multiple servers and generate a list (no…

  Sandhya-371593

  2 replies

  15 years, 10 months ago

  By: Steve Jones - SSC Editor

• SQL 2008 Enterprise Eval expired

  SQL 2008 Enterprise Eval has expired. I installed licensed version on same machine but received "ex…

  nano2nd

  2 replies

  15 years, 10 months ago

  By: nano2nd

• SQL Server 2008 Evaluation period expired. Can't use SSMS.

  I think I should know this, but I am currently at a loss. On my desktop I have VS2k8 (w/out SQL ser…

  G-472796

  9 replies

  15 years, 10 months ago

  By: clive-498954

• Insert random values

  Dear Friends, I am wondering if you could give me a hand in this situation. I am a new user for s…

  n_a_h_k

  2 replies

  15 years, 10 months ago

  By: n_a_h_k

• STORED PROC - Amending the 'WHERE' Clause Based on a Passed Parameter

  Hi all, What is the best way to amend the WHERE clause based on a passed parameter in a stored proc…

  RainbowFfolly

  8 replies

  15 years, 10 months ago

  By: RainbowFfolly

• Fulltext Search Service in SQL Server 2008

  Hi, We are upgrading SQL Server 2005 to SQL Server 2008 using in-place upgrade. In SQL Server 2005,…

  Mani-584606

  2 replies

  15 years, 10 months ago

  By: jncarter

• Date or int data type for clustered index ?

  We have a data warehouse fact table which has integer data type for its date dimention, like 201006…

  SQL Guy 1

  10 replies

  15 years, 10 months ago

  By: SQL Guy 1

• IntelliSense Question

  Hi all, To start with I love IntelliSense (especially how it colour-codes everything for instant re…

  RainbowFfolly

  2 replies

  15 years, 10 months ago

  By: WayneS

• replace ment for query analyzer

  Hi Folks, Does anyone know of a simple, light footprint query tool that could replace query analyze…

  David Webb-CDS

  3 replies

  15 years, 10 months ago

  By: dhlotter

• create an Index.

  Hi, below is my sql query,i want to create an index bcz my sql query result showing slow. To increa…

  syedshakeer

  1 replies

  15 years, 10 months ago

  By: Gail Shaw