SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Combining two stored procedures to get one result set.

  I have got two stored procedures as below: ALTER PROCEDURE [rept].[systemActivities] -- Add the p…

  maxlezious

  3 replies

  13 years ago

  By: maxlezious

• Fragmentation

  Hi all. I found there was fragmentation in my server and i rebuild the indexes to remove fra…

  m.rajesh.uk

  9 replies

  13 years ago

  By: m.rajesh.uk

• DBCC DBREINDeX

  Good Day. I noticed that DBCC dbreindex is still available in 2008R2 . Wehn we run this utility to …

  lianvh 89542

  2 replies

  13 years ago

  By: lianvh 89542

• to find specific position string

  Hi friends i have small doubt in sql server , table data contains like id…

  asranantha

  6 replies

  13 years ago

  By: kapil_kk

• Indexes on a Query with a pivot function

  Hi all, Many thanks to the poster that helped me clear up a misconception that I was having with in…

  TheComedian

  1 replies

  13 years ago

  By: Grant Fritchey

• Similar strings.

  In the past week, I saw somewhere a string similarity function. (I think I saw it in my 'spare' tim…

  ben.brugman

  6 replies

  13 years ago

  By: ben.brugman

• Optimizer and stale statistics

  The question is, what happens when statistics on NORECOMPUTE set tables go stale? i.e. pass the row…

  pbowman-543344

  3 replies

  13 years ago

  By: pbowman-543344

• MCTS 70-448 expiring in July 2013

  hi, I want to gain a certification of entry level. I'm working as a BI developer for around 5 years…

  _rohit_

  4 replies

  13 years ago

  By: Ramesh-487525

• mixed data columns

  I currently have a column that have both numeric and characters: Example: 3 PF …

  frdrckmitchell7

  4 replies

  13 years ago

  By: pietlinden

• Convertir texto a fecha en sql server

  Estimados, 🙂 quisiera realizar una consulta acerca de como convertir un formato extraño de fecha, t…

  rcherod

  8 replies

  13 years ago

  By: Jeff Moden

• Virtual CPU limit for SS2008 Standard edition

  If running SQL Server 2008 Standard edition on a VMWare host, am I limited to 4 virtual CPUs?

  iarustj

  2 replies

  13 years ago

  By: iarustj

• MERGE Statement assistance

  Hi all, I am working on an update routine, whereby I have 2 SQL tables that are in different Databa…

  SteveEClarke

  7 replies

  13 years ago

  By: SteveEClarke

• 127rows and I get timeouts?

  I have a table with 127 rows that keeps timing out. the table is used to determine the ROLE of the …

  ghughes

  13 replies

  13 years ago

  By: Grant Fritchey

• PGP encryption/decryption fails as a sql server agent job

  Hi All, I am trying to encrypt the text file before putting it on the SFTP. The package runs fine w…

  ramkidec11

  1 replies

  13 years ago

  By: arnipetursson

• sys.dm_os_memory_clerks Descriptions

  Hi, On one of our Sql Server 2008 R2 instances I'm executing the following query: select top 20 l…

  Chris Kitchen

  2 replies

  13 years ago

  By: Chris Kitchen